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)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें