sys-dm-resource-governor-resource-pool-affinity-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)	sys.dm_resource_governor_resource_pool_affinity tracks resource pool affinity.	rwestMSFT	randolphwest	dfurman	02/11/2025	sql	system-objects	reference	sys.dm_resource_governor_resource_pool_affinity_TSQL sys.dm_resource_governor_resource_pool_affinity dm_resource_governor_resource_pool_affinity dm_resource_governor_resource_pool_affinity_TSQL	dm_resource_governor_resource_pool_affinity sys.dm_resource_governor_resource_pool_affinity	TSQL

sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)

[!INCLUDE sql-asdbmi]

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

• sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)