<div>
cheap way is perfmon. &nbsp;it can monitor all you want, and can do it remotely. &nbsp;it also does graphs.<br />

</div>


cheap way is perfmon.  it can monitor all you want, and can do it remotely.  it also does graphs.


<div>
<div class="content wysiwyg-content">
Dear DBA experts,<br />
<br />
Am looking for a good tool for Capcity Planning in MS SQL Server 2005<br />
for monitoring &amp;&nbsp;estimating memory configuration for new servers.<br />
Bascially I need to measure CPU,IO,MEM utilization on various existing &nbsp;SQL servers <br />
and make a statistical report &nbsp;(excel sheet or a graph ) on daily/weekly/monthly basis <br />
and also note peak times.<br />
<br />
I would really appreciate if anyone can suggest me a good script both at OS and Server level<br />
or suggest me a good tool to gather all this information, so that i suggest management<br />
the New Hardware configuration required.<br />
<br />
TIA,<br />
Kish.
</div>
</div>


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.

TIA,
Kish.

Tool - for capacity planning in SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.