Try our new research platform with insights from 80,000+ expert users
IDERA SQL Diagnostic Manager for SQL Server Logo

IDERA SQL Diagnostic Manager for SQL Server pros and cons

Vendor: IDERA
4.0 out of 5
887 followers
Post review
 

IDERA SQL Diagnostic Manager for SQL Server Pros review quotes

JS
Oct 21, 2018
We're able to diagnose issues prior to their actually becoming issues. Without the alerting, we wouldn't have a clue as to what was going to happen. With the alerting, it gives us a heads-up that a specific threshold has been met, and we need to take specific action.
MB
Oct 2, 2018
The most valuable features are disk space projections for planning, and also the Snapshotting ability, to look back in time, to see what was going on the server at a particular time. It's basically the output of an sp_who2.
PB
Dec 8, 2023
The ability to go back and look at historical data is the most valuable feature.
Learn what your peers think about IDERA SQL Diagnostic Manager for SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,763 professionals have used our research since 2012.
it_user806148 - PeerSpot reviewer
Jan 22, 2018
The best part of SQL DM is the ability to customize alerts and counters. This allows our team to find an issue then alert on the issue at a granular level.
HL
Aug 20, 2020
Memory and CPU utilization features are good.
 

IDERA SQL Diagnostic Manager for SQL Server Cons review quotes

JS
Oct 21, 2018
I'm going to do an upgrade which may resolve my issues, but one area for improvement is its ability to handle the amount of data that we collect with it. We're likely one of the largest installations, with over 300 servers being collected with this product, and sometimes there are gaps. That would really be my only concern, in terms of how the data is collected and stored, for consistency.
MB
Oct 2, 2018
We don't find that it helps us with performance monitoring and diagnostics. We find that SentryOne does that better. Also, in terms of alerts, we had to customize them dramatically so that we didn't get alerted on every little thing.
PB
Dec 8, 2023
One thing I'd like to see is the ability to view the execution plan and have the system automatically recommend potential query optimizations, especially at the query level.
Learn what your peers think about IDERA SQL Diagnostic Manager for SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: October 2024.
814,763 professionals have used our research since 2012.
it_user806148 - PeerSpot reviewer
Jan 22, 2018
It would helpful if SQL DM could mark when changes are made within the program.
HL
Aug 20, 2020
They can improve checking the status of the CPU, memory, and IO utilization from each task.