dm_resource_governor_workload_groups


Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id int 4 null
name nvarchar 512 null
pool_id int 4 null
external_pool_id int 4 √ null
statistics_start_time datetime 16,3 null
total_request_count bigint 8 null
total_queued_request_count bigint 8 null
active_request_count int 4 null
queued_request_count int 4 null
total_cpu_limit_violation_count bigint 8 null
total_cpu_usage_ms bigint 8 null
max_request_cpu_time_ms bigint 8 null
blocked_task_count int 4 null
total_lock_wait_count bigint 8 null
total_lock_wait_time_ms bigint 8 null
total_query_optimization_count bigint 8 null
total_suboptimal_plan_generation_count bigint 8 null
total_reduced_memgrant_count bigint 8 null
max_request_grant_memory_kb bigint 8 null
active_parallel_thread_count bigint 8 null
importance nvarchar 512 null
request_max_memory_grant_percent int 4 null
request_max_cpu_time_sec int 4 null
request_memory_grant_timeout_sec int 4 null
group_max_requests int 4 null
max_dop int 4 null
effective_max_dop int 4 null
total_cpu_usage_preemptive_ms bigint 8 null
request_max_memory_grant_percent_numeric float 8 null

Relationships

Close relationships within degrees of separation