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

title	sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)
description	sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	02/11/2025
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	sys.dm_resource_governor_external_resource_pool_affinity sys.dm_resource_governor_external_resource_pool_affinity_TSQL dm_resource_governor_external_resource_pool_affinity dm_resource_governor_external_resource_pool_affinity_TSQL
helpviewer_keywords	sys.dm_resource_governor_external_resource_pool_affinity dm_resource_governor_external_resource_pool_affinity
dev_langs	TSQL

sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)

[!INCLUDE sqlserver2016]

Applies to: [!INCLUDEsssql15-md] [!INCLUDErsql-productname-md] and [!INCLUDEsssql17-md] [!INCLUDErsql-productnamenew-md]

Returns CPU affinity information about the current external resource pool configuration.

Column name	Data type	Description
pool_id	int	The ID of the external resource pool. Not nullable.
processor_group	smallint	The ID of the Windows logical processor group. Not nullable.
cpu_mask	bigint	The binary mask representing the CPUs associated with this pool. Not nullable.

Remarks

Pools that are created with an affinity of AUTO do not appear in this view because they have no affinity. For more information, see the CREATE EXTERNAL RESOURCE POOL (Transact-SQL) and ALTER EXTERNAL RESOURCE POOL (Transact-SQL) statements.

Permissions

Requires the VIEW SERVER STATE permission.

Permissions for SQL Server 2022 and later

Requires the VIEW SERVER PERFORMANCE STATE permission on the server.

Related content

• Resource governance for machine learning in SQL Server
• sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)
• external scripts enabled Server Configuration Option
• ALTER EXTERNAL RESOURCE POOL (Transact-SQL)