Understanding Relational Database Service (RDS) performance issues using DevOps Guru
Amazon DevOps Guru for RDS is an ML-powered capability that assists developers and DevOps engineers in detecting, troubleshooting, and resolving issues related to Amazon RDS. DevOps Guru for RDS identifies issues related to databases, such as excessive resource usage, suggests index creation for certain keys, detects problematic SQL queries, and delivers diagnostic information and recommendations that expedite the issue resolution process.
Enabling Performance Insights on RDS is a prerequisite for Amazon DevOps Guru to provide database performance analysis. Performance Insights is a feature in RDS that provides database performance tuning insights and a detailed view of which SQL statements are causing the load, along with key performance metrics such as the active transaction count, deadlocks, and more. The following screenshot shows an example Performance Insights dashboard for an AWS RDS instance...