Justifying a memory upgrade, take 2
        Posted  
        
            by AngryHacker
        on Server Fault
        
        See other posts from Server Fault
        
            or by AngryHacker
        
        
        
        Published on 2010-04-22T17:01:39Z
        Indexed on 
            2010/04/22
            17:03 UTC
        
        
        Read the original article
        Hit count: 334
        
Previously I asked a question on what metrics I should measure (e.g. before and after) to justify a memory upgrade. Perfmon was suggested.
I'd like to know which specific perfmon counters I should be measuring. So far I got:
PhysicalDisk/Avg. Disk Queue Length (for each drive)
PhysicalDisk/Avg. Disk Write Queue Length (for each drive)
PhysicalDisk/Avg. Disk Read Queue Length (for each drive)
Processor/Processor Time%
SQLServer:BufferManager/Buffer cache hit ratio
What other ones should I use?
© Server Fault or respective owner