Microsoft has released a valuable white paper with a self-explaining title: SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services.

The document has a part of explanation of terms and counters, and a large part of sample queries with a detailed tutorial teaching how to use SQL Profiler, with many comments about obtained results.

It’s a must read.

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2007/09/03/mdx-query-performance-bottlenecks-in-ssas-2005.aspx