You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.
Now you are employed in a company which is named NaproStar and you are in charge of a SQL Server 2008 Analysis Services (SSRS) instance for the company.
According to your plan, a Dynamic Management View (DMV) will be used to troubleshoot query performance.
Now you get an order from your manager, according to his requirements, query sessions that execute a query for more than 30,000 ms should be identified.
So of the following DMV, which one would be used?
A.
Discover_Sessions would be used
B.
Discover_Commands would be used
C.
Discover_Connections would be used
D.
Discover_Traces would be used
E.
Discover_Wizard would be used