Query: Intervals where volume average iops exceeds provisioned iops

Description

Identify instances where the average input/output operations per second (IOPS) surpasses the provisioned IOPS on your AWS EBS volumes. This is crucial for optimizing your storage performance and preventing any potential bottlenecks.

Query

Tables used in this query:

• aws_ebs_volume_metric_write_ops_hourly

SQL