Common SQL Server Performance Counters

Somebody asked me what are the common SQL Server Performance Counters to monitor for bottlenecks and unusual activity on the server.

The list of common SQL Server Performance counters is as below:

  • SQLServer:Access Methods – Full Scans / Sec
  • SQLServer:Access Methods – Table Lock Escalations / Sec
  • SQL Server:Buffer Manager – Buffer Cache Hit Ratio
  • SQL Server:Buffer Manager – Database Pages
  • SQL Server:Databases – Active Transactions
  • SQL Server:Databases – Log growths
  • SQL Server:Databases – Transactions / Sec
  • SQL Server:General Statistics – User Connections
  • SQL Server:Locks – Lock Requests / Sec
  • SQL Server:Locks – Average Wait Time
  • SQL Server:Locks – Number of Deadlocks / Sec
  • SQL Server:SQL Statistics – SQL Compilations / Sec
This entry was posted in SQL Server and tagged , , . Bookmark the permalink.

Leave a Reply