Posted On: Sep 18, 2023

Amazon RDS (Relational Database Service) Performance Insights supports SQL-level metrics for Amazon RDS for SQL Server so that you can identify high-frequency, long-running, and stuck SQL queries in seconds. SQL level statistics are already available for all other Amazon RDS engines. 

Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time.

Amazon RDS Performance Insights allows non-experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights also collects SQL-level metrics such as average latency, calls per second, and rows returned per call. You can determine if an SQL query takes too long to complete or if a particular SQL query is called at a different rate than you expect and then make improvements to your application such as optimizing a slow SQL query, adding an index to your database, and scaling your database.

Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS that allows you to visually assess the load on your database and determine when and where to take action. With one click in the Amazon RDS Management Console, you can add a fully managed performance monitoring solution to your Amazon RDS database. RDS Performance Insights is included with supported Amazon Aurora clusters and Amazon 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 up to 24 months of performance history retention in one month increment. 

Amazon RDS Performance Insights is available in both Amazon Web Services China (Beijing) Region, operated by Sinnet and Amazon Web Services China (Ningxia) Region, operated by NWCD. To learn more about RDS Performance Insights and supported database engines, read the Amazon RDS User Guide