Returns the stored resource pool configuration. Each row of the view determines the configuration of a pool.
|
Column name
|
Data type
|
Description
|
|---|
|
pool_id
|
int
|
Unique ID of the resource pool. Is not nullable.
|
|
name
|
sysname
|
Name of the resource pool. Is not nullable.
|
|
min_cpu_percent
|
int
|
Guaranteed average CPU bandwidth for all requests in the resource pool when there is CPU contention. Is not nullable.
|
|
max_cpu_percent
|
int
|
Maximum average CPU bandwidth allowed for all requests in the resource pool when there is CPU contention. Is not nullable.
|
|
min_memory_percent
|
int
|
Guaranteed amount of memory for all requests in the resource pool. This is not shared with other resource pools. Is not nullable.
|
|
max_memory_percent
|
int
|
Percentage 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.
|
The catalog view displays the stored metadata. To see the in-memory configuration, use the corresponding dynamic management view.
Requires VIEW ANY DEFINITION permission to view contents, requires CONTROL SERVER permission to change contents.
Reference
Resource Governor Catalog Views (Transact-SQL)
sys.dm_resource_governor_resource_pools (Transact-SQL)
Catalog Views (Transact-SQL)
Help and Information
Getting SQL Server 2008 Assistance