Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps to asess the load on a database, and determine when and where to take action. Performance Insights helps non-experts to detect performance problems with a dashboard that visualizes database load. Performance Insights uses lightweight data collection methods that don’t impact the performance of your applications, and makes it easy to see which SQL statements are causing…
$0.01
per 1,000 requests.
Icinga
Score 8.9 out of 10
N/A
Icinga is an open source network monitoring platform. It includes automation, modularized integration packages, and prebuilt alerts and reporting capabilities.
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.
Icinga is a world-class monitoring system. It can be used for most general monitoring situations. It is not a silver bullet, however, and there are instances where domain-specific monitoring systems are necessary. However, the output from those monitoring systems can be funneled into Icinga as a central monitoring and alerting system.
Icinga is a solid solution which does everything it promises. It is backwards compatible with most Nagios instances, making the transition very easy. Once you get the hang of installing new plugins and editing configuration files expanding its monitoring capabilities are easy.
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.
Icinga is better than Nagios because of its nicer user interface. New Relic can monitor CPU/memory and disk usage, but it's more of a performance and application troubleshooting tool rather than monitoring