SQL Server Performance

so many Pages/Splits when delete ?

Discussion in 'T-SQL Performance Tuning for Developers' started by rainbow, Apr 18, 2004.

  1. rainbow New Member

    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
  2. satya Moderator

    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.

Share This Page