Monitoring performance with DAX Studio

In the previous section, we learned that part of the process of executing a DAX query results in the calculation engine producing a logical query plan and a physical query plan. In addition, when attempting to optimize a slow DAX query it helps to understand which elements are carried out by the formula engine and which are carried out by the storage engine. To help us with both processes, we're going to look at using DAX Studio, a third-party tool that we've looked at briefly in previous chapters.

To follow along with this section, you will need to download and install DAX Studio, which is available from: https://daxstudio.org

Once you have installed DAX studio, you will be able to create links to tabular ...

Get Hands-On Business Intelligence with DAX 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.