Which DMV should you use?

You administer a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to troubleshoot query performance by using a Dynamic Management View (DMV).
You need to identify query sessions that execute a query for more than 30,000 ms.
Which DMV should you use?

You administer a SQL Server 2008 Analysis Services (SSAS) instance.
You plan to troubleshoot query performance by using a Dynamic Management View (DMV).
You need to identify query sessions that execute a query for more than 30,000 ms.
Which DMV should you use?

A.
Discover_Traces

B.
Discover_Sessions

C.
Discover_Commands

D.
Discover_Connections



Leave a Reply 0

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