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.|
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.
VIEW SERVER STATE permission.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.