Summary
In this chapter, we started with a summary of the engines in the Analysis Services process – formula and storage engines. Understanding where the processing time is taken is a good start for performance tuning a semantic model. We then introduced the performance analyzer as a built-in tool to help you assess performance for report visuals.
Breaking processing into querying, visualizing, and the other aspects helps focus performance tuning with durations and metrics. It lets you copy queries for analysis in other tools. Next, we looked at log files for durations of actions. Transforming the exported data was assisted by hierarchies as well as techniques for using it with the performance analyzer.
We concluded by looking at external tools. The first was DAX Studio, where we can see DAX queries analyzed for performance in the engines. Query diagnostics in Power Query helped analyze extraction code for timings. Tabular Editor was talked about in terms of changing metadata...
