You need to monitor processor resources

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?

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.



Leave a Reply 0

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