sys.dm_resource_governor_resource_pool_volumes (Transact-SQL)
Applies to:
SQL Server
Returns information about the current resource pool IO statistics for each disk volume. This information is also available at the resource pool level in sys.dm_resource_governor_resource_pools (Transact-SQL).
Column name | Data type | Description |
---|---|---|
pool_id | int | The ID of the resource pool. Is not nullable. |
volume_name | sysname | The name of the disk volue. Is not nullable. |
read_io_queued_total | int | The total read IOs enqueued since the Resource Govenor is reset. Is not nullable. |
read_io_issued_total | int | The total read IOs issued since the Resource Govenor statistics were reset. Is not nullable. |
read_ios_completed_total | int | The total read IOs completed since the Resource Govenor statistics were reset. Is not nullable. |
read_ios_throttled_total | int | The total read IOs throttled since the Resource Govenor statistics were reset. Is not nullable. |
read_bytes_total | bigint | The total number of bytes read since the Resource Govenor statistics were reset. Is not nullable. |
read_io_stall_total_ms | bigint | Total time (in milliseconds) between read IO arrival and completion. Is not nullable. |
read_io_stall_queued_ms | bigint | Total time (in milliseconds) between read IO arrival and issue. This is the delay introduced by IO Resource Governance. Is not nullable. |
write_io_queued_total | int | The total write IOs enqueued since the Resource Govenor statistics were reset. Is not nullable. |
write_io_issued_total | int | The total write IOs issued since the Resource Govenor statistics were reset. Is not nullable. |
write_io_completed_total | int | The total write IOs completed since the Resource Govenor statistics were reset. Is not nullable |
write_io_throttled_total | int | The total write IOs throttled since the Resource Govenor statistics were reset. Is not nullable |
write_bytes_total | bigint | The total number of bytes written since the Resource Govenor statistics were reset. Is not nullable. |
write_io_stall_total_ms | bigint | Total time (in milliseconds) between write IO issue and completion. Is not nullable. |
write_io_stall_queued_ms | bigint | Total time (in milliseconds) between write IO arrival and issue. This is the delay introduced by IO Resource Governance. Is not nullable. |
io_issue_violations_total | int | Total IO issue violations. That is, the number of times when the rate of IO issue was lower than the reserved rate. Is not nullable. |
io_issue_delay_total_ms | bigint | Total time (in milliseconds) between the scheduled issue and actual issue of IO. 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
Dynamic Management Views and Functions (Transact-SQL)
sys.dm_resource_governor_workload_groups (Transact-SQL)
sys.resource_governor_resource_pools (Transact-SQL)
ALTER RESOURCE GOVERNOR (Transact-SQL)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें