Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Performance Monitor Counters for SQL Server performance testing

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"
Author: Jack Vamvas (http://www.sqlserver-dba.com)

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.