Which Dynamic Management Views (DMVs) should you use to find details about specific queries?

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.)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *