Monday, January 10, 2011

Free (Reg-ware) SQL Server Perfmon Counters Poster. Counters + Descriptions + “values you want to see” = Happy DBA

image%5B11%5D.png?imgmax=800

When it comes to performance monitoring, few tools offer as much reliability and universal access as Perfmon — and that alone makes it worth learning. Its counter thresholds give you a clear picture, so you can diagnose the root-cause of your SQL Server issues right away. And now you can do it all even faster with this unique reference.
This poster — produced by our world-class SQL Server experts at Quest — provides valuable tips and tricks to remember when using Perfmon. It will help you quickly build a hypothesis and uncover the slowest components on your servers.
…”
What I really like about this poster is how not only are the counters listed, with description, but what the normally acceptable values of those counters should be. Given that there’s 1.9 gazillion perform counters, knowing the “good ones” and their values is a step toward SQL Server guru’ism.

Read more: Greg's Cool [Insert Clever Name] of the Day