IDERA SQL Diagnostic Manager for SQL Server vs. Redgate Monitor

If you have several SQL servers and don't have a lot of time or resources to constantly monitor them, SQLdm will be very helpful. For one or two servers, it might be overkill. All of our servers are virtual, so having a tool that can monitor host metrics as well as guest metrics is a plus as well.

Incentivized

Well suited when you have one SQL server and you don't have a dedicated DBA. Where your biz depends on this DB. It's easy to add more monitoring.

Incentivized

• SQL Server Monitoring
• Alerts
• Diagnostics

Incentivized

• Missing index
• RAM usage
• CPU usage

Incentivized

• While there is reporting present in the app, I don't find it to be very configurable. I eventually pointed our reporting software at the SQLdm database so I could craft my own reporting. The reporting that's there is sufficient for a lot of things, but for more detailed analysis and trending, it's a little light
• The config right out of the box feels a little heavy to me. It leans towards the side of over monitoring and over notifying. For example, I view "critical" alerts as those that I'd want to be woken up at 3am for. After a fresh install, I felt like I was getting so many "critical" alerts that I was starting to ignore them. I had to spend a good bit of time tweaking.
• Sometimes the interface seems laggy. Switching between individual servers and switching screens can take what feels like a long time. I'm not sure if it's the way I have the client configured or something up with my machine, but this app in particular feels slower than it should.

Incentivized

• I don't think the custom metrics/alerting is as flexible as say SQLSentry

Access to metrics is simple but I like easy access to top SQL

Fast support responses from Redgate

Incentivized

IDERA SQL Diagnostic Manager for SQL, Redgate SQL, and MonitorLogicMonitor are similar products to each other. We decided on IDERA SQL Diagnostic Manager for SQL because our experience with locating heavy queries has been very good and it provides real-time monitoring of all servers and databases. It also allows you to have a large volume of historical data which allows you to analyze trends in the databases.

Incentivized

Redgate SQL Monitor is a lot cheaper than SolarWinds Database Performance Analyzer. I prefer the SolarWinds' design and that it offers integration with other SolarWinds products we already use. SolarWinds supports more than SQL servers (Oracle, MySQL, Maria DB, IBM DB2) and the analysis seems to be much better. The Spiceworks SQL Server monitoring is a free tool and is ideal for monitoring small business SQL instances.

Incentivized

• Quickly identify issues around deadlocks and blocking. Quickly allowing for resolution
• Quickly and easily enable automation around issues so we can reduce the amount of time it takes for resolution of issues
• Having built-in tools to view things such as index fragmentation--allows you to quickly find correlations in performance issues

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