Try our new research platform with insights from 80,000+ expert users

CA Database Management for DB2 for zOS vs IDERA SQL Diagnostic Manager for SQL Server comparison

Broadcom and IDERA are both solutions in the Database Development and Management category. Broadcom is ranked #19 with an average rating of 10.0, while IDERA is ranked #13 with an average rating of 7.0. Broadcom holds a 0.3% mindshare in DDM, compared to IDERA’s 3.9% mindshare. Additionally, 100% of Broadcom users are willing to recommend the solution, compared to 92% of IDERA users who would recommend it.
CA Database Management for ...
Read 13 CA Database Management for DB2 for zOS reviews
  • 157 Views
  • 53 Comparison Views
100% willing to recommend
IDERA SQL Diagnostic Manage...
Read 9 IDERA SQL Diagnostic Manager for SQL Server reviews
  • 591 Views
  • 378 Comparison Views
92% willing to recommend
 

Comparison Buyer's Guide

Download the report
Executive SummaryUpdated on Jan 23, 2025

IDERA SQL Diagnostic Manager for SQL Server and CA Database Management for DB2 for zOS compete in database performance monitoring. IDERA is favored for pricing and strong customer service, while CA Database Management is noted for its extensive feature set that justifies its cost.

Features: IDERA SQL Diagnostic Manager for SQL Server provides features like real-time monitoring, customizable alerts, and performance forecasting. CA Database Management for DB2 for zOS includes tools for performance optimization, automation features, and advanced analytics tailored for complex DB2 environments.

Room for Improvement: IDERA could enhance its feature set for more complex environments, offer more advanced analytics, and provide broader DB2 support. CA Database Management might improve with simpler setup processes, more intuitive user interfaces, and broader support across non-DB2 environments.

Ease of Deployment and Customer Service: IDERA excels with its straightforward installation and responsive support, ideal for quick deployment. CA Database Management requires intricate setup due to its specialized nature but offers comprehensive documentation for support.

Pricing and ROI: IDERA SQL Diagnostic Manager for SQL Server boasts competitive pricing and high ROI thanks to its rapid deployment and multi-functional capacity. CA Database Management for DB2 for zOS involves higher setup costs yet provides significant ROI for enterprises demanding deep DB2 insights, seen as worthwhile due to its comprehensive features.

DOWNLOAD THE COMPLETE REPORT
To learn more, read our detailed CA Database Management for DB2 for zOS vs. IDERA SQL Diagnostic Manager for SQL Server Report (Updated: April 2025).
Buyer's Guide
CA Database Management for DB2 for zOS vs. IDERA SQL Diagnostic Manager for SQL Server
April 2025
Download the complete report
Helped 846,617 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

CA Database Management for ...
Ranking in Database Development and Management
19th
Average Rating
8.8
Reviews Sentiment
8.2
Number of Reviews
13
Ranking in other categories
No ranking in other categories
IDERA SQL Diagnostic Manage...
Ranking in Database Development and Management
13th
Average Rating
8.0
Reviews Sentiment
7.4
Number of Reviews
9
Ranking in other categories
Event Monitoring (12th)
 

Mindshare comparison

As of April 2025, in the Database Development and Management category, the mindshare of CA Database Management for DB2 for zOS is 0.3%, down from 0.6% compared to the previous year. The mindshare of IDERA SQL Diagnostic Manager for SQL Server is 3.9%, up from 3.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management
 

Featured Reviews

JG
Report generation offers invaluable insights into database performance
I basically use the solution for database management and to view the performance of a particular database object, any specific program, batch program, or online programs. Using the CSSZ tool, I can effectively monitor performance. In case of an exception, I can inform the application team. At DB2…
Read full review
SeniorDB3550 - PeerSpot reviewer
Proactively alerts us on a wide variety of issues, but it has not scaled out well with our large environment
We get hundreds of alerts per day, because we manage so many different servers and databases, that alert us to disk space issues, query issues, a wide variety of things. We take that information and we're able to make proactive decisions as to what we need to do. In terms of the solution helping us with performance monitoring and diagnostics, sticking with the alerting feature, 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. Overall, it has allowed us to do more with database management and run more databases on a given server, because we're able to isolate issues quicker and take the proactive steps necessary to correct them. We were spread out with many servers running databases. We've consolidated some 80 servers down to just a handful. We're getting more bang for the buck out of the equipment that we have.
Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most important features are batch reporting and the ability to create repositories, enabling automated analysis. These are valuable because they enable me to do automated analysis of trends over time and reduce the time for comparing performance between two periods to identify anomalies."
"Improved monitoring and performance management."
"​It helps us to reduce hardware costs and to optimize processing times.​"
"The reports generated and the old statistics shown are really helpful."
"​It is very stable. We have had no issues."
"It takes advantage of new features of DB2."
"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."
"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 ability to go back and look at historical data is the most valuable feature."
"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."
 

Cons

"In the case of any particular SQL which is executing for a longer time and causing issues with any particular store or DB2 programs, if it could pinpoint the problems like any other tool should do, that would be really helpful."
"All the information we need, we could use to have it in a more usable format.​"
"Minor stability issues."
"They need to provide a way to create and maintain performance repositories. The online tool is not perfect, but it is giving me what I need."
"It would helpful if SQL DM could mark when changes are made within the program."
"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."
"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."
"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."
"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'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."
 

Pricing and Cost Advice

Information not available
"We were upgraded to Premium Support without their actually asking us, when we were quoted. Then I asked for Standard Support and that they had to re-quote us that. But they don't do that by default. They upcharge you by default, which I didn't think was very nice, without even asking."
"The pricing is reasonable, it's comparable with the competitors."
report
See which vendors are best for you
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
See recommendations
846,617 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
14%
Computer Software Company
10%
Comms Service Provider
8%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What needs improvement with CA Database Management for DB2 for zOS?
In the case of any particular SQL which is executing for a longer time and causing issues with any particular store or DB2 programs, if it could pinpoint the problems like any other tool should do,...
See all answers
What is your primary use case for CA Database Management for DB2 for zOS?
I basically use the solution for database management and to view the performance of a particular database object, any specific program, batch program, or online programs. Using the CSSZ tool, I can...
See all answers
What advice do you have for others considering CA Database Management for DB2 for zOS?
The solution operates on JetOS platform. It is a very good, perfect solution. I would rate it ten out of ten. Currently, I do not have any planning for investment at all.
See all answers
What do you like most about IDERA SQL Diagnostic Manager for SQL Server?
The ability to go back and look at historical data is the most valuable feature.
See all answers
What needs improvement with IDERA SQL Diagnostic Manager for SQL Server?
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. In future releases, I w...
See all answers
What is your primary use case for IDERA SQL Diagnostic Manager for SQL Server?
We use it mainly for monitoring, including CPU, memory, and disk space, and for troubleshooting purposes.
See all answers
 

Comparisons

No data available
SolarWinds Database Performance Analyzer vs IDERA SQL Diagnostic Manager for SQL Server Logo
SolarWinds Database Performance Analyzer vs IDERA SQL Diagnostic Manager for SQL Server
Compared 44% of the time
Redgate SQL Toolbelt Essentials vs IDERA SQL Diagnostic Manager for SQL Server Logo
Redgate SQL Toolbelt Essentials vs IDERA SQL Diagnostic Manager for SQL Server
Compared 31% of the time
SCOM vs IDERA SQL Diagnostic Manager for SQL Server Logo
SCOM vs IDERA SQL Diagnostic Manager for SQL Server
Compared 13% of the time
SQL Sentry vs IDERA SQL Diagnostic Manager for SQL Server Logo
SQL Sentry vs IDERA SQL Diagnostic Manager for SQL Server
Compared 12% of the time
More IDERA SQL Diagnostic Manager for SQL Server Competitors
 

Product Reports

Buyer's Guide
Database Development and Management
April 2025
CA Database Management for DB2 for zOS reportDownload CA Database Management for DB2 for zOS product report
Buyer's Guide
IDERA SQL Diagnostic Manager for SQL Server
April 2025
IDERA SQL Diagnostic Manager for SQL Server reportDownload IDERA SQL Diagnostic Manager for SQL Server product report
 

Also Known As

CA Database Management Solutions for DB2 for z/OS
IDERA SQL DM, IDERA SQL Diagnostic Manager
 

Overview

Database Management for DB2 for z/OS solutions from CA Technologies provide a set of tools designed to ensure optimal database and SQL performance, efficient administration, and reliable backup and recovery of DB2 databases, systems and apps.
Broadcom

SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance problems in physical, virtual, and cloud environments. Unlike its competition, it provides effective scalability, advanced SQL query analysis and optimization, prescriptive analysis with corrective SQL scripts, powerful automated alert responses, broad PowerShell integration, complete customization, and extensive support for current and legacy SQL Server and Windows.

IDERA
 

Sample Customers

Blue Hill Data Services
Padnos, University of Notre Dame, D4, Infeon Technologies, Chevron, LC Waikiki, Sisters of Saint Francis Health Services, Seattle Cancer Care Alliance, CVE, Colorado State University, St. Charles, Chaucer PLC, 1-800-Flowers, Ancoris, Money Management, National Opinion Research Center, California Department of Health, Plexus; Aviva, Burlington Northern Santa Fe, CBS, Comcast, Google, Merck, Regions Financial, Schneider Electric, Tata Consultancy Services, Verizon Communications, Zurich Financial Services
Buyer's Guide
CA Database Management for DB2 for zOS vs. IDERA SQL Diagnostic Manager for SQL Server
April 2025
Free Report: CA Database Management for DB2 for zOS vs. IDERA SQL Diagnostic Manager for SQL Server
Find out what your peers are saying about CA Database Management for DB2 for zOS vs. IDERA SQL Diagnostic Manager for SQL Server and other solutions. Updated: April 2025.
DOWNLOAD NOW
846,617 professionals have used our research since 2012.
See our CA Database Management for DB2 for zOS vs. IDERA SQL Diagnostic Manager for SQL Server report.
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.