Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Tracks resource pool affinity.

Applies to: SQL Server (SQL Server 2012 through current version).

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.

Community Additions

ADD
Show:
© 2015 Microsoft