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 more than 10 commands prior to
disconnecting. 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 more than 10 commands prior to
disconnecting. Which DMV should you use?

A.
Discover_Sessions

B.
Discover_Traces

C.
Discover_Commands

D.
Discover Connections



Leave a Reply 0

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