Seamless and Efficient Database Monitoring out of box tool
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
- 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
Other Software Used
Datadog, HashiCorp Vault, Amazon Redshift