| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.resource_governor_resource_pools (Transact-SQL) |
sys.resource_governor_resource_pools (Transact-SQL) |
rwestMSFT |
randolphwest |
dfurman |
02/11/2025 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE sql-asdbmi]
Returns the stored resource pool configuration. Each row represents a resource pool.
| Column name | Data type | Description |
|---|---|---|
pool_id |
int | Unique ID of the resource pool. Not nullable. |
name |
sysname | Name of the resource pool. Not nullable. |
min_cpu_percent |
int | Guaranteed average CPU bandwidth for all requests in the resource pool when there is CPU contention. Not nullable. |
max_cpu_percent |
int | Maximum average CPU bandwidth allowed for all requests in the resource pool when there is CPU contention. Not nullable. |
min_memory_percent |
int | Guaranteed amount of query workspace memory for all requests in the resource pool. This is not shared with other resource pools. Not nullable. |
max_memory_percent |
int | Percentage of total query workspace memory that can be used by requests in this resource pool. Not nullable. The effective maximum depends on the other pool minimums. For example, max_memory_percent can be set to 100, but the effective maximum might be lower. Not nullable. |
cap_cpu_percent |
int | Applies to: [!INCLUDEssSQL11] and later. Hard cap on the CPU bandwidth that all requests in the resource pool receive. Limits the maximum CPU bandwidth to the specified level. The allowed range for value is from 1 through 100. Not nullable. |
min_iops_per_volume |
int | Applies to: [!INCLUDEssSQL14] and later. The minimum I/O operations per second (IOPS) per volume setting for this pool. 0 = no reservation. Not nullable. |
max_iops_per_volume |
int | Applies to: [!INCLUDEssSQL14] and later. The maximum I/O operations per second (IOPS) per volume setting for this pool. 0 = unlimited. Not nullable. |
This catalog view displays the stored metadata. To see the currently effective resource governor configuration, use the corresponding dynamic management view, sys.dm_resource_governor_resource_pools (Transact-SQL).
Requires the VIEW ANY DEFINITION permission.