physical_disk_performance

Provides provides raw data from performance counters that monitor hard or fixed disk drives on the system.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: physical_disk_performance

  • Windows

Table schema

Name

Type

Description

name

TEXT

Name of the physical disk

avg_disk_bytes_per_read

BIGINT

Average number of bytes transferred from the disk during read operations

avg_disk_bytes_per_write

BIGINT

Average number of bytes transferred to the disk during write operations

avg_disk_read_queue_length

BIGINT

Average number of read requests that were queued for the selected disk during the sample interval

avg_disk_write_queue_length

BIGINT

Average number of write requests that were queued for the selected disk during the sample interval

avg_disk_sec_per_read

INTEGER

Average time, in seconds, of a read operation of data from the disk

avg_disk_sec_per_write

INTEGER

Average time, in seconds, of a write operation of data to the disk

current_disk_queue_length

INTEGER

Number of requests outstanding on the disk at the time the performance data is collected

percent_disk_read_time

BIGINT

Percentage of elapsed time that the selected disk drive is busy servicing read requests

percent_disk_write_time

BIGINT

Percentage of elapsed time that the selected disk drive is busy servicing write requests

percent_disk_time

BIGINT

Percentage of elapsed time that the selected disk drive is busy servicing read or write requests

percent_idle_time

BIGINT

Percentage of time during the sample interval that the disk was idle

Query examples

Select all the results for the given table.

SELECT * FROM physical_disk_performance;