Returns information about the current external resource pool state, the current configuration of resource pools, and resource pool statistics.
|Colmn 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 Govenor statistics were reset. Is not nullable.|
|read_io_count||int||The total read IOs issued since the Resource Govenor statistics were reset. Is not nullable.|
|total_cpu_kernel_ms||bigint||The cumulative CPU user kernel time in milliseconds since the Resource Govenor statistics were reset. Is not nullable.|
|total_cpu_user_ms||bigint||The cumulative CPU user time in milliseconds since the Resource Govenor 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.|
VIEW SERVER STATE permission.