| title | sys.resource_governor_external_resource_pools (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 11/13/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.component | system-catalog-views | ||||
| ms.reviewer | |||||
| ms.suite | sql | ||||
| ms.technology | system-objects | ||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 75063e36-a91b-496f-9936-88f3d57bd447 | ||||
| caps.latest.revision | 10 | ||||
| author | edmacauley | ||||
| ms.author | edmaca | ||||
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md] 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 |
|---|---|---|
| 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. |
Requires 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)
sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)