rds.yaml

team: eng

alerts:
- multi: true
  name: RDS high read latency
  options: {no_data_timeframe: 480, notify_no_data: false}
  query: min(last_4h):avg:aws.rds.read_latency{*} by {dbinstanceidentifier} > 0.03
  type: metric alert

- multi: true
  name: RDS disk standing queue
  options: {no_data_timeframe: 120, notify_no_data: false}
  query: min(last_1h):max:aws.rds.disk_queue_depth{*} by {dbinstanceidentifier} >
    1
  type: metric alert

- multi: true
  name: many RDS write iops
  options: {no_data_timeframe: 480, notify_no_data: false}
  query: avg(last_4h):avg:aws.rds.write_iops{*} by {dbinstanceidentifier} > 400
  type: metric alert

- multi: true
  name: RDS high write latency
  options: {no_data_timeframe: 480, notify_no_data: false}
  query: min(last_4h):avg:aws.rds.write_latency{*} by {dbinstanceidentifier} > 0.05
  type: metric alert

- multi: true
  name: many RDS read iops
  options: {no_data_timeframe: 120, notify_no_data: false, renotify_interval: 0, timeout_h: 0}
  query: avg(last_1h):avg:aws.rds.read_iops{dbinstanceidentifier:collectr-db-enc}
    by {dbinstanceidentifier} > 500
  type: metric alert

- multi: true
  name: aws rds database low on free storage space
  options: {no_data_timeframe: 720}
  query: avg(last_1h):avg:aws.rds.free_storage_space{*} by {dbinstanceidentifier}
    < 4000000000
  type: metric alert