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)
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre