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

PrepAway - Latest Free Exam Questions & Answers

A.
Discover_Sessions

B.
Discover_Traces

C.
Discover_Commands

D.
Discover Connections


Leave a Reply