SQL Server Performance

Page Splits/sec <20 per 100 Batch Requests/Sec

Discussion in 'Performance Tuning for DBAs' started by Akthar Hussain, Oct 14, 2011.

  1. Akthar Hussain New Member

  2. preethi Member

    I am sure you are going to get "It depends" type of answer.
    Batch requests says the number of requests which includes selects and amendments They are not limited to a table.
    Page splits are serious and going to hurt you if it happens in a table where large number of scan operations happen. So you need to dig more to see the table where splits occur. So I will be more than scared to give a number.
    The most important question is are you seeing any performance issues already? If so any number greater than 0 is not a good number.
  3. satya Moderator

    Yes, as Preethi said IT DEPENDs type of answer as it purely coincides with hardware and TEMPDB setting on your server.

Share This Page