SQL Server Performance

Pages/sec averages greater than 20

Discussion in 'Performance Tuning for DBAs' started by c_maldon, Mar 18, 2003.

  1. c_maldon Member


    I read

    "Memory: Pages/sec
    Assuming that SQL Server is the only major application running
    on your server, then this figure should average near zero
    over a 24 hour period "

    I used perfmon like that and my average is 160

    1- the only application running on my server
    2- Buffer Cache Hit Ratio average 99,88
    3- SQL Server is set to the "Dynamically configure SQL Server memory" option

    Do I need more RAM or something wrong?

  2. trifunk New Member

    How much memory does the box have and what OS are you running on?
    Since the cache hit ratio is high and the average pages/sec is 160 over 24 hours is it possible that there are certain times in the day when the excessive paging occurs and it's not a constant figure (could be caused during backups)?

    Cheers
    Shaun

    World Domination Through Superior Software
  3. bradmcgehee New Member

    Backups, restores, transaction log backups, and file copies can all cause the pages/sec to run high. But these are temporary and are not a cause for concern. So if you have eliminated all of these influences, and your pages/sec is still very high, then I must assume that your server needs more RAM.

    It is also possible that some SQL Server setting is not at its default value, or that your disk subsystem is causing the problem. In a few servers, I have seen disk subsystems produce very high pages/sec for no apparent reason. I don't know what causes this or how to avoid it.

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

Share This Page