There are a variety of things that you can do to improve the
performance of an individual MDX query. To begin, you must identify the
source(s) of the performance bottlenecks in the execution of a poorly
performing MDX query. To identify the source(s) of performance
bottlenecks, you need to understand how to use the available Microsoft
Windows and SQL Server 2005 Analysis Services troubleshooting tools to
assist you with identifying bottlenecks and learn how to interpret the
information revealed by these tools. This 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.
Download