Posted On: Sep 13, 2022
HAQM Relational Database Service (HAQM RDS) Performance Insights’ Top SQL tab shows the SQL queries that are contributing the most to database load. Starting today, we are increasing the top SQL queries displayed in HAQM RDS Performance Insights from 10 to 25. HAQM RDS Performance Insights is a database performance tuning and monitoring feature of RDS and HAQM Aurora that helps you quickly assess the load on your database and determine when and where to take action.
HAQM RDS Performance Insights allows non-experts to measure database performance with a simple-to-understand dashboard that visualizes database load. With one click, you can add a fully managed performance monitoring solution to your Aurora clusters and HAQM RDS instances. HAQM RDS Performance Insights automatically gathers necessary performance metrics and visualizes them in a dynamic dashboard on the RDS console. You can identify your database’s top performance bottlenecks from a single graph.
To get started, log into the HAQM RDS Management Console and enable HAQM RDS Performance Insights when creating or modifying an instance of a supported HAQM RDS engine. Then go to the HAQM RDS Performance Insights dashboard to start monitoring performance.
HAQM RDS Performance Insights is included with supported Aurora clusters and HAQM RDS instances, and stores seven days of performance history in a rolling window at no additional cost. If you need longer-term retention, you can pay for 1-24 months of performance history retention. For a complete list of regions where HAQM RDS Performance Insights is offered, see AWS Regions. To learn more about HAQM RDS Performance Insights and supported database engines, see the HAQM RDS User Guide.