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)
Повратне информације
https://aka.ms/ContentUserFeedback.
Стиже ускоро: Током 2024. године постепено ћемо укидати проблеме са услугом GitHub као механизам повратних информација за садржај и заменити га новим системом повратних информација. За додатне информације, погледајте:Пошаљите и прегледајте повратне информације за