Query: Intervals where operation exceed 1000 average read iops

Description

Explore instances where the daily average read operations per second (IOPS) on an Alibaba Cloud Elastic Compute Service (ECS) disk exceed 1000. This can be useful in identifying periods of high disk usage, which could impact system performance.

Query

Tables used in this query:

• alicloud_ecs_disk_metric_read_iops_daily

SQL