Which trace event should you use?

You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to troubleshoot query performance by using SQL Profiler.
You need to identify the queries that take a long time to run.
Which trace event should you use?

You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You plan to troubleshoot query performance by using SQL Profiler.
You need to identify the queries that take a long time to run.
Which trace event should you use?

A.
Query Cube End

B.
Query Subcube

C.
MDX Script End

D.
Get Data from Cache



Leave a Reply 0

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