Microsoft
70-448 · Question #231
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 A. Discover_Sessions. 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 more than 10 commands prior to disconnecting. Which DMV should you use?
Options
- ADiscover_Sessions
- BDiscover_Traces
- CDiscover_Commands
- DDiscover Connections
How the community answered
(37 responses)- A76% (28)
- B16% (6)
- C5% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.