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
http://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
http://blogs.technet.com/beatrice/archive/2008/04/02/performance-analysis-of-logs-pal-tool.aspx
- Beatrice Nicolini -
