| 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/11/2025 |
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.
| Column name | Data type | Description |
|---|---|---|
external_pool_id |
int | The ID of the resource pool. Not nullable |
name |
sysname | The name of the resource pool. 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. Not nullable. |
max_processes |
int | Maximum number of concurrent external processes. The default value, 0, specifies no limit. 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. Not nullable. |
statistics_start_time |
datetime | The time when statistics was reset for this pool. Not nullable. |
peak_memory_kb |
bigint | The maximum amount of memory used, in kilobytes, for the resource pool. Not nullable. |
write_io_count |
int | The total write IOs issued since the Resource Governor statistics were reset. Not nullable. |
read_io_count |
int | The total read IOs issued since the Resource Governor statistics were reset. Not nullable. |
total_cpu_kernel_ms |
bigint | The cumulative CPU user kernel time in milliseconds since the Resource Governor statistics were reset. Not nullable. |
total_cpu_user_ms |
bigint | The cumulative CPU user time in milliseconds since the Resource Governor statistics were reset. Not nullable. |
active_processes_count |
int | The number of external processes running at the moment of the request. Not nullable. |
Requires the VIEW SERVER STATE permission.
Requires the VIEW SERVER PERFORMANCE STATE permission on the server.