IDERA SQL Diagnostic Manager for SQL Server vs. Redgate SQL 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

Redgate SQL Monitor is well suited for database administrators or companies who implement software that relies on SQL servers. It will help them test new changes and ensure this will not impact the performance of their software. It is a last resort for MSPs to use to get to the bottom of an ongoing performance issue with their SQL server.

Incentivized

• Database query optimization.
• Monitoring of databases in real time.
• Performance analysis and trends in the database.

Incentivized

• It will tell you if your server is under attack.
• You can quickly see how your server is performing and which queries are taking the longest
• I gives you the feeling that you are in control of your database, that you know what is going on for when they users ring up and tell you that the server is slow

Incentivized

• Windows client has some issues. When you have small time intervals for your data collection, it can cause the client to become unresponsive and require you to restart it.
• It takes more time to get the web client running than it does to get the windows client running.
• The visualizations have been the same for the last eight years--could use a little bit of a refresh.

Incentivized

• Incremental releases can be buggy
• Isn't the best for pinpointing performance issues
• Web interface can be sluggish

Incentivized

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 Server is an excellent tool, however I think Solarwinds Database Perfromance Analyzer is a slightly stronger more well rounded product

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

• It saves me a significant amount of time each week, freeing me up for other important tasks. I couldn't possibly monitor each server individually to the extent that SQLdm does.
• With the wealth of information I can get to easily, I can be more proactive in taking care of my environments rather than reactive. The times when other people notice something happening before I do are few and far between.

Incentivized

• The quality of the product and give a negative investment impression, on the plus side when it does work it is a god send.
• Day to day tasks as made simpler, and a feeling of security of realised. Just don't change anything.

Incentivized