Justifying a memory upgrade

Posted by AngryHacker on Server Fault See other posts from Server Fault or by AngryHacker
Published on 2010-04-01T01:44:32Z Indexed on 2010/04/01 1:53 UTC
Read the original article Hit count: 603

My employer has over a thousand servers (running SQL Server 2005 x64 and a couple of other apps) all across the country. And in my opinion they are all massively underpowered for what they need to do.

Specifically, I feel that the servers simply do not have enough RAM for the amount of volume the machines are asked to do. All the servers currently have 6GB of RAM. The users are pretty much always complaining about performance (mostly because, immo, the server dips into the paging file quite often).

I finally convinced the powers that be to at least try out a memory upgrade on one box and see the results. However, they want before and after metrics, so that they can see that the expense will be justified.

My question is what metrics should I collect to see whether the performance truly improves on the box? I am a dev, so I am not sure how and what to collect (i have a passing knowledge of Perfmon).

© Server Fault or respective owner

Related posts about windows-server-2003

Related posts about x64