Item: Amazon RDS Performance Insights
Rating: 10
Author: Fabricio Zubelli

Overall Satisfaction with Amazon RDS Performance Insights

Use Cases and Deployment Scope

We leverage Amazon RDS Performance Insights to better understand the load on our Postgres RDS instance and to find queries or jobs with room for improvement in regards to performance. Amazon RDS Performance Insights also brings a lot of out of the box metrics and data that help us make decisions on how to break our DB management and how to scale it.

Pros and Cons

Pros

RDS Infrastructure Metrics
RDS Logical Metrics
Real time visualization of query load
Identify Performance Bottlenecks
Historical Performance Analysis of load

Cons

Easier way to identify to which service the query comes from
Easier way to identify correlation between metrics
More customization, right now it is too restricted
The interval could be smaller between data points for peaks of usage

Return on Investment

Help Optimize Query and app performance
Help better plan capacity for the DB
Improved the company capacity on troubleshooting problems in DBs

Alternatives Considered

Prometheus and Datadog

Amazon RDS Performance Insights is a out of the box plug and use solution for AWS with a press of a button, whereas Prometheus would require a lot of configuration and deployment and the learning curve is slower, making it not so user friendly. Datadog on the other hand offers similar capabilities but at a much higher cost.
With that in mind, Amazon RDS Performance Insights is the choice to integrate with your AWS services quickly and affordably.

Key Insights

Do you think Amazon RDS Performance Insights delivers good value for the price?

Yes

Are you happy with Amazon RDS Performance Insights's feature set?

Yes

Did Amazon RDS Performance Insights live up to sales and marketing promises?

Yes

Did implementation of Amazon RDS Performance Insights go as expected?

Yes

Would you buy Amazon RDS Performance Insights again?

Yes

Other Software Used

Datadog, HashiCorp Vault, Amazon Redshift

Likelihood to Recommend

When you need to monitor your database at low level metrics such as query load or CPU usage at some point in time. You can also use it to understand which component is a heavy load on your DB. It is a great tool for routine monitoring of your DB and to help plan for capacity.
I would not use it as an exclusive source for scaling your DB though since the is not long-term or very granular data to be able to run a thorough analysis on peaks of predictive analysis.

Comments

Please log in to join the conversation

Seamless and Efficient Database Monitoring out of box tool