IDERA SQL Diagnostic Manager for SQL Server vs OpsRamp comparison

IDERA SQL Diagnostic Manage...

Read 13 OpsRamp reviews

4,398 Views
1,100 Comparison Views

84% willing to recommend

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jan 23, 2025

IDERA SQL Diagnostic Manager for SQL Server and OpsRamp compete in database and IT infrastructure management. IDERA provides superior performance monitoring and diagnostics, whereas OpsRamp excels in IT infrastructure management and integration.

Features: IDERA SQL Diagnostic Manager offers advanced SQL Server performance monitoring, proactive alerting, and customizable reporting. It helps database administrators gain in-depth insights and manage database health effectively. OpsRamp provides hybrid environment monitoring, automation capabilities, and seamless integration with ITSM tools, catering to broader IT operational needs and application monitoring.

Room for Improvement: IDERA SQL Diagnostic Manager could improve its interface for better user experience, enhance integration with other IT management tools, and expand its capabilities beyond SQL Server environments. OpsRamp could benefit from refining its dashboard for enhanced clarity, expanding its predictive analysis features, and reducing complexity in initial configuration processes.

Ease of Deployment and Customer Service: IDERA SQL Diagnostic Manager is praised for its quick setup process and efficient customer service, making it ideal for database-focused environments. OpsRamp provides a cloud-based deployment model suitable for rapid scaling in hybrid IT environments and is backed by strong technical support for widespread IT management.

Pricing and ROI: IDERA SQL Diagnostic Manager offers a cost-effective solution with a significant return on investment for SQL Server management, attracting businesses focused on database performance. OpsRamp demands a higher initial investment but justifies it with notable ROI through its comprehensive IT operation capabilities and scalability.

To learn more, read our detailed IDERA SQL Diagnostic Manager for SQL Server vs. OpsRamp Report (Updated: July 2025).

IDERA SQL Diagnostic Manager for SQL Server vs. OpsRamp

July 2025

Download the complete report

Helped 865,384 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 (12th)

OpsRamp

Ranking in Event Monitoring

2nd

Average Rating

7.8

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

IT Infrastructure Monitoring (16th), AIOps (6th)

Mindshare comparison

As of August 2025, in the Event Monitoring category, the mindshare of IDERA SQL Diagnostic Manager for SQL Server is 1.9%, up from 1.6% compared to the previous year. The mindshare of OpsRamp is 14.8%, up from 13.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Event Monitoring

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

Muhammad Umair Gulfam

Implementation Engineer at a computer software company with 201-500 employees

Automates Azure resource monitoring and inventory management but slow with real-time patch status

There is room for improvement in the performance of the product. The main problem is with patch management. The actual problem we're facing is with the patch management feature. It's not real-time, which creates inconsistencies. The machine might say there are no updates available, while the OpsRamp agent reports that everything's patched. It's a mismatch. We recently started a new marketplace for clients where we manage patch management. We try to share knowledge with OpsRamp, but they don't have a rapid process for product enhancements. Our main pain point is the lack of engagement from the product team. If someone from OpsRamp could discuss our concerns, work on future enhancements, or even give us an estimated timeline (ETA), it would be a huge improvement.

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

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

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

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

"The technical support is fantastic, and they are fast to respond."

"The feature we found most valuable in OpsRamp is alert generation because whenever there is any kind of spike on any virtual machine, the solution generates alerts based on the thresholds we implemented. We have integrated our ideas and tools with OpsRamp, so alerts are generated, then we notify the customers. That's the main feature we like about OpsRamp because we don't have to monitor each resource. Instead, OpsRamp does the monitoring for us, and it generates the alerts based on the thresholds."

"The multi-tenant architecture capability of OpsRamp has helped me streamline and improve the processes within my organization."

"Most features work fine."

"It greatly assists small and medium-sized businesses in using the ITSM, alerting, and monitoring features."

"It is a pretty stable solution."

"The feature that we have found most useful are the dashboards, which can be built in minutes using this solution, allowing multiple products, thresholds, or any given required metric to be seen in a single area."

"The most valuable feature of OpsRamp is the creation of the dashboards of the infrastructure for the CPU memory and SQL servers. Additionally, URL monitoring through Selenium scripting and the availability dashboard is useful."

More OpsRamp pros

Cons

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

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

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

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

"It would helpful if SQL DM could mark when changes are made within the program."

"We have 55 AVDs, and patches might roll out to 32-35 initially, with the rest taking a month or so. OpsRamp can't detect them all directly. Since clients want patches applied as soon as possible, we manually patch those remaining devices."

"The function to search any particular device within this solution needs to be improved. Currently, the solution develops a lag when a search, or a comparison, is being carried out."

"Currently, it performs infrastructure monitoring but has limited capability in application monitoring, which needs improvement."

"What's lacking in OpsRamp is process automation, and if there is, I wish there could be more of it, other than just spikes, or it would be better if the alerts can be generated based on different matrices. That option is absent in OpsRamp at the moment, and it would be valuable if that could be provided in the solution, especially if there's any kind of security issue in the VM."

"OpsRamp had shortcomings associated with its network capabilities."

"OpsRamp could improve the critical alerts. We have been receiving some false alerts when monitoring. For example, the alert shows the site is down, but when we try to do manual access to the URL, it's accessible."

"The user interface of this product requires some changes as it is not inclusively user-friendly. For example, the performance indicators are color-based , which means that they are confusing for anyone who is color blind."

"I would like to see two things. The first is a self-service portal for the cloud, any cloud deployments, and the second is maturity validation towards ITSM, internalizing OpsRamp TSM. As a result, instead of integrating with more mature tools similar to ServiceNow, people will use OpsRamp."

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

"I don't have any idea about the licensing cost for OpsRamp, but I just know that its pricing is based on the resource count for each tenant."

"There is an annual licensing fee to use OpsRamp."

"You pay it for a year and you'll have full access to the entire platform, not only for monitoring and alerting, you will have access to the entire platform, and whatever technology they develop will be made available to you."

"OpsRamp is a cost-effective solution."

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

865,384 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

11%

Comms Service Provider

Insurance Company

Computer Software Company

15%

Manufacturing Company

13%

Financial Services Firm

11%

Real Estate/Law Firm

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 do you like most about OpsRamp?

Most features work fine.

What is your experience regarding pricing and costs for OpsRamp?

I share the impression that OpsRamp pricing is fair; it does not strike me as expensive, and the licensing model is clear enough.

What needs improvement with OpsRamp?

If we treat OpsRamp as an infrastructure monitoring tool, there are many positive aspects. However, when viewed as an AIOps tool, there are numerous potential additions. Currently, it performs infr...

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

Comparisons

Compared 34% of the time

SolarWinds Database Performance Analyzer 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 13% of the time

Spotlight vs IDERA SQL Diagnostic Manager for SQL Server

Compared 12% of the time

More IDERA SQL Diagnostic Manager for SQL Server Competitors

Dynatrace vs OpsRamp

Compared 14% of the time

ServiceNow IT Operations Management vs OpsRamp

Compared 12% of the time

Datadog vs OpsRamp

Compared 11% of the time

SolarWinds NPM vs OpsRamp

Compared 8% of the time

LogicMonitor vs OpsRamp

Compared 6% of the time

More OpsRamp Competitors

Product Reports

IDERA SQL Diagnostic Manager for SQL Server

August 2025

IDERA SQL Diagnostic Manager for SQL Server report

Download IDERA SQL Diagnostic Manager for SQL Server product report

Download OpsRamp product report

August 2025

Also Known As

IDERA SQL DM, IDERA SQL Diagnostic Manager

No data available

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

OpsRamp is a leading cloud-based digital IT operations management platform. The solution allows your organization to leverage hybrid observability, process automation, and machine learning to modernize IT operations. OpsRamp can handle the speed, scope, and scale of modern IT and can help you drive productivity and business value. In addition, it can help your business manage, monitor, and consolidate your point tools and applications.

OpsRamp Features

OpsRamp has many valuable key features. Some of the most useful ones include:

Modern infrastructure monitoring: OpsRamp provides end-to-end visibility across applications, data centers, public clouds, point tools, and more.

Intelligent incident management: With this OpsRamp feature, you gain better problem identification, impact analysis, and first response for incidents with a streamlined process. This leads to proactive resolution and automated remediation that natively integrates with your ITSM tools.

Modern IT operations management: OpsRamp can help you consolidate your multiple point tools with its modern, SaaS-based IT operations platform. The solution can combine artificial intelligence, hybrid infrastructure monitoring, incident remediation, and service and topology mapping, so it can easily evolve with your organization

Service-centric AIOps: OpsRamp gives you the ability to examine your incidents, establish a tight feedback loop between your different teams, and reduce alert floods. Additionally, the solution enables your organization to deliver quick resolutions by using OpsQ, its artificial intelligence-powered event management engine.

Cloud migration: OpsRamp is a true multi-tenant, multi-tier SaaS platform that helps you move more applications and workloads to the cloud faster.

Curated dashboards: By using OpsRamp, IT teams can build curated dashboards using PromQL queries. A central dashboard repository can also be created if needed, and dashboards can be reused for shared IT services as necessary.

Topology maps: With OpsRamp’s service-aware topology maps, you are able to keep track of your entire hybrid IT infrastructure, enabling you to troubleshoot issues by using real-time dependencies for hybrid services.

OpsRamp Benefits

There are many benefits to implementing OpsRamp. Some of the biggest advantages the solution offers include:

Autodiscovery: OpsRamp auto-discovers multi-cloud and on-premises infrastructure across your IT environment and maps it to your IT services.

Multi-cloud telemetry and real-time events: The solution captures multi-cloud telemetry and real-time events as they occur so that your organization is able to make data-driven decisions by using the right performance and consumption insights.

Take action faster: OpsQ, the solution’s AIOps event management engine, drives faster incident resolution and helps reduce MTTD/MTTR of business-critical services.

Improved efficiency: OpsRamp helps deliver IT operations as a service. With the platform, you can automate workloads, manage multi-cloud costs, and see your IT operations become more efficient.

Flexible integrations: With OpsRamp, you do not have to get rid of your existing tools. The OpsRamp platform can consolidate them all into one contextual view using the metrics that matter most.

Monitoring integration support: OpsRamp delivers monitoring integration support for more than 150 cloud services across the leading three cloud providers: Amazon Web Services, Microsoft Azure, and Google Cloud.

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

Epsilon, CloudBrix, GreenPages, NIIT Technologies