sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)


Updated: August 9, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Tracks resource pool affinity.

Topic link icon Transact-SQL Syntax Conventions.

Colmn nameData typeDescription
Pool_idintThe ID of the resource pool. Is not nullable.
Processor_groupsmallintThe ID of the Windows logical processor group. Is not nullable.
Scheduler_maskbigintThe binary mask representing the schedulers associated with this pool. Is not nullable.

Pools that are created with an affinity of AUTO will not 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.

sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)

Community Additions