sys.resource_governor_resource_pools (Transact-SQL)

 

Updated: August 9, 2016

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

Returns the stored resource pool configuration in SQL Server. Each row of the view determines the configuration of a pool.

Column nameData typeDescription
pool_idintUnique ID of the resource pool. Is not nullable.
namesysnameName of the resource pool. Is not nullable.
min_cpu_percentintGuaranteed average CPU bandwidth for all requests in the resource pool when there is CPU contention. Is not nullable.
max_cpu_percentintMaximum average CPU bandwidth allowed for all requests in the resource pool when there is CPU contention. Is not nullable.
min_memory_percentintGuaranteed amount of memory for all requests in the resource pool. This is not shared with other resource pools. Is not nullable.
max_memory_percentintPercentage of total server memory that can be used by requests in this resource pool. Is not nullable. The effective maximum depends on the pool minimums. For example, max_memory_percent can be set to 100, but the effective maximum is lower.
cap_cpu_percentintApplies to: SQL Server 2012 through SQL Server 2016.

Hard cap on the CPU bandwidth that all requests in the resource pool will receive. Limits the maximum CPU bandwidth to the specified level. The allowed range for value is from 1 through 100.
min_iops_per_volumeintApplies to: SQL Server 2014 through SQL Server 2016.

The minimum I/O operations per second (IOPS) per volume setting for this pool. 0 = no reservation. Cannot be null.
max_iops_per_volumeintApplies to: SQL Server 2014 through SQL Server 2016.

The maximum I/O operations per second (IOPS) per volume setting for this pool. 0 = unlimited. Cannot be null.

The catalog view displays the stored metadata. To see the in-memory configuration, use the corresponding dynamic management view, sys.dm_resource_governor_resource_pools (Transact-SQL).

Requires VIEW ANY DEFINITION permission to view contents, requires CONTROL SERVER permission to change contents.

Resource Governor Catalog Views (Transact-SQL)
sys.dm_resource_governor_resource_pools (Transact-SQL)
Resource Governor
sys.resource_governor_external_resource_pools (Transact-SQL)

Community Additions

ADD
Show: