Microsoft
70-432 · Question #219
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…
The correct answer is C. Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the request_max_cpu_time_sec column of the sys.resource_governor_workload_groups
- BUse the sys.dm_os_performance_counters to monitor the CPU usage % counter of the
- CUse the sys.dm_os_performance_counters to monitor the CPU usage % counter of the
- DUse the sys.dm_resource_governor_workload_groups dynamic management view to monitor
How the community answered
(57 responses)- A4% (2)
- B16% (9)
- C74% (42)
- D7% (4)
Community Discussion
No community discussion yet for this question.