Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns workload group statistics and the current in-memory configuration of the workload group. This view can be joined with sys.dm_resource_governor_resource_pools to get the resource pool name.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Data Warehouse Public Preview.
To call this from SQL Data Warehouse, use the name sys.dm_pdw_nodes_resource_governor_workload_groups.
ID of the workload group. Is not nullable.
Name of the workload group. Is not nullable.
ID of the resource pool. Is not nullable.
Time that statistics collection was reset for the workload group. Is not nullable.
Cumulative count of completed requests in the workload group. Is not nullable.
Cumulative count of requests queued after the GROUP_MAX_REQUESTS limit was reached. Is not nullable.
Current request count. Is not nullable.
Current queued request count. Is not nullable.
Cumulative count of requests exceeding the CPU limit. Is not nullable.
Cumulative CPU usage, in milliseconds, by this workload group. Is not nullable.
Maximum CPU usage, in milliseconds, for a single request. Is not nullable.
Current count of blocked tasks. Is not nullable.
Cumulative count of lock waits that occurred. Is not nullable.
Cumulative sum of elapsed time, in milliseconds, a lock is held. Is not nullable.
Cumulative count of query optimizations in this workload group. Is not nullable.
Cumulative count of suboptimal plan generations that occurred in this workload group due to memory pressure. Is not nullable.
Cumulative count of memory grants that reached the maximum query size limit. Is not nullable.
Maximum memory grant size, in kilobytes, of a single request since the statistics were reset. Is not nullable.
Current count of parallel thread usage. Is not nullable.
Current configuration value for the relative importance of a request in this workload group. Importance is one of the following, with Medium being the default:
Is not nullable.
Current setting for the maximum memory grant, as a percentage, for a single request. Is not nullable.
Current setting for maximum CPU use limit, in seconds, for a single request. Is not nullable.
Current setting for memory grant time-out, in seconds, for a single request. Is not nullable.
Current setting for the maximum number of concurrent requests. Is not nullable.
Maximum degree of parallelism for the workload group. The default value, 0, uses global settings. Is not nullable.
This dynamic management view shows the in-memory configuration. To see the stored configuration metadata, use the sys.resource_governor_workload_groups catalog view.
When ALTER RESOURCE GOVERNOR RESET STATISTICS is successfully executed, the following counters are reset: statistics_start_time, total_request_count, total_queued_request_count, total_cpu_limit_violation_count, total_cpu_usage_ms, max_request_cpu_time_ms, total_lock_wait_count, total_lock_wait_time_ms, total_query_optimization_count, total_suboptimal_plan_generation_count, total_reduced_memgrant_count, and max_request_grant_memory_kb. statistics_start_time is set to the current system date and time, the other counters are set to zero (0).
Requires VIEW SERVER STATE permission.