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;