<div>
Hi,<br />
<br />
To check the physical resources on the server we use:<br />
<br />

<div class="bullet">
\\Processor(*)\*
</div>
<div class="bullet">
\\PhysicalDisk(*)\*
</div>
<div class="bullet">
\\Memory\*
</div>
<div class="bullet">
\\NetworkInterface(*)\*
</div>
<br />
The additional ones we use for SQL are:<br />
<br />

<div class="bullet">
\\SQLServer\GeneralStatist<wbr />ics\*
</div>
<div class="bullet">
\\SQLServer\BufferManager\<wbr />*
</div>
<div class="bullet">
\\SQLServer\MemoryManager\<wbr />*
</div>
<div class="bullet">
\\SQLServer\WaitStatistics<wbr />\*
</div>
<br />
In all cases we use a sample interval of 5 seconds which is suitable for a performance study. &nbsp;If you want trend type reporting a sample interval of 1 minute is more realistic.<br />
<br />
For CSV, create a Data Collector Set with the counters you want to capture. &nbsp;After you've OK'd it double click on the collector set to show the data collector (there should be one). &nbsp;Right click on the data collector and choose Properties. &nbsp;Under the Performance Counters tab you should have a prompt for Log Format; one option is Comma Separated. &nbsp;I'm assuming Win2008 R2 here.<br />
<br />
Best regards..Paul
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
With Windows Performance Monitor and measuring SQL Server performance, what are some of the typical counters to use to track SQL Server performance.<br />
<br />
Also, how to record the history into a CSV file?<br />
<br />
Thanks.
</div>
</div>


Hello,

With Windows Performance Monitor and measuring SQL Server performance, what are some of the typical counters to use to track SQL Server performance.

Also, how to record the history into a CSV file?

Thanks.

Hi,

To check the physical resources on the server we use:

\\Processor(*)\*
\\PhysicalDisk(*)\*
\\Memory\*
\\NetworkInterface(*)\*

The additional ones we use for SQL are:

\\SQLServer\GeneralStatistics\*
\\SQLServer\BufferManager\*
\\SQLServer\MemoryManager\*
\\SQLServer\WaitStatistics\*

In all cases we use a sample interval of 5 seconds which is suitable for a performance study.  If you want trend type reporting a sample interval of 1 minute is more realistic.

For CSV, create a Data Collector Set with the counters you want to capture.  After you&#39;ve OK&#39;d it double click on the collector set to show the data collector (there should be one).  Right click on the data collector and choose Properties.  Under the Performance Counters tab you should have a prompt for Log Format; one option is Comma Separated.  I&#39;m assuming Win2008 R2 here.

Best regards..Paul

Need SQL Server performance counters

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.