IDERA SQL Diagnostic Manager for SQL Server vs. SQL Server Business Intelligence Manager

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

BIDS works well if you're committed to using all MS products. It does take some serious consideration if you know you will end up working outside of that, such as working with AWS products.

Incentivized

• SQL Server Monitoring
• Alerts
• Diagnostics

Incentivized

• Shows an excellent dashboard
• Allows easy monitoring of multiple instances
• Created an environment that can be self healing

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

• Training is needed to understand and use all the feature
• Works well only with Microsoft products
• Not enough Tutorials available
• Features are more useful for larger organization

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

SQL Server [Business Intelligence] Manager works well with Microsoft products. It has several advanced features along with dashboards and alerts that can be configured to user's need.

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

• We've prevented several SSAS outages because of SQL Server Business Intelligence Manager's timely alerts.
• We've greatly reduced cubes calculation times with SQL Server Business Intelligence Manager's tuning features.

Incentivized