Skip to main content
sys.resource_governor_external_resource_pools (Transact-SQL)
 

Updated: June 10, 2016

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

Returns the stored external 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.

 Note: May be renamed in the future.
namesysnameName of the resource pool. 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.
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.
max_processesintMaximum number of concurrent external processes. The default value, 0, specifies no limit. Is not nullable.
versionbigintInternal version number.

Requires VIEW SERVER STATE permission.

Resource Governor Catalog Views (Transact-SQL)
sys.dm_resource_governor_resource_pools (Transact-SQL)
Resource Governor
sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)
external scripts enabled Server Configuration Option
SQL Server R Services
Known Issues for SQL Server R Services
ALTER EXTERNAL RESOURCE POOL (Transact-SQL)