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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho