sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)
Applies to: 
SQL Server
Tracks resource pool affinity.
Transact-SQL syntax conventions
| Column name | Data type | Description |
|---|---|---|
| pool_id | int | The ID of the resource pool. Not nullable. |
| processor_group | smallint | The ID of the Windows logical processor group. Not nullable. |
| scheduler_mask | bigint | The binary mask representing the schedulers associated with this pool. Not nullable. |
Remarks
Pools that are created with an affinity of AUTO won't 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.