แก้ไข

แชร์ผ่าน


sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later versions

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

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.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

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)