Muokkaa

Jaa


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)