SQL Server Performance

What is too high for th Page Splits/sec counter?

Discussion in 'Performance Tuning for DBAs' started by flachance, Feb 26, 2003.

  1. flachance New Member

    I was reading the Feb. 25 newsletter and in the first tip, Brad mentions that when monitoring the SQL Server Access Methods object: Page Splits/sec it might indicate that you have a high page split occurence. My question is "What exactly is high?"

    I'm getting an average of 0.02 on my database and I'm assuming that this would be considered low. This database has mostly inserts happening, very few updates and many selects.

    Thanks,

    Francois
  2. sqljunkie New Member

  3. bradmcgehee New Member

    Yes, 02 would be very low. In fact, this is about what I am running now in one of my busier databases.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page