Tool - for capacity planning in SQL Server 2005
Posted on 2010-01-08
Dear DBA experts,
Am looking for a good tool for Capcity Planning in MS SQL Server 2005
for monitoring & estimating memory configuration for new servers.
Bascially I need to measure CPU,IO,MEM utilization on various existing SQL servers
and make a statistical report (excel sheet or a graph ) on daily/weekly/monthly basis
and also note peak times.
I would really appreciate if anyone can suggest me a good script both at OS and Server level
or suggest me a good tool to gather all this information, so that i suggest management
the New Hardware configuration required.