Amazon RDS Performance Insights vs. Redgate Monitor

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

With mission-critical SQL Server instances at multiple physical locations and in the cloud, it's critical for us to know immediately when there are performance issues or outages. The Redgate SQL Monitor provides an intuitive dashboard that allows for detailed resource monitoring. Perhaps not as useful in a 100% managed SQL environment.

Incentivized

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

Incentivized

• It is easy to use and provides very good reporting on the SQL servers being monitored. These reports are used in our monthly customer reports.
• Redgate does a very good job at improving the product, fixing bugs and adding new features compared to other products I have researched.
• The insights provided makes it an ideal tool for database administrators and software developers.

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

• Openness - They are too attached to their Intellectual Property to the detriment of usability, stability and reliability. So once its is installed and working leave it alone. Best run it on a VM as that can be restored quickly for when it breaks.
• If they exposed an API/SDK that allowed you to leaver their products life would be far sweeter, it would feel less of a battle.
• Add WebHooks to SQL Monitor to enhance integration to other subsystems.
• Make it easy to install in default mode. So you are not forced to use TomCat Use as ASP.Core Selfl Hosting options.

Incentivized

In general, the Redgate dashboard is one of the most thorough yet intuitive products I've had the pleasure of using. Compared to other vendors in different verticals, the Redgate dashboard's deployment, configuration, monitoring, and reporting is second to none

Incentivized

Fast support responses from Redgate

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

I personally prefer SQL Sentry due to the flexibility in the custom metrics/monitoring but this is still a great product!!

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

Incentivized

• Allows us to proactively fix issues before they happen
• Allows us to quickly react to issues without having to wait for someone else to notice
• Cuts down on the amount of time spent doing daily checks

Incentivized