AWS RDS Instance Performance Insight

AWS RDS Instance Performance Insight

AWS RDS instance performance insight

Hello Everyone

Welcome to CloudAffaire and this is Debjeet.

In the last blog post, we have discussed enhanced monitoring for AWS RDS instance.

https://cloudaffaire.com/aws-rds-instance-enhanced-monitoring

In this blog post, we will discuss AWS RDS performance insight.

Performance Insight:

Performance Insights expands on existing Amazon RDS monitoring features to illustrate your database’s performance and help you analyze any issues that affect it. With the Performance Insights dashboard, you can visualize the database load and filter the load by waits, SQL statements, hosts, or users. Performance Insights is on by default in the console create wizard for all DB engines that work with Amazon RDS.

The central metric for Performance Insights is DB Load, which represents the average number of active sessions for the DB engine. The DB Load metric is collected every second. An active session is a connection that has submitted work to the DB engine and is waiting for a response from it. For example, if you submit a SQL query to the DB engine, the database session is active while the DB engine is processing that query. By combining DB Load with wait event data, you can get a complete picture of the state for an active session. Wait events vary by DB engine.

Next, we are going to enable performance insight for our database instance and explore the performance insight dashboard.

Prerequisites for this demo:

  • AWS RDS instance.

AWS RDS performance insight:

Step 1: Login to AWS console and navigate to ‘RDS’.

AWS RDS Instance Performance Insight

Step 2: In the navigation pane, click ‘Databases’. Select your RDS instance and click ‘Modify’.

AWS RDS Instance Performance Insight

Step 3: Go to the ‘Performance Insights’ section and enable ‘Performance Insights’.

AWS RDS Instance Performance Insight

Note: Performance Insights encrypts all potentially sensitive data using your AWS KMS key. Data is encrypted in flight and at rest.

AWS RDS Instance Performance Insight

Step 4: To view the performance insight metrics, navigate to ‘Performance Insight’.

AWS RDS Instance Performance Insight

Connect to the instance and execute some query.

To view the metrics, click the setting icon.

AWS RDS Instance Performance Insight

Select the metrics as per your requirement and click ‘Update graph’.

AWS RDS Instance Performance Insight

Hope you have enjoyed this article, In the next blog post, we will discuss AWS RDS events.

To get more details on AWS RDS, please refer below AWS documentation

https://docs.aws.amazon.com/rds/index.html

Leave a Reply

Close Menu