Skip to main content

Use Case for AWS RDS DB Instances should have performance insights enabled

  1. Configure AWS RDS DB Instances should have performance insights enabled
  2. Use Case for AWS RDS DB Instances should have performance insights enabled
  3. Triage Guides by Violation Type
    1. Triage AWS RDS DB Instances should have performance insights enabled PERFORMANCE_INSIGHTS_NOT_ENABLED

When should I use AWS RDS Performance Insights?​

AWS RDS Performance Insights delivers comprehensive database performance analysis and visualization, allowing for easy identification and resolution of performance issues. The feature includes a free tier with seven days of data history, but has limited support for certain instance classes on Amazon RDS for MariaDB and RDS for MySQL.

Benefits of using AWS RDS Performance Insights​

  1. Comprehensive performance analysis and visualization: RDS Performance Insights offers a complete view of database performance by providing metrics like DBLoad, which measures the level of activity in your database and is collected every second. The Performance Insights dashboard allows you to visualize the database load on your Amazon RDS DB instance and filter the load by waits, SQL statements, hosts, or users. This enables you to easily identify slow-running queries and performance bottlenecks, helping you optimize your database for better efficiency (Database load).
  2. Free tier availability: Performance Insights offers a rolling seven days of performance data history at no charge, including 1 million API requests per month. This is enough time to troubleshoot a wide variety of issues. To analyze longer-term performance trends, you can increase the rolling performance data history up to two years (Pricing and data retention for Performance Insights).

Cons of using AWS RDS Performance Insights​

  1. Limited support for certain instance classes: Performance Insights isn't supported for the following instance classes on Amazon RDS for MariaDB and RDS for MySQL: db.t2.micro, db.t2.small, db.t3.micro, db.t3.small, db.t4g.micro, and db.t4g.small (Amazon RDS DB engine, Region, and instance class support for Performance Insights).