Monitoring and tuning MDX queries
The best monitoring tool for MDX queries is SQL Server Profiler, which you could launch by navigating to Start | All Programs | SQL Server 2012 | Performance Tools | SQL Server Profiler. Profiler records various phases of the query execution, including the retrieval of data from partitions or dimensions, querying aggregations or memory cache as well as displaying the results to the application. Based on the Profiler output, we can surmise whether SSAS spends most of its execution time retrieving data from the storage engine or in the formula engine, meaning deriving calculated values after the data retrieval is complete.
How to do it...
Follow these steps for monitoring and tuning MDX queries.
- Once the Profiler is ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
