PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Discover_Traces

B.
Discover_Sessions

C.
Discover_Commands

D.
Discover_Connections


Leave a Reply