September 2010
Intermediate to advanced
1704 pages
111h 8m
English
SQL Server provides three dynamic management views you can use to view and monitor your Resource Governor configuration:
• sys.dm_resource_governor_workload_groups—Returns workload group statistics along with the current in-memory configuration of the workload groups.
• sys.dm_resource_governor_resource_pools—Returns information about current state of your resource pools and resource pool statistics.
• sys.dm_resource_governor_configuration—Returns the in-memory configuration state of the Resource Governor. Output is the same as the sys.resource_governor_configuration system catalog view.
For example, the following query against the sys.dm_resource_governor_resource_pools DMV returns the configuration settings for ...