I just wanted to take a moment to thank Kevin Kline, Brent Ozar, Christian Bolton, Bob Ward, Rod Colledge and Raoul Illyaos for creating the SQL Server PerfMon Counters of Interest PDF file available for download on Quest.com. If you ever have to dig into some serious performance monitoring, this pdf will definitely help you. It tells all kinds of great values to look for and even gives you some good benchmark values that you want. I only wish they would have released this back in September when I was doing some heavy benchmarking and I/O analysis for a client. J
The PDF file is an exploded version of the below screenshot:
This site has other great ebooks, so check out the site, register for a free account and do some performance tuning on your SQL Server! You’ll be glad that you did! Please be sure to follow me on twitter at @briankmcdonald. Also note that you can subscribe to an RSS feed of my blogs or find me at any of the below methods.
Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant