Performance Monitor Counters for SQL Server performance testing

23 September,2011 by Jack Vamvas

I posted  Window Perfmon scripting, SQL Server perfmon and how to perfmon which refers to a performance monitor counters.

The  perfmon counters I use for SQL Server performance testing are listed below.

I place the list below into the perfmon_base_counters.cfg  file.

Note: some modifications need to occur , such as Drive letters and SQL Server Instances below. Adjust accordingly.  

 

"\Memory\Available MBytes"
"\Memory\Page Faults/sec"
"\Memory\Pages/sec"
"\Memory\Paging File(_Total)\%Usage"
"\Processor(_Total)\% Privileged Time"
"\Processor(_Total)\% Processor Time"
"\Processor(_Total)\% User Time"
"\Processor(_Total)\Interrupts/sec"
"\System\Context Switches/sec"
"\Network Interface\Packets Sent/sec"
"\Network Interface\Packets Received/sec"
"\LogicalDisk(H:)\Disk Reads/sec"
"\LogicalDisk(I:)\Disk Reads/sec"
"\LogicalDisk(J:)\Disk Reads/sec"
"\LogicalDisk(H:)\Disk Writes/sec"
"\LogicalDisk(I:)\Disk Writes/sec"
"\LogicalDisk(J:)\Disk Writes/sec"
"\MSSQL$MYINSTANCE:SQL Statistics\SQL Compilations/sec"
"\MSSQL$MYINSTANCE:SQL Statistics\SQL Re-Compilations/sec"
"\MSSQL$MYINSTANCE:General Statistics\Logins/sec"
"\MSSQL$MYINSTANCE:General Statistics\Logouts/sec"
"\MSSQL$MYINSTANCE:SQL Statistics\Batch Requests/sec"
"\MSSQL$MYINSTANCE:Databases(_Total)\Transactions/sec"

 Read More

SQL Server - Find last sql statement based on SPID - SQL Server DBA

SQL Performance tuning - Asking the right question

SQL Server – netstat monitoring and tuning performance

Mobile Commerce and SQL Performance Tuning

The future of the SQL Server Performance Tuning Expert


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Performance Monitor Counters for SQL Server performance testing


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer