SQL Server Performance

Performance Counter Values - Memory Pages/Sec

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Balasundaram, Apr 25, 2007.

  1. Balasundaram New Member

    Counter_Name Average Minimum Maximum
    -----------------------------------------------------------------------------------------
    Memory: Pages/sec 10201777
    Memory: Available Bytes 209731344183275520258355200
    Physical Disk: % Disk time001411
    Physical Disk: Avg. Disk Queue Length 0042
    Processor: % Processor Time 5045
    System: Processor Queue Length 003
    SQL Server Buffer: Buffer Cache Hit Ratio 10094100
    SQL Server General: User Connections 10399105

    The above are the values captured through performance monitor. As per the statement given in this site that the Memory: Pages/Sec should be less than 20, but in this case it is 102. This is taken from the sql server production box(clustered) and there are no other applications running.

    Could anyone advice whether the Memory: Pages/Sec value is proper and also the rest?
  2. techbabu303 New Member

  3. Balasundaram New Member

    I have read this article already.

    In this article they mentioned that the pages/sec average should be below 20. There is no maintenance plan and no other applications running on this system.

    I have also checked the memory settings and the values are:
    Min - 0
    Max - 2147483647

    And still i dont understand why the average pages/sec is 102.

    Thanks,
    Bala
  4. satya Moderator

  5. Luis Martin Moderator

    Is SQL dedicated?. Any anti virus?


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  6. Balasundaram New Member

    Yes, the SQL is dedicated one.

    Yes, Anti Virus Is Running.

    Thanks,
    Bala
  7. techbabu303 New Member

    - When u see high page/sec better to plot it against line graph and see which duration of day it stays high, thne investigate from there on.

    -Hardware configurations on the server plays vital role also, if you can describe RAM,CPU ....

    Cheers
    Sat
  8. MohammedU New Member

    What about PLE (Page Life Expectency)?
    What is the toal server and configured memory? what edition of sql you are on?
    Do you see any perfomance issues other than counter is high?


    PerfMon: High Number of Pages/Sec Not Necessarily Low Memory
    http://support.microsoft.com/default.aspx/kb/139609
    http://support.microsoft.com/kb/889654


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  9. satya Moderator

    As the anti-virus is installed on SQL you would expect to see jump in pages/sec and memory utilization in this case. I would suggest to take benchmarks by stopping Anti-virus in this case.

    quote:Originally posted by Balasundaram

    Yes, the SQL is dedicated one.

    Yes, Anti Virus Is Running.

    Thanks,
    Bala

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page