Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks

Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services  such as MDX queries, data mining etc. For any sort of performance analysis exercise you must identify the source(s) of the performance bottlenecks in the execution of a poorly performing MDX query. In the OLTP scenario you would go with TSQL query performance loss, by using SYSMON & PROFILER.

Well thats another world if you see that within Data Warehousing environment, so this Best Practices article provides the information about the available tools and demonstrates how to use the most common of these tools to identify and resolve MDX query performance bottlenecks with individual MDX queries.