We performed a comparison between IDERA ER/Studio and IDERA SQL Diagnostic Manager for SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management."The most valuable features are... those that enable me to represent the database to the development community and the business users."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."
"The tool is simple to use."
"The data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth."
"Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."
"Straightforward setup."
"The ability to go back and look at historical data is the most valuable feature."
"Memory and CPU utilization features are good."
"SQL DM made troubleshooting much easier and allowed multiple people to look into an issue with confidence."
"Monitors and alerts on our mission critical instances in real-time on a 24/7 basis."
"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."
"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."
"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."
"When building the relationships there should be a little more flexibility."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"We would always like to see Repository performance improve, checking in and checking out."
"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."
"The initial setup gives too many user rights to the server, so you have to put a user that is part administrator's group - that's the preferred way - on each server, which is kind of a risk. You want to do least privilege and you're not doing that."
"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."
"It would helpful if SQL DM could mark when changes are made within the program."
"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."
"I would absolutely love to create customized dashboards but, unfortunately, they don't provide me the information that I need to create the report. The report I need is the detail or the transaction detail that's happening on those Snapshots. I'd like to be able to go back through time and search for things. I don't have that functionality, which is very disappointing. That's pretty bad and frustrating because I could query it and find out so much information about what's hitting my environment and when, but instead, they want control over it and to not give me that information. So it's encrypted. I can't pull it out and that is really bothersome."
"They can improve checking the status of the CPU, memory, and IO utilization from each task."
"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."
More IDERA SQL Diagnostic Manager for SQL Server Pricing and Cost Advice →
IDERA ER/Studio is ranked 13th in Database Development and Management with 33 reviews while IDERA SQL Diagnostic Manager for SQL Server is ranked 11th in Database Development and Management with 9 reviews. IDERA ER/Studio is rated 8.4, while IDERA SQL Diagnostic Manager for SQL Server is rated 8.0. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of IDERA SQL Diagnostic Manager for SQL Server writes "Proactively alerts us on a wide variety of issues, but it has not scaled out well with our large environment". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and erwin Evolve by Quest, whereas IDERA SQL Diagnostic Manager for SQL Server is most compared with SolarWinds Database Performance Analyzer, Quest Spotlight, Redgate SQL Toolbelt, Quest Foglight for Databases and SQL Sentry.
See our list of best Database Development and Management vendors.
We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.