IOPS utilization

RDSIOPSUtilization #

Meaning #

Alert is triggered when RDS instance is close to its max allocated IOPS.

Impact #

Performances could be degraded.

Diagnosis #

  1. Open the RDS server main dashboard

  2. Open RDS Performance insights to identify IOPS-intensive queries

Mitigation #

  1. Kill SQL queries that generate intensive IOPS

  2. If specific to an application, report the issue to the application owner to improve the query

  3. Increase provisioned IOPS if possible (gp3 or io1 storage class). Be aware that some instances have IOPS limits.

Additional resources #

n/a