Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet

In this post, we’re going to run through the list of Performance Monitor (Perfmon) counters that you’ll want to collect along with an explanation about the type of performance-related information the provide.

Note: The bulk of this (very long) post is based on knowledge I’ve obtained through (multiple) readings of the books, whitepapers, and blog posts written by top Analysis Services professionals (referenced at the bottom) as well as my own personal experience dealing w/ performance-related issues for many clients over the years. 

Due to the length of this blog post (/wiki) I’ve included some links to help navigate the sections. For those who are only interested in the list of counters, feel free to skip to the bottom where you can find a simple list of all counters discussed in this post.

Read more...