| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_resource_governor_external_resource_pools (Transact-SQL) |
sys.dm_resource_governor_external_resource_pools (Transact-SQL) |
rwestMSFT |
randolphwest |
02/27/2023 |
sql |
machine-learning-services |
reference |
|
|
|
>=sql-server-2016||>=sql-server-linux-ver15 |
[!INCLUDE SQL Server 2016 and later]
Returns information about the current external resource pool state, the current configuration of resource pools, and resource pool statistics.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
| Column name | Data type | Description |
|---|---|---|
| external_pool_id | int | The ID of the resource pool. Is not nullable. |
| name | sysname | The name of the resource pool. Is not nullable. |
| pool_version | int | Internal version number. |
| max_cpu_percent | int | The current configuration for the maximum average CPU bandwidth allowed for all requests in the resource pool when there is CPU contention. Is not nullable. |
| max_processes | int | Maximum number of concurrent external processes. The default value, 0, specifies no limit. Is not nullable. |
| max_memory_percent | int | The current configuration for the percentage of total server memory that can be used by requests in this resource pool. Is not nullable. |
| statistics_start_time | datetime | The time when statistics was reset for this pool. Is not nullable. |
| peak_memory_kb | bigint | The maximum amount of memory used, in kilobytes, for the resource pool. Is not nullable. |
| write_io_count | int | The total write IOs issued since the Resource Governor statistics were reset. Is not nullable. |
| read_io_count | int | The total read IOs issued since the Resource Governor statistics were reset. Is not nullable. |
| total_cpu_kernel_ms | bigint | The cumulative CPU user kernel time in milliseconds since the Resource Governor statistics were reset. Is not nullable. |
| total_cpu_user_ms | bigint | The cumulative CPU user time in milliseconds since the Resource Governor statistics were reset. Is not nullable. |
| active_processes_count | int | The number of external processes running at the moment of the request. Is not nullable. |
Requires VIEW SERVER STATE permission.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)