Using Trace to Monitor and Audit Analysis Services - Microsoft SQL Server 2008 Analysis Services - page 777

FIGURE 38.11

SQL Server Profiler shows the events for your MDX query.

After the serialization events comes a set of progress report events telling you that the
storage engine is reading data from the Warehouse and Sales partition. After it generates
Query Subcube and Query Subcube Verbose events, the server starts steaming cell data to
the client.

Changing the Simple Query

With our sample MDX query, the Warehouse and Sales cube doesn't have any aggrega-
tions. If you were to design aggregations for the sample Warehouse and Sales cube and
send the same query, SQL Server Profiler would show you additional events associated
with the query resolved from the aggregations (shown in Figure 38.12). For more informa-
tion about aggregations, see Chapter 23, “Aggregation Design and Usage-Based
Optimization.”