Post reply

Memory Performance Counters

  • January 25, 2005 at 3:52 am

    #110088

    I am currently running some performance stats against our SQL server.

    I have been looking at CPU, Memory and Disk IO but am confused by the counter Memory - Page Faults/sec, what would an average be for this counter for reasonable performance. Whilst i'm on the topic aswell, what is a good figure for Memory - Pages/Sec?

    Thanks in advance.

  • January 26, 2005 at 12:24 pm

    #539219

    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, except for occasional spikes, which are normal. If this is not the case, and this counter averages greater than 1, but less than 20, you still won't notice much of a performance degradation in SQL Server. But if the counter averages over 20 in a 24 hour period, then your server most likely needs more RAM."
    You can read this article to find more about other performance counters. It has as well very usefull links on performance articles and sites:
     
     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply