| title | sys.resource_governor_external_resource_pools (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql-server-2016 | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 75063e36-a91b-496f-9936-88f3d57bd447 | ||||
| caps.latest.revision | 10 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx_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 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
SQL Server R Services
Known Issues for SQL Server R Services
ALTER EXTERNAL RESOURCE POOL (Transact-SQL)