IDERA SQL Diagnostic Manager for SQL Server vs PubSub+ Platform comparison

IDERA SQL Diagnostic Manager for SQL Server vs. PubSub+ Platform

Download the complete report

Helped 859,129 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

IDERA SQL Diagnostic Manage...

Ranking in Event Monitoring

11th

Average Rating

8.0

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Database Development and Management (13th)

PubSub+ Platform

Ranking in Event Monitoring

13th

Average Rating

8.6

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Message Queue (MQ) Software (8th), Message Oriented Middleware (MOM) (2nd), Streaming Analytics (11th)

Featured Reviews

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

BhanuChidigam

Sofware Engineering Manager at Wells Fargo

Performs well, high availability, and helpful support

We use approximately four people for the maintenance of the solution. My advice to others is this solution has high throughput and is used for many stock exchanges. For business critical use cases, such as processing financial transactions at a quick speed, I would recommend this solution. I rate PubSub+ Event Broker an eight out of ten.

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

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

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

"The ability to go back and look at historical data is the most valuable feature."

"Memory and CPU utilization features are good."

"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 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 way we can replicate information and send it to several subscribers is most valuable. It can be used for any kind of business where you've got multiple users who need information. Any company, such as LinkedIn, with a huge number of subscribers and any business, such as publishing, supermarket, airline, or shipping can use it."

"Some valuable features include reconnecting topics, placing queues, and direct connections to MongoDB. The platform provides a dashboard to monitor the status of messages, such as how many have been processed or delivered, which is helpful for tracking performance."

"The most useful features has been the WAN optimization and probably the HybridEdge, which requires some third-party adapters or plugins. The idea that we can position Solace as a protocol-agnostic message transport fabric is key to our company having all manners of asynchronous messaging protocols from MQ, Kafka, JMS, etc. I really like the WAN optimization: Send once over a WAN, then distribute locally as many times as there are subscribers."

"We like the seamless flexibility in protocol exchange offering without writing a code."

"Guaranteed Messaging allows for us to transport messages between on-prem and the cloud without any loss of data."

"Going from something where we had outages and capacity issues constantly to a system that was able to scale with the massive market data and messaging spikes that happened during the initial stages of the COVID crisis in March, we were able to scale with 40 plus percent growth in our platform over the course of days."

"The most valuable feature of PubSub+ Event Broker is the scaling integration. Prior to using the solution, it was done manually with a file, and it can be done instantly live."

"One of the main reasons for using PubSub+ is that it is a proper event manager that can handle events in a reactive way."

More PubSub+ Platform pros

Cons

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

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

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

"The section on observability pertains to understanding the functioning of an event crash. Instead of focusing on how the crash occurs, attention is given to the observable aspects, such as a memory pipeline where one person pushes messages and another reads them. However, this pipeline often encounters issues, such as the reader being unavailable, causing the system to become stuck and preventing the messages from moving forward. This can lead to the pipeline being permanently stalled."

"The product should allow third-party agents to be installed. Currently, it is quite proprietary."

"For improvements, I would suggest increasing the max payload size to a limit of 100MB or more. The current max payload size is limited to 5MB."

"I would like them to design topic and queue schemas, mapping them to the enterprise data structure."

"One of the areas of improvement would be if we could tell the story a bit better about what an event mesh does or why an event mesh is foundational to a large enterprise that has a wide diversity of applications that are homegrown and a small number off the shelf."

"We've pointed out some things with the DMR piece, the event mesh, in edge cases where we could see a problem. Something like 99 percent of users wouldn't ever see this problem, but it has to do with if you get multiple bad clients sending data over a WAN, for example. That could then impact other clients."

"The licensing and the cost are the major pitfalls."

"It could be cheaper. It could also have easier usage. It is a brilliant product, but it is quite complex to use."

More PubSub+ Platform cons

Pricing and Cost Advice

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

"The licensing is dependent on the volume that is flowing. If you go for their support services, it will cost some more money, but I think it is worth it, especially if you are just starting your journey."

"Having a free version of the solution was a big, important part of our decision to go with it. This was the big driver for us to evaluate Solace. We started using it as the free version. When we felt comfortable with the free version, that is when we bought the enterprise version."

"It could be cheaper. Its licensing is on a yearly basis."

"We have been really happy with the product licensing rates. It has been free for us, up to a 100,000 transactions per second, and all we have to do is pay for support. Making their product available and accessible to us has not been a problem at all."

"Having a free version is critical for our technology operations use case. This is primarily because our technology operations team is a cost center in our company. They are not profit drivers and having a free version for installation will probably meet our needs. Even for production, it'll support up to a 100,000 messages per second. I don't think in technology operations that we have that many events and alerts from our detection tools. Even if I have 20 or 30 event detection products out there, they're only going to publish the things which are critical or warnings. I don't think we'll ever reach a 100,000 messages per second."

"I would rate the product's pricing a ten out of ten."

"The pricing and licensing were very transparent and well-communicated by our account manager."

"There are different tiers where you can choose what would work for you. As a customer, you need to know roughly how many messages a month you will use."

More PubSub+ Platform pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Event Monitoring solutions are best for your needs.

See recommendations

859,129 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

12%

Comms Service Provider

10%

Computer Software Company

Government

Financial Services Firm

33%

Computer Software Company

11%

Manufacturing Company

Retailer

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

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.

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

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.

What needs improvement with PubSub+ Event Broker?

Regarding improving the PubSub+ Platform, I'm not sure about the pricing aspect, but I heard that it is quite expensive compared to Kafka. That's the only concern I can mention; otherwise, it was a...

What is your primary use case for PubSub+ Event Broker?

My typical use case for the PubSub+ Platform is as an event-driven solution for communication between two components.

What advice do you have for others considering PubSub+ Event Broker?

I have experience working with Kafka, PubSub+ Platform, and IBM MQ, all three of them. We are customers, meaning my company uses Solace. We use it and customize it based on our needs. Based on my e...

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

Comparisons

Compared 32% of the time

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

Compared 26% of the time

SCOM vs IDERA SQL Diagnostic Manager for SQL Server

Compared 15% of the time

SQL Sentry vs IDERA SQL Diagnostic Manager for SQL Server

Compared 14% of the time

Quest Spotlight vs IDERA SQL Diagnostic Manager for SQL Server

Compared 13% of the time

More IDERA SQL Diagnostic Manager for SQL Server Competitors

Apache Kafka vs PubSub+ Platform

Compared 29% of the time

IBM MQ vs PubSub+ Platform

Compared 23% of the time

ActiveMQ vs PubSub+ Platform

Compared 11% of the time

Confluent vs PubSub+ Platform

Compared 9% of the time

Amazon SQS vs PubSub+ Platform

Compared 6% of the time

More PubSub+ Platform Competitors

Product Reports

IDERA SQL Diagnostic Manager for SQL Server

Download IDERA SQL Diagnostic Manager for SQL Server product report

IDERA SQL Diagnostic Manager for SQL Server report

PubSub+ Platform

Download PubSub+ Platform product report

Also Known As

IDERA SQL DM, IDERA SQL Diagnostic Manager

PubSub+ Event Broker, PubSub+ Event Portal

Overview

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

PubSub+ Platform supports real-time shipment tracking, IT event management in multiclouds, and connects legacy and cloud-native systems for application modernization. It's utilized for trading, streaming market data, and app-to-app messaging, enhancing event-driven architectures with reliable message queuing.

Organizations adopt PubSub+ to efficiently transport events across hybrid and cloud environments, managing audit trails and long processing tasks. The platform aids integration through dynamic data publication, event mesh capabilities, and WAN optimization. Features like seamless integration, protocol agnosticism, and flexible topic hierarchy enhance versatility. Solace Admin Utility simplifies configuration and management, while the event portal allows hybrid deployment.

What are the key features of PubSub+ Platform?

Dynamic Data Publication: Enables flexible and responsive data handling.
Event Mesh Capabilities: Facilitates efficient event transportation.
WAN Optimization: Enhances data transfer across networks.
Protocol Agnosticism: Supports a wide range of protocols for integration.
Flexible Topic Hierarchy: Allows detailed and organized data exchange.
Solace Admin Utility: Provides intuitive configuration and management.
Granular Topic Filtering: Offers precise data filtering options.
Guaranteed Messaging: Ensures reliable message delivery.

What benefits or ROI should users consider?

Seamless Integration: Reduces complexity in connecting systems.
Performance and Scaling: Supports high-load environments efficiently.
Asynchronous Messaging: Improves application performance.
Robust Support System: Provides guidance and problem resolution.

PubSub+ is implemented in industries requiring real-time data handling and integration between disparate systems. Financial institutions use it for trading and streaming market data, while logistics companies benefit from real-time shipment tracking. Enterprises apply it to modernize operations by connecting legacy systems with cloud-native applications, enhancing their architecture and ensuring data reliability across environments.

Solace

Sample Customers

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

FxPro, TP ICAP, Barclays, Airtel, American Express, Cobalt, Legal & General, LSE Group, Akuna Capital, Azure Information Technology, Brand.net, Canadian Securities Exchange, Core Transport Technologies, Crédit Agricole, Fluent Trade Technologies, Harris Corporation, Korea Exchange, Live E!, Mercuria Energy, Myspace, NYSE Technologies, Pico, RBC Capital Markets, Standard Chartered Bank, Unibet

IDERA SQL Diagnostic Manager for SQL Server vs. PubSub+ Platform