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

Computing resources consumed by the DB instance, DPA queries & wait time, deadlock conditions, virtual infrastructure resources. The addition of NPM & DPA integration as well as cross-correlation in the identification of issues with the network or server or DB is all stupid-proof. Monitoring is more than just health and resource consumption, it's also performance. DB performance analysis is key to maintaining healthy DB instances.

Incentivized

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

Incentivized

• Simple to use and very easy to learn.
• The execution engines run in parallel, can execute any syntax or query.
• DPN can run all queries for both Oracle and SQL with no additional support.

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

• The Reporting feature currently doesn't allow customization.

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

DPM is less expensive and more feature-rich. Also, Oracle tech support is garbage, unless you can afford to spend a day getting assistance.

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

• What is the cost of a downed DB instance? That's your ROI. DPM lets you see issues before they become critical.

Incentivized