Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)

SQL Server 2012

Tracks resource pool affinity.

Colmn name

Data type

Description

Pool_id

int

The ID of the resource pool. Is not nullable.

Processor_group

smallint

The ID of the Windows logical processor group. Is not nullable.

Scheduler_mask

bigint

The 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.