Share via


Performance Monitor, SQL Counters and Tresholds

Whilst surfing on the web last week, I've found this very nice blog from Vipul Shah, which happens to be a Microsoft colleague, which explains which are the key performance counters to monitor for your SQL Server instances and most importantly summarizes which are generally the thresholds you want these counters to fit within.

 

Understanding Perfmon Counters while troubleshooting SQL Server Performance Issues

https://blogs.technet.com/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

 

You should consider to use these counters to monitor and benchmark your SQL Server boxes, and then of course you can review results through Performance Monitor itself  or through PAL:

 

Performance Analysis of Logs (PAL) Tool

https://blogs.technet.com/beatrice/archive/2008/04/02/performance-analysis-of-logs-pal-tool.aspx

 

- Beatrice Nicolini -