sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2016) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Applies to: SQL Server 2016 (13.x) R Services (In-Database) and SQL Server 2017 (14.x) Machine Learning Services (In-Database)

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. Is not nullable.
processor_group smallint The ID of the Windows logical processor group. Is not nullable.
cpu_mask bigint The binary mask representing the CPUs associated with this pool. Is 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 VIEW SERVER STATE permission.

See also

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)