TechNet
Export (0) Print
Expand All

sys.dm_resource_governor_resource_pool_volumes (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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).

Applies to: SQL Server (SQL Server 2014 through current version).
Column nameData typeDescription
pool_idintThe ID of the resource pool. Is not nullable.
volume_namesysnameThe name of the disk volue. Is not nullable.
read_io_queued_totalintThe total read IOs enqueued since the Resource Govenor is reset. Is not nullable.
read_io_issued_totalintThe total read IOs issued since the Resource Govenor statistics were reset. Is not nullable.
read_ios_completed_totalintThe total read IOs completed since the Resource Govenor statistics were reset. Is not nullable.
read_ios_throttled_totalintThe total read IOs throttled since the Resource Govenor statistics were reset. Is not nullable.
read_bytes_totalbigintThe total number of bytes read since the Resource Govenor statistics were reset. Is not nullable.
read_io_stall_total_msbigintTotal time (in milliseconds) between read IO arrival and completion. Is not nullable.
read_io_stall_queued_msbigintTotal time (in milliseconds) between read IO arrival and issue. This is the delay introduced by IO Resource Governance. Is not nullable.
write_io_queued_totalintThe total write IOs enqueued since the Resource Govenor statistics were reset. Is not nullable.
write_io_issued_totalintThe total write IOs issued since the Resource Govenor statistics were reset. Is not nullable.
write_io_completed_totalintThe total write IOs completed since the Resource Govenor statistics were reset. Is not nullable
write_io_throttled_totalintThe total write IOs throttled since the Resource Govenor statistics were reset. Is not nullable
write_bytes_totalbigintThe total number of bytes written since the Resource Govenor statistics were reset. Is not nullable.
write_io_stall_total_msbigintTotal time (in milliseconds) between write IO issue and completion. Is not nullable.
write_io_stall_queued_msbigintTotal time (in milliseconds) between write IO arrival and issue. This is the delay introduced by IO Resource Governance. Is not nullable.
io_issue_violations_totalintTotal 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_msbigintTotal time (in milliseconds) between the scheduled issue and actual issue of IO. Is not nullable.

Requires VIEW SERVER STATE permission.

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)

Community Additions

ADD
Show:
© 2016 Microsoft