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.)
A.
dm_io_virtual_file_stats
B.
dm_exec_sql_text
C.
dm_exec_query_stats
D.
dm_exec_connections
E.
dm_exec_query_plan