sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)
Tracks resource pool affinity.
Colmn name |
Data type |
Description |
|---|---|---|
Pool_id |
int |
The ID of the resource pool. Is not nullable. |
Processor_group |
smallint |
The ID of the Windows logical processor group. Is not nullable. |
Scheduler_mask |
bigint |
The binary mask representing the schedulers associated with this pool. Is not nullable. |
Remarks
Pools that are created with an affinity of AUTO will not appear in this view because they have no affinity. For more information, see the CREATE RESOURCE POOL (Transact-SQL) and ALTER RESOURCE POOL (Transact-SQL) statements.