You maintain a SQL Server 2008 instance.
You use the Resource Governor to manage processor resources on the server for a newly
deployed application named App1. App1 is assigned to a custom workload group named
MyApp.
You need to monitor processor resources.
What should you do?
A.
Use the request_max_cpu_time_sec column of the
sys.resource_governor_workload_groups catalog view.
B.
Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the
SQLServer:Workload Group Stats performance object for the default workload group.
C.
Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the
SQLServer:Workload Group Stats performance object for the MyApp workload group.
D.
Use the sys.dm_resource_governor_workload_groups dynamic management view to
monitor the CPU usage for the default workload group.