Amazon RDS Performance Insights vs. Foglight

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.

Incentivized

Strengths [Foglight]

• Monitoring, Alerting and Management of on-prem virtualization and physical servers
• Historical trending and baselining are excellent and being able to compare a problem period against the same sets of data for a period when there was no issue is especially helpful as part of troubleshooting.
• Ease of use for end users is appreciated

Weaknesses [of Foglight]

• Creation and management of custom monitors is a developer level activity requiring Groovy skillset
• Less useful for management of an environment where there is a large amount of custom implementations
• Commitment to longevity of cartridges/packs for specific subsystems
• Ability to create custom schedules/alerts/escalations is only available via a 3rd party product (from a former Quest developer) and is not particularly easy to manage/manipulate
• Lack of API accessibility for external integrations to other analytics (splunk, etc.)

Incentivized

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

Incentivized

• Database monitoring
• Database management suite
• Customization (both monitors and dashboards)

Incentivized

• 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

Incentivized

• There are not many problems with this product
• Limited ability to use Foglight itself to solve problems it identifies

Incentivized

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.

Incentivized

Incentivized

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

Incentivized

• Foglight has a positive impact on my company by being a complete monitoring platform that specializes in risk assessment, user diagnosis and management, and server monitoring ensuring a secure business infrastructure through predictive analytics, query analysis, anomaly detection, behavior tracking, troubleshooting, automated discovery, and more.

Incentivized