Understanding Perfmon Counters while troubleshooting SQL Server Performance Issues

Links for using Performance Counters (perfmon) while troubleshooting SQL Server related issues

SQL Server SSIS and Replication — Thu, 06 Nov 2008 18:45:00 GMT

Understanding Performance Counters data while troubleshooting Performance issues in SQL Server: http://blogs.technet.com/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

Performance Monitor, SQL Counters and Tresholds

There's Something about SQL! — Mon, 17 Nov 2008 13:04:54 GMT

Whilst surfing on the web last week, I've found this very nice blog from Vipul Shah, which happens to

re: Understanding Perfmon Counters while troubleshooting SQL Server Performance Issues

acollins74 — Wed, 03 Dec 2008 15:33:08 GMT

you mention above PhysicalDisk\Avg. Disk Queue Length should be number of spindles plus two but I believe thats a typo. I have always gone by the rule its the number of spindles times two.

re: Understanding Perfmon Counters while troubleshooting SQL Server Performance Issues

bradmcgehee — Sat, 20 Dec 2008 04:28:27 GMT

Hi. I was reading this blog and noticed that many of the recommendations you make in it are significantly different that from other sources claim. I am curious as to where these numbers come from. Are they based directly on research done at Microsoft, and are they the "official guidelines" from Microsoft for this particular counters? And one more thing, do these recommendations apply to all versions of SQL Server, or to just some versions of SQL Server?