How to tell if an aggregation is hit?

[asocorro]

The documentation here:

http://tinyurl.com/ybxnw8a7

says to use the SQL Server Profiler event "Query Processing\Aggregate Table Rewrite Query", but I don't see it.  Do I need to do anything special to make it appear?  Thanks.

[kadirkkkk]

You can copy the dax code via "Performance Analyzer" in Power in then paste it to DaxStudio and run. You'll see which order and which tables does the query runs.

[Anonymous]

In Performance Analyzer, look for your Matrix.  If you don't see DirectQuery, then it's using an in-memory table.  Assuming your Aggregate tables is an aggregate of a DirectQuery table, this will be you indicator that it used the in memory aggregate.

[v-piga-msft · Accepted solution]

Hi @asocorro,

The document does not show the details steps how to find out whether a query hit an aggregation or not.

By my research, this article will be more helpful which includes more details steps.

Best Regards,

Cherry

[asocorro]

Thanks, that was a great step-by-step.  My question was answered by this note in the article:

Please note that if your SSMS version is older than v 17.9, you will not see “Aggregate Table Rewrite Query” event in event selection area.

Cheers,

Adolfo