SQL Server Performance Forum – Threads Archive
so many Pages/Splits when delete ?when delete records , many Pages/Splits occured (about 160 Pages/Splits) , is this a issue ? why ?<br /><br />thanks <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br /><br />—-<br />enjoy everything you should enjoy
How about indexes on the involved tables and hardware of the SQL server?
Check event viewer log for any information on H/w issues. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.