sys.resource_governor_external_resource_pools (Transact-SQL)

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

Applies to: SQL Server 2016 (13.x) R Services (In-Database) and SQL Server 2017 (14.x) Machine Learning Services (In-Database)

Returns the stored external resource pool configuration in SQL Server. 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.

Note: May be renamed in the future.
name sysname Name of the resource pool. 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.
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.
max_processes int Maximum number of concurrent external processes. The default value, 0, specifies no limit. Is not nullable.
version bigint Internal version number.

Permissions

Requires VIEW SERVER STATE permission.

See also

Resource governance for machine learning in SQL Server

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

ALTER EXTERNAL RESOURCE POOL (Transact-SQL)