There are more than abundant whitepapers, books and forum discussions on what performance counters to collect and how to interpret their values. I’ve recently bumped into a very good wrap-up for this trade of analyzing useful performance counter logs.
Please go to the original link here to have a good read; courtesy to another SQL guru ‘grumpyolddba’ on from the interweb, who is also a regular on sqlservercentral.com.
A bit more on the topic of performance counters, Brent Ozar has a very good presentation about it too:
[vimeo 10728198 w=400 h=300]
Leave a Reply