IBM InfoSphere Optim vs IDERA SQL Diagnostic Manager for SQL Server vs SharePlex comparison

The compared IBM and IDERA solutions aren't in the same category. IBM is ranked #14 in DDM , with an average rating of 7.0, and holds a 2.4% mindshare in the category. IDERA is ranked #12 in DDM , and holds a 3.1% mindshare. Additionally, 75% of IBM users are willing to recommend the solution, compared to 92% of IDERA users who would recommend it.

IBM InfoSphere Optim

Read 4 IBM InfoSphere Optim reviews

1,464 Views
1,376 Comparison Views

75% willing to recommend

IDERA SQL Diagnostic Manage...

Read 9 IDERA SQL Diagnostic Manager for SQL Server reviews

2,553 Views
1,838 Comparison Views

92% willing to recommend

SharePlex

Read 5 SharePlex reviews

3,177 Views
2,065 Comparison Views

100% willing to recommend

IBM InfoSphere Optim

IDERA SQL Diagnostic Manage...

SharePlex

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between IBM InfoSphere Optim, IDERA SQL Diagnostic Manager for SQL Server, and SharePlex based on real PeerSpot user reviews.

Find out what your peers are saying about Quest Software, Nutanix, Oracle and others in Database Development and Management.

To learn more, read our detailed Database Development and Management Report (Updated: May 2026).

Buyer's Guide

Database Development and Management

May 2026

Download the complete report

Helped 899,258 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:

Mindshare comparison

Database Development and Management Mindshare Distribution
Product	Mindshare (%)
IBM InfoSphere Optim	2.4%
Oracle Enterprise Manager	4.0%
Redgate SQL Toolbelt Essentials	4.0%
Other	89.6%

Database Development and Management

Database Development and Management Mindshare Distribution
Product	Mindshare (%)
IDERA SQL Diagnostic Manager for SQL Server	3.1%
Oracle Enterprise Manager	4.0%
Redgate SQL Toolbelt Essentials	4.0%
Other	88.9%

Database Development and Management

Data Integration Mindshare Distribution
Product	Mindshare (%)
SharePlex	1.1%
Informatica Intelligent Data Management Cloud (IDMC)	3.7%
SSIS	3.6%
Other	91.6%

Data Integration

Featured Reviews

Kenneth Estanislao

Solutions Designer at a insurance company with 10,001+ employees

Backups become efficient while cost concerns remain

I am still working with IBM and we are transitioning to other tools rather than using IBM InfoSphere Optim. We use other tools, but I cannot recall the name because I am not the one currently handling it. It has transitioned to other architects. For IBM InfoSphere Optim, we are still currently using it, but we have transitioned to the newer version, the latest one with support for AWS S3. I cannot identify a main competitor for IBM InfoSphere Optim because we have transitioned to other architects, and they are the ones looking for other tools. The last comparison I did was almost 4 years ago. I am not using any AI technology with IBM InfoSphere Optim. I rate IBM InfoSphere Optim a seven out of ten. The tool is good, but the price is not favorable as it is the most expensive part. I can recommend IBM InfoSphere Optim for enterprises.

Read full review

reviewer2317098

Assistant at a tech services company with 1,001-5,000 employees

Offers effective monitoring of resources but lacks the ability to connect to an AWS instance and write custom queries.

We use it mainly for monitoring, including CPU, memory, and disk space, and for troubleshooting purposes We've set up alerts to notify us when performance deviates from the baseline we've configured for each resource. So, whenever that happens, we get an alert and can investigate immediately. So,…

Read full review

Kristopher Wells

Oracle DBA at a financial services firm with 5,001-10,000 employees

It reduces the downtime and migration time exponentially

I would rate SharePlex's high availability, and disaster recovery features highly. It works as advertised in terms of rapid fill-over and switch-over opportunities. It reduces the migration time for a multi-terabyte database to an hour or less because it performs real-time replication. SharePlex reduces downtime and migration time exponentially. Something that could take 12 to 24 hours is cut down to one to two hours. By the time you start to migrate, the only remaining replication is a slight difference in data from the point when SharePlex has shut down, and the application has to also switch over to the new database. It allowed the company to replicate data more transparently. Some of the business executives probably don't even know it's there. It works 100 percent of the time, with little downtime or problems. It provides what is needed. There's little concern about whether or not it functions. It's allowed the company to achieve its objectives with its clients, reducing and minimizing downtime for substantial migrations and upgrades. It can reduce hardware and storage costs, but my company doesn't utilize it with high-availability architecture.

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 compression feature is valuable because it achieves around 80% compression."

"We like that we can easily restore the database with just a few clicks. The database is linked as well."

"I feel the solution to be a bit faster than the traditional methods, which makes it easy to customize."

"Ability to identify bottlenecks, deadlocks and slow running queries and run monthly and daily reports."

"Monitors and alerts on our mission critical instances in real-time on a 24/7 basis."

"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."

"SQL DM made troubleshooting much easier and allowed multiple people to look into an issue with confidence."

"Memory and CPU utilization features are good."

"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."

"SQL monitoring time has been dramatically reduced and our IT Infrastructure team has improved SQL maintenance and monitoring knowledge over time just by using SQL DM."

More IDERA SQL Diagnostic Manager for SQL Server pros

"Try it out in your production and you won't be disappointed."

"Because of the volume of the transactions, we heavily use a feature that allows SharePlex to replicate thousands of transactions. It's called PEP, Post Enhancement Performance, and that has helped us scale tremendously."

"The synchronization, data backup, and data transfer are all valuable features of the solution."

"The core replication and its performance. Performance is crucial, and SharePlex is by far the fastest. The way it handles replication to multiple targets along with basic filtering, as well as from multiple sources to a single target, is very efficient."

"SharePlex has been a good fit for us because it was not as expensive compared to GoldenGate, it was stable compared to AWS DMS, and it was a good product for what we were looking for and within our budget too."

"It works 100 percent of the time, with little downtime or problems."

"There are some capabilities within SharePlex where you can see how the data is migrating and if it still maintains good data integrity. For example, if there are some tables that get out of sync, there are ways to find them and fix the problem on the spot. Since these are very common issues, we can easily fix these types of problems using utilities, like compare and repair. So, if you find something is out of sync, then you can just repair that table. It basically syncs that table from source to target to see if there are any differences. It will then replicate those differences to the target."

"The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent."

More SharePlex pros

Cons

"The potential room for improvement for IBM InfoSphere Optim is usually its cost, as it is too expensive."

"While the solution is very supportive of Db2, it is not so friendly when it comes to IMS databases."

"We're looking for a solution that can be implemented on AWS. IBM InfoSphere Optim can be implemented on AWS, but it costs more than double what we're currently paying. So, it's not really of good value for us."

"While masking PII information in huge tables [more than 500 million record count with more than five PII columns present] the Extract-Convert-Load [ECL] process becomes extremely slow and can take a huge amount of time."

"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."

"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."

"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."

"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."

"With basic SQL training in my history, I've found at times I needed to Google SQL counters, for example, to understand what was occurring or how to configure SQL DM to be useful."

"They can improve checking the status of the CPU, memory, and IO utilization from each task."

More IDERA SQL Diagnostic Manager for SQL Server cons

"For its function in relation to replication (i.e. filtering), I'd give it a six or seven out of 10. GoldenGate has much more functionality by comparison."

"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication."

"The reporting features need improvement."

"I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us."

"I would like more ability to automate installation and configuration in line with some of the DevOps processes that are more mature in the market. That would be a considerable improvement."

"I would like the solution to have some kind of machine learning and AI capabilities."

"I don't know how easy it would be to change the architecture in an already implemented replication. For example, if we have a certain way of architecting for a particular database migration and want to change that during a period of time, is that an easy or difficult change? There was a need for us to change the architecture in-between the migration, but we didn't do it. We thought, "This is possibly complicated. Let's not change it in the middle because we were approaching our cutover date." That was one thing that we should have checked with support about for training."

"I don't know how easy it would be to change the architecture in an already implemented replication."

Pricing and Cost Advice

"IBM InfoSphere Optim is a very expensive solution. Actually, it's the most expensive archiving solution that we have."

"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."

"It is not as expensive as Oracle GoldenGate and has worked really well within our budgets."

"It's really good value for the money. There are some things they could improve on, but in terms of the pricing, features, and support, as a holistic package, we are not thinking of anything else at this point in time."

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

899,258 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

21%

Outsourcing Company

Insurance Company

Retailer

Construction Company

10%

Comms Service Provider

Healthcare Company

Outsourcing Company

Construction Company

10%

Financial Services Firm

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

By reviewers
Company Size	Count
Small Business	3
Midsize Enterprise	5
Large Enterprise	4

No data available

Questions from the Community

What needs improvement with IBM InfoSphere Optim?

The potential room for improvement for IBM InfoSphere Optim is usually its cost, as it is too expensive. Currently, t...

See all answers

What is your primary use case for IBM InfoSphere Optim?

My current use case for IBM InfoSphere Optim is just for doing backups. We are using IBM InfoSphere Optim specificall...

See all answers

What advice do you have for others considering IBM InfoSphere Optim?

I am still working with IBM and we are transitioning to other tools rather than using IBM InfoSphere Optim. We use ot...

See all answers

Ask a question

Earn 20 points

Ask a question

Earn 20 points

Comparisons

BMC AMI DevX vs IBM InfoSphere Optim

Compared 14% of the time

Oracle Enterprise Manager vs IBM InfoSphere Optim

Compared 12% of the time

CA Mainframe Configuration Manager vs IBM InfoSphere Optim

Compared 11% of the time

Solix Enterprise Data Management vs IBM InfoSphere Optim

Compared 11% of the time

Archon Data Store vs IBM InfoSphere Optim

Compared 9% of the time

More IBM InfoSphere Optim Competitors

Redgate SQL Toolbelt Essentials vs IDERA SQL Diagnostic Manager for SQL Server

Compared 12% of the time

SolarWinds Database Performance Analyzer vs IDERA SQL Diagnostic Manager for SQL Server

Compared 8% of the time

Spotlight vs IDERA SQL Diagnostic Manager for SQL Server

Compared 7% of the time

BMC TrueSight vs IDERA SQL Diagnostic Manager for SQL Server

Compared 7% of the time

SCOM vs IDERA SQL Diagnostic Manager for SQL Server

Compared 6% of the time

More IDERA SQL Diagnostic Manager for SQL Server Competitors

Oracle Data Integrator (ODI) vs SharePlex

Compared 8% of the time

Oracle GoldenGate vs SharePlex

Compared 6% of the time

SSIS vs SharePlex

Compared 6% of the time

Informatica PowerCenter vs SharePlex

Compared 6% of the time

Qlik Replicate vs SharePlex

Compared 5% of the time

More SharePlex Competitors

Product Reports

Buyer's Guide

Database Development and Management

May 2026

Download IBM InfoSphere Optim product report

Buyer's Guide

IDERA SQL Diagnostic Manager for SQL Server

June 2026

IDERA SQL Diagnostic Manager for SQL Server report

Download IDERA SQL Diagnostic Manager for SQL Server product report

Buyer's Guide

SharePlex

May 2026

Download SharePlex product report

Also Known As

IBM Optim, Optim

IDERA SQL DM, IDERA SQL Diagnostic Manager

Dell SharePlex, SharePlex

Overview

IBM InfoSphere Optim provides comprehensive data lifecycle management, streamlining data archiving, test data management, and data privacy capabilities for businesses, enhancing efficiency and compliance.

IBM InfoSphere Optim is designed to address complex data management needs across large enterprises. It facilitates efficient data archiving, minimizes storage costs, and ensures robust data protection. This tool supports IT teams in tailoring customized data privacy solutions while maintaining data integrity and accessibility. Adopting InfoSphere Optim can significantly optimize a company's IT operations by managing data from multiple domains, ensuring compliance, and enabling a refined approach to data governance.

What are the key features of IBM InfoSphere Optim?

Data Archiving: Efficient storage solutions to retain historical data and reduce infrastructure costs.
Test Data Management: Streamlined testing processes with synthetic data creation for accurate results.
Data Privacy: Advanced privacy controls to protect sensitive information across environments.
Application Retirement: Seamless migration and storage solutions for obsolete applications to maintain data relevance.

What benefits and ROI should users consider?

Cost Efficiency: Reduces storage and maintenance expenses by optimizing data management.
Improved Compliance: Ensures adherence to industry regulations through meticulous data handling.
Enhanced Productivity: Streamlines data processes, freeing up resources for other critical operations.
Risk Mitigation: Lowers the risk of data breaches with advanced security protocols.

In industries such as finance, healthcare, and retail, IBM InfoSphere Optim is instrumental in addressing data management challenges. For financial institutions, it aids in managing historical transaction data while ensuring compliance with regulatory demands. Healthcare providers utilize its capabilities to secure patient data and improve the quality of test data management. Retail businesses benefit from its ability to manage customer data across multiple touchpoints, enhancing decision-making and strategic planning.

IBM

IDERA SQL Diagnostic Manager for SQL Server is designed for real-time monitoring of crucial SQL Server instances, offering insights into server performance and enabling proactive management without coding complications.

IDERA SQL Diagnostic Manager for SQL Server provides comprehensive features for monitoring and managing SQL Server environments. It offers customizable alerts and disk space projections, as well as capabilities for snapshotting and historical data analysis to detect database issues like deadlocks and slow queries. Users can baseline environments, define thresholds, and use pre-designed reports for effective resource planning. The tool supports operational tasks with ease by providing insights into CPU, memory, and disk usage.

What are the key features of IDERA SQL Diagnostic Manager for SQL Server?

Customizable Alerts: Offers tailored alerts for performance and resource utilization issues.
Disk Space Projections: Provides forecasts on space usage to prevent storage issues.
Snapshotting: Captures point-in-time views for detailed analysis.
Historical Data Analysis: Tracks performance over time for trend analysis.
Bottleneck Identification: Pinpoints slow-running queries and deadlocks swiftly.

What are users saying about the benefits of IDERA SQL Diagnostic Manager for SQL Server?

Proactive Issue Resolution: Enables early identification of issues, reducing downtime.
Enhanced Performance: Improves server response times through detailed analytics.
Efficient Resource Management: Aids in optimizing CPU and memory usage.
Data-Driven Decision Making: Facilitates informed planning with comprehensive reports.

In industries requiring uninterrupted database operation, IDERA SQL Diagnostic Manager for SQL Server is essential for managing multiple SQL Server instances efficiently. Organizations focused on performance, such as financial institutions and e-commerce companies, implement it to ensure environments remain optimized, minimizing potential disruptions and enhancing operational continuity.

IDERA

SharePlex delivers robust database replication and migration capabilities, emphasizing performance, synchronization, and data integrity management. Supporting high availability and real-time data syncing, it serves organizations handling vast transaction volumes, especially in IoT data processing.

SharePlex offers reliable data transfer and efficient multi-target replication. Its features like Compare and Repair utilities assist in maintaining data consistency. With PEP fostering scalability for large transactions, it caters to businesses aiming to cut down migration windows and minimize outages. Users employ SharePlex in real-time syncing and failover scenarios across data centers, crucial for handling extensive transaction data during migrations or upgrades.

What are SharePlex's key features?

Core Replication: Ensures reliable data synchronization across multiple targets.
Data Integrity Management: Maintains accuracy during reading and writing processes.
Compare and Repair Utilities: Facilitate data consistency checks and fixes.
PEP: Enhances performance for large transaction volumes.

Why consider SharePlex for your database needs?

Scalability: Supports large-scale transactions with efficiency.
Minimized Downtime: Provides continuous data availability during operations.
Business Continuity: Enables seamless failover and data center transitions.
Real-time Syncing: Supports time-sensitive data processing requirements.

Organizations in sectors like finance and telecommunications implement SharePlex to maintain uninterrupted operations and ensure quick recovery times. By facilitating database migrations to cloud platforms like AWS, they achieve reduced downtime and enhanced operational efficiency, catering to the rigorous demands of data-driven industries.

Quest Software

Sample Customers

Durham Police Department, Coca-Cola Enterprises Inc., Continental, KCE Electronics Public Company Limited, The University of Adelaide, Migros Zurich, COPROB

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

Bodybuilding.com, Priceline.com, Ameco Beijing, Viasat, SK Broadband

Buyer's Guide

Database Development and Management

May 2026

Download Free Report

Find out what your peers are saying about Quest Software, Nutanix, Oracle and others in Database Development and Management. Updated: May 2026.

DOWNLOAD NOW

899,258 professionals have used our research since 2012.