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 |
|
|