"It is easy to navigate."
"It creates transparency and makes everything work by being more transparent."
"The fault management is perfect."
"It covers a lot of different types of hardware. It can do a lot and saves us time."
"The containerization of different objects was very helpful in building an org structure. Being able to separately manage your MSP clients with separate visibility was also helpful."
"This product provides good visibility into applications at the backend."
"The monitoring just comes to us: "Oh, there's something wrong with that machine." It tells us. There are some 50,000 machines or so, all doing different things. And if they go down we hear about it."
"Some of the most valuable features are it's highly scalable, the carrier is great, and if something has SNMP, it can monitor it. It's a great network fault management solution."
"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."
"Memory and CPU utilization features are good."
"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."
"Monitors and alerts on our mission critical instances in real-time on a 24/7 basis."
"SQL DM made troubleshooting much easier and allowed multiple people to look into an issue with confidence."
"The ability to go back and look at historical data is the most valuable feature."
"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."
"The service has been wonderful. I like the people that I have had to deal with. The process is very straightforward. I call or use the website."
"I can and interrupt what's going on, bring a job down if I need to, and bring it back up."
"It's very secure, because it's a legacy application."
"OPS/REXX is valuable because it allows us almost unlimited flexibility in automating our system."
"It allows us to respond faster to issues. If there are issues that come out, we're able to capture a message and alert somebody about it."
"It is an easy product to use and it is stable."
"It's a very stable product. I very much like the SSM stuff in it. The rules engine, it's awesome."
"It reduces the number of repetitive motions required by a human to respond to the system."
"There should be a facility to integrate with other monitoring applications that are currently running in the environment."
"It doesn't really allow for multi-tenancy. If you're an ISP or an MSP and you want to use this tool to provide these types of fault management services to your customers, you would need a separate SpectroSERVER for each customer..."
"It needs better integration with other CA products."
"DX Spectrum needs better documentation on its complex features."
"It's not a great performance management tool. Its reporting capabilities are not very good at all."
"I would like to see them eliminate the Java console. The user interface for this is a Java applet that runs on your desktop, and it is very problematic for us."
"I would like to see better scalability, and maybe, a more intuitive user interface. "
"Technical support for this product is not so good. It needs improvement."
"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."
"They can improve checking the status of the CPU, memory, and IO utilization from each task."
"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."
"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."
"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."
"It would helpful if SQL DM could mark when changes are made within the program."
"The interfaces to USS, CA UIM could be better. CA Common Services interfaces - namely Zdata Mover, Zmessage Service, Zdatacolletcor - are poorly documented."
"Scalability is zero. It cannot be scaled because of its age."
"The GUI interface could be improved, but that is coming. They are working on that."
"It definitely needs more web-based interface, to be more mobile-open. More APIs, more open source to it."
"One thing that comes to mind is the MQ interface. The last time we tried to use it, it seemed a little clunky."
"Because of its age, it's a little bit difficult to modernize some of the integrations and some of the functions."
"Performing a stop/restart of OPS/MVS could be a little smoother. Without special coding, some undesired tasks will be started and some necessary tasks will be stopped if we have to bounce OPS/MVS during the day."
"Some of the command sequences are too long."
More IDERA SQL Diagnostic Manager for SQL Server Pricing and Cost Advice →
Earn 20 points