AWS RDS instance performance insight
Welcome to CloudAffaire and this is Debjeet.
In the last blog post, we have discussed enhanced monitoring for AWS RDS instance.
In this blog post, we will discuss AWS RDS 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’.
Step 2: In the navigation pane, click ‘Databases’. Select your RDS instance and click ‘Modify’.
Step 3: Go to the ‘Performance Insights’ section and enable ‘Performance Insights’.
Note: Performance Insights encrypts all potentially sensitive data using your AWS KMS key. Data is encrypted in flight and at rest.
Step 4: To view the performance insight metrics, navigate to ‘Performance Insight’.
Connect to the instance and execute some query.
To view the metrics, click the setting icon.
Select the metrics as per your requirement and click ‘Update graph’.
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