Microsoft
70-448 · Question #298
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…
The correct answer is C. Discover_Commands. See the full explanation below for the reasoning.
Question
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?
Options
- ADiscover_Traces
- BDiscover_Sessions
- CDiscover_Commands
- DDiscover_Connections
How the community answered
(50 responses)- A8% (4)
- B14% (7)
- C74% (37)
- D4% (2)
Community Discussion
No community discussion yet for this question.