Microsoft
70-432 · Question #203
You administer a Microsoft SQL Server 2008 R2 database instance. You need to identify queries or stored procedures that are consuming server resources. You also need to view the query plan that is…
The correct answer is A. dm_io_virtual_file_stats B. dm_exec_sql_text D. dm_exec_connections. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2008 R2 database instance. You need to identify queries or stored procedures that are consuming server resources. You also need to view the query plan that is being used by each of these queries or procedures. Which Dynamic Management Views (DMVs) should you use to find details about specific queries? (Choose all that apply.)
Options
- Adm_io_virtual_file_stats
- Bdm_exec_sql_text
- Cdm_exec_query_stats
- Ddm_exec_connections
- Edm_exec_query_plan
How the community answered
(42 responses)- A71% (30)
- C10% (4)
- E19% (8)
Community Discussion
No community discussion yet for this question.