Edit

Share via

sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Managed Instance

Returns the CPU and NUMA node affinity data for a resource pool.

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.

Related content