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=’![Smile :) :)](styles/default/xenforo/smilies/smile.png)
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>