sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)
Applies to: SQL Server
Tracks resource pool affinity.
Transact-SQL syntax conventions
Column name | Data type | Description |
---|---|---|
pool_id | int | The ID of the resource pool. Not nullable. |
processor_group | smallint | The ID of the Windows logical processor group. Not nullable. |
scheduler_mask | bigint | The binary mask representing the schedulers associated with this pool. Not nullable. |
Remarks
Pools that are created with an affinity of AUTO won't appear in this view, because they have no affinity. For more information, see the CREATE RESOURCE POOL (Transact-SQL) and ALTER RESOURCE POOL (Transact-SQL) statements.
See also
Váš názor
https://aka.ms/ContentUserFeedback.
Připravujeme: V průběhu roku 2024 budeme postupně vyřazovat problémy z GitHub coby mechanismus zpětné vazby pro obsah a nahrazovat ho novým systémem zpětné vazby. Další informace naleznete v tématu:Odeslat a zobrazit názory pro