RDS Monitoring
Memory
Alert when memory is under 128 Mb
aws_rds_freeable_memory_average < 128*1024*1024
DB Connections
Alert when DB connection number is greater than 1000
aws_rds_database_connections_average > 1000
Number of connections has increased 10 times in last hour
aws_rds_database_connections_average / aws_rds_database_connections_average offset 1h > 10
CPU Usage
CPU usage is greater than 95% of the instance
aws_rds_cpuutilization_average > 0.95
Storage
Available storage is lower than 512 Mb
aws_rds_free_storage_space_average < 512*1024*1024
PromQL query will alert you if you’re going to run out of storage in the next 48 hours
predict_linear(aws_rds_free_storage_space_average[48h], 48 * 3600) < 0
Read/Write Latency
Read Latency is over 250 ms
aws_rds_read_latency_average > 0.250
Write Latency is over 250 ms
aws_rds_write_latency_average > 0.250
Network I/O
network traffic is down
aws_rds_network_receive_throughput_average = 0 AND aws_rds_network_transmit_throughput_average = 0
Read/Write IOPS
Read IOPS greater than 2 500 operations per second
aws_rds_read_iops_average > 2500
Write IOPS greater than 2 500 operations per second
aws_rds_write_iops_average > 2500