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)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za