Which event class should you use?

You are troubleshooting query performance for a SQLServer Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query s
tatement in a trace by using SQL Server Profiler.
Which event class should you use?

You are troubleshooting query performance for a SQLServer Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query s
tatement in a trace by using SQL Server Profiler.
Which event class should you use?

A.
Query Begin

B.
Get Data From Aggregation

C.
Calculate Non Empty Begin

D.
Query Subcube

E.
Progress Report Begin

F.
Execute MDX Script Begin



Leave a Reply 0

Your email address will not be published. Required fields are marked *