dm_exec_query_memory_grants


Columns

Column Type Size Nulls Auto Default Children Parents Comments
session_id smallint 2 √ null
request_id int 4 √ null
scheduler_id int 4 √ null
dop smallint 2 √ null
request_time datetime 16,3 √ null
grant_time datetime 16,3 √ null
requested_memory_kb bigint 8 √ null
granted_memory_kb bigint 8 √ null
required_memory_kb bigint 8 √ null
used_memory_kb bigint 8 √ null
max_used_memory_kb bigint 8 √ null
query_cost float 8 √ null
timeout_sec int 4 √ null
resource_semaphore_id smallint 2 √ null
queue_id smallint 2 √ null
wait_order int 4 √ null
is_next_candidate bit 1 √ null
wait_time_ms bigint 8 √ null
plan_handle varbinary 64 √ null
sql_handle varbinary 64 √ null
group_id int 4 √ null
pool_id int 4 √ null
is_small bit 1 √ null
ideal_memory_kb bigint 8 √ null
reserved_worker_count int 4 √ null
used_worker_count int 4 √ null
max_used_worker_count int 4 √ null
reserved_node_bitmap bigint 8 √ null

Relationships

Close relationships within degrees of separation