You can never get too many of these things right? Today I was perusing the internet and found over on Kevin Kline's blog a link to a free perfmon poster from the great folks at Quest.com. Don’t you notice these days that all of the super-big SQL Server guys have more than one blog now? How the hell does anyone have time to keep up with twitter, multiple blogs, facebook, etc. and get anything done??? Unknown at this point in time.
Anyway, check out these counters – they’re pretty good. I am an acquaintance of one of the guys on there, Brent Ozar, a super-stud SQL Dude, MVP, MCM, et. al., so you know some decent people authored the list. I think that you can either get the .pdf, or order a poster to stick on your ceiling in your bedroom as an option.
Keep in mind, on these counters – use them in combination, and don’t take a single counter and make a decision based solely on it’s value. In other words, use them in conjunction with others, and try to create your own correlations. Also, use good judgment by comparing the suggested values here with other values as well as those that you may have developed from experience. If you can find trends and patterns in the movement of one and its affect on others, you are making great progress in identifying the behavior of a SQL Server.
Thanks for reading,
Lee Everest
--------------------------------
Here’s a jim-dandy that I ran into today … SELECT COUNT(*) FROM [tablename] WITH(nolock,readuncommitted)
http://www.quest.com/backstage/images/promotions/SQLServer-Perfmonance-Poster.pdf
14119abd-462a-4a90-b74c-e8752a91211e|0|.0