Performance Tuning and Troubleshooting Tabular Models - SQL Server Analysis Services 2012 Cube Development - page 412

There's more…
Each entry in the table provides detailed information about different activities per-
formed by Analysis Services. Click on each row to view the trace details in the pane
under the grid. If you look at each row, it will essentially tell you the story of what
went on, beginning with setting up the query, choosing the slicer value, choosing a
filter value, preparing an execution plan, and then executing the query. Scroll to the
right and note the Duration and CPUTime columns. These values tell you the num-
ber of milliseconds it took for those events.
You can use the SQL Server Profiler with the SQL Server Management Studio to re-
produce a query for further analysis. You should first clear the SSAS query cache to
avoid masking a query performance issue with cached results from a previous query
execution by performing the following steps:
1. Switch to SQL Server Management Studio .
2. Add a few carriage returns to the end of the text in the open query window.
3. Add the following XML/A query, adding the name of the deployed database
instead of the --Database Name-- placeholder: