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: 295
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