sys.resource_governor_external_resource_pools (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later versions
Applies to: SQL Server 2016 (13.x) R Services (In-Database) and SQL Server 2017 (14.x) Machine Learning Services
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 |
|---|---|---|
external_pool_id |
int | Unique ID of the resource pool. Not nullable. |
name |
sysname | Name of the resource pool. 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. |
max_memory_percent |
int | Percentage of total server memory that can be used by requests in this resource pool. 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. Not nullable. |
version |
bigint | Internal version number. |
Permissions
Requires the VIEW SERVER STATE permission.
Related content
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)