You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
The database allows for the processing of predefined and informal queries. There is, however, a
suspicion that some queries will consume too much of the available resources. You want to
identify the queries that consume the majority of the resources.
Which of the following actions should you take?

A.
You should consider making use of the sys.dm_exec_sessions dynamic management view
(DMV).

B.
You should consider making use SQL Server Profiler templates.

C.
You should consider making use of the sys.dm_exec_requests dynamic management view
(DMV).

D.
You should consider making use of the sys.dm_exec_query_stats dynamic management view
(DMV).

Explanation: