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)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for