title
sys.dm_resource_governor_resource_pool_volumes (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
08/09/2016
ms.prod
sql
ms.reviewer
ms.technology
system-objects
ms.topic
language-reference
f1_keywords
sys.dm_resource_governor_resource_pool_volumes_TSQL
dm_resource_governor_resource_pool_volumes_TSQL
dm_resource_governor_resource_pool_volumes
sys.dm_resource_governor_resource_pool_volumes
dev_langs
helpviewer_keywords
dm_resource_governor_resource_pool_volumes
sys.dm_resource_governor_resource_pool_volumes
ms.assetid
fa692e56-c561-4533-97c5-bc12c600553f
author
stevestein
ms.author
sstein
sys.dm_resource_governor_resource_pool_volumes (Transact-SQL) [!INCLUDEtsql-appliesto-ss2014-xxxx-xxxx-xxx-md ]
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.
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)