get the app get the app       get the app       get the app

Question: 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?

1)Query Cube End
2)Query Subcube
3)MDX Script End
4)Get Data from Cache

Previous Next

Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence

Recommended Learning for you

Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material