| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL) |
sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL) |
rwestMSFT |
randolphwest |
02/27/2023 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE sqlserver2016] Applies to: [!INCLUDEsssql15-md] [!INCLUDErsql-productname-md] and [!INCLUDEsssql17-md] [!INCLUDErsql-productnamenew-md]
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.
Requires VIEW SERVER STATE permission.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
Resource governance for machine learning in SQL Server
sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)