| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.resource_governor_external_resource_pools (Transact-SQL) |
sys.resource_governor_external_resource_pools (Transact-SQL) |
rwestMSFT |
randolphwest |
02/11/2025 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE sqlserver2016]
Applies to: [!INCLUDEsssql15-md] [!INCLUDErsql-productname-md] and [!INCLUDEsssql17-md] [!INCLUDErsql-productnamenew-md]
Returns the stored external resource pool configuration in [!INCLUDEssNoVersion]. 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. |
Requires the VIEW SERVER STATE permission.
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)