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. Is not nullable. |
| 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)
sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)