Export (0) Print
Expand All

sys.dm_resource_governor_resource_pool_volumes (Transact-SQL)

SQL Server 2014

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

min_iops_per_volume

int

The minimum IO per second (IOPS) per disk volume setting for this Pool. Is not nullable.

max_iops_per_volume

int

The maximum IO per second (IOPS) per disk volume setting for this Pool. Is not nullable.

read_ios_queued_total

int

The total read IOs enqueued since the Resource Govenor is reset. Is not nullable.

read_ios_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_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 issue and completion. Is not nullable.

read_io_stall_queued_ms

bigint

Total time (in milliseconds) between read IO arrival and completion. Is not nullable.

To determine if the IO setting for the pool is causing latency, subtract read_io_stall_queued_ms from read_io_stall_total_ms.

write_ios_queued_total

int

The total write IOs enqueued since the Resource Govenor statistics were reset. Is not nullable.

write_ios_issued_total

int

The total write IOs issued since the Resource Govenor statistics were reset. Is not nullable.

write_ios_completed_total

int

The total write IOs completed 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 completion. Is not nullable.

To determine if the IO setting for the pool is causing latency, subtract write_io_stall_queued_ms from write_io_stall_total_ms.

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.

Resource Governor workload groups and Resource Governor resource pools have a many-to-one mapping. As a result, many of the resource pool statistics are derived from the workload group statistics.

This dynamic management view shows the in-memory configuration.To see the stored configuration metadata, use the sys.resource_governor_resource_pools catalog view.

Requires VIEW SERVER STATE permission.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft