The paper is divided in three sections:

  • Looking at your first query explains what are the events to observe in the Profiler and guide you Step-by-Step in reading them for a simple query
  • Formula Engine and Storage Engine shows the different roles of the two engines and how to identify which operations are performed by each engine
  • Events in Progress analyzes a non-trivial query and illustrates the differences in query plans of more optimized DAX versions of the same query

The goal of the paper is to introduce the reading of a query plan. A more detailed analysis of each operation in the query plan will be the topic of a future paper.