sys.dm_resource_governor_external_resource_pools (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later versions
Returns information about the current external resource pool state, the current configuration of resource pools, and resource pool statistics.
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. |
Permissions
Requires VIEW SERVER STATE permission.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
See Also
sys.dm_resource_governor_external_resource_pool_affinity (Transact-SQL)