1.

You maintain a SQL Server 2008 Analysis Services (SSAS) database.You are troubleshooting query performance by using SQL Profiler.You are identifying the queries that take a long time to run. You determine the time used by the Storage Engine.You need to determine the time used by the Formula Engine.What trace event should you use?

A. Query Cube End
B. Query Subcube
C. MDX Script End
D. Get Data from Cache
Answer» B. Query Subcube


Discussion

No Comment Found