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
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for