BMC TrueSight Operations Management vs IDERA SQL Diagnostic Manager for SQL Server comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between BMC TrueSight Operations Management and IDERA SQL Diagnostic Manager for SQL Server based on real PeerSpot user reviews.

Find out what your peers are saying about BMC, ServiceNow, Microsoft and others in Event Monitoring.
To learn more, read our detailed Event Monitoring Report (Updated: February 2024).
763,955 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The solution's event management capabilities are fantastic. We do a best of breed. If, on the network side, they use a different tool, we pull all that data in so that we have a single console. It's kind of like the monitor of monitors. We're able to aggregate all the different types of data sets, whether it's log data, app data, OS data, infrastructure data, or network data. We're able to aggregate all those events and then correlate and be able to say we're having an event.""The Event Management is outstanding; still is the most interesting part of the product.""The tailoring of the knowledge modules has been particularly useful as I can streamline the agents to only report on critical events.""The solution has a very good business event manager tool.""Using the TrueSight platform we can monitor server performance and notify the customers using the integrated ticketing for events. We can let them know if there are any issues with a server, or application, or database.""TSOM's ability to consolidate alerts into a single location and provide filtering of alerts is great.""It provides common administration, and a Single Sign-On Platform with RBAC, which eases the cross launch between multiple tools""The ability of this platform to monitor the very diverse assets that we maintain around the world is its most valuable feature... We support a vast array of manufacturers' equipment, like HP, IBM, Cisco, Dell, EMC, Hitachi... We can do it all with [this] one [solution]."

More BMC TrueSight Operations Management Pros →

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

More IDERA SQL Diagnostic Manager for SQL Server Pros →

Cons
"BMC's solutions for cloud monitoring (monitoring of AWS and Azure resources) are very poor in stability and customization.""Application performance management (APM) is an area with certain shortcomings in the solution that needs improvement. I""The solution should improve predicting events and flaws in service. It also needs to improve integration with other systems.""One of the things that the TrueSight environment is missing is some of the HA abilities. The data collection server called the ISM doesn't really have the HA functionality or workload balancing. It was missing from the previous product as well. It's missing redundancy.""The solution is overly complex.""In our company, we faced some issues with the solution’s application endpoint, IP, and the physical location of the transactions.""The solution could improve its price.""The pricing could be better."

More BMC TrueSight Operations Management 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.""It would helpful if SQL DM could mark when changes are made within the program.""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.""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.""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."

More IDERA SQL Diagnostic Manager for SQL Server Cons →

Pricing and Cost Advice
  • "Use conservative figures. In terms of hardware, monitored servers and also effort. The product is not cheap. But as with other products, you get what you pay for."
  • "The solutions are not the cheapest but are robust and stable. License model is rather complex and BMC do often change the model."
  • "Pricing is very high."
  • "We pay license fees of between $150 and $200 per asset. There is an enterprise software license fee, and then you pay a percentage for your maintenance, and then Premier Support. For example, if you buy a two-year license for the product, then the maintenance fee is added to that for two years at X percent a year. Then there's a small fee on top of that for Premier Support..."
  • "Pricing is all volume-driven. I think we were paying between $80 and $85 per license. That's per unit, for a perpetual license. You pay it one time and then, every year, you pay 20 percent of that for annual maintenance and support. But now that we've grown, we've purchased tens of thousands of licenses and the cost per license has gone down to something like less than $30..."
  • "It is a large, complex product. So, there is a commitment of manpower to deploy it, as it is not a cheap product."
  • "There is a big upfront cost when you buy the license, then there is annual maintenance. We look at, if I bought a license and paid for maintenance for five years, then average it out, what would be my monthly cost. We have had some of the competing tools come in around four dollars. This is coming in as a premium, which is why I don't have it deployed as I would like it. Therefore, we're in negotiations right now. If I can get it down to the four dollar range, I will triple my deployment in a year and a half."
  • "The only possible additional cost that I can mention, that you might not be aware of, is that it uses Oracle partitioning, if you use Oracle. There are Oracle partitioning fees that go with that."
  • More BMC TrueSight Operations Management Pricing and Cost Advice →

  • "The pricing is reasonable, it's comparable with the competitors."
  • "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."
  • More IDERA SQL Diagnostic Manager for SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Event Monitoring solutions are best for your needs.
    763,955 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The tool is flexible enough to be customized based on customer requirements.
    Top Answer:The product must provide more AI capabilities. AI is already available but must play a deeper role in the solution.
    Top Answer:The ability to go back and look at historical data is the most valuable feature.
    Top Answer: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… more »
    Top Answer:We use it mainly for monitoring, including CPU, memory, and disk space, and for troubleshooting purposes.
    Ranking
    1st
    out of 20 in Event Monitoring
    Views
    2,389
    Comparisons
    1,639
    Reviews
    14
    Average Words per Review
    408
    Rating
    7.7
    12th
    out of 20 in Event Monitoring
    Views
    207
    Comparisons
    138
    Reviews
    1
    Average Words per Review
    394
    Rating
    7.0
    Comparisons
    Also Known As
    ProactiveNet, TrueSight Operations Management
    IDERA SQL DM, IDERA SQL Diagnostic Manager
    Learn More
    Overview

    BMC TrueSight Operations Management is a solution that delivers end-to-end performance monitoring and event management. It does so by using machine learning, analytics, and AIOps to identify, analyze, and resolve application and infrastructure problems quickly. BMC TrueSight Operations Management also offers automated remediation and ticketing.

    BMC TrueSight Operations Management Features

    BMC TrueSight Operations Management has many valuable key features. Some of the most useful ones include:

    • TrueSight Smart Reporting
    • Broad monitoring capabilities
    • Hundreds of integrations
    • Event grouping
    • Proactive alerts
    • Incident tickets
    • Cause analysis
    • Automated log analysis

    BMC TrueSight Operations Management Benefits

    Some of the benefits of using BMC TrueSight Operations Management include:

    • Detects performance issues: BMC TrueSight Operations Management helps you detect and address performance abnormalities before they impact your organization.
    • Beneficial for IT teams: Since BMC TrueSight Operations Management automatically learns the behavior of your infrastructure, it is able to alert you when specific behaviors require attention, helping IT departments focus on other pressing priorities.
    • Cost efficient: BMC TrueSight Operations Management will save your company money by eliminating the need to manage thousands of traditional, static thresholds for event generation.
    • Reduces manual tasks: BMC TrueSight Operations Management minimizes the need to manually define, configure, and maintain correlation rules and policies.
    • Fewer false alarms: With BMC TrueSight Operations Management, the number of false alarms and associated incidents decreases drastically.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by BMC TrueSight Operations Management users.

    Mudassir A., Sr. Technical Consultant at a tech services company, says, "The event management part of TrueSight Operations Management, in my experience, is probably the best in the market. You have endless flexibility. You can build your own rules, you have the MRL language, and you can implement any kind of logic on the alerts. It may be correlation, abstraction, or executing something as a result of the alerts. You have almost the whole range of options available for event management using the available customization."

    A General Manager - Sales at a tech services company explains, “There are many features that are most valuable in BMC TrueSight Operations Management. First, its proactive monitoring feature is highly developed. BMC TrueSight Operations Management is an intelligent tool that's able to understand day-to-day operations and consistently gives alerts. The alerts are not automatic for some activities, e.g. some alerts are given monthly, while some are given more frequently. The consolidated dashboard where you can enjoy a single pane of glass to look at the full infrastructure from the servers to the VMs, to the clouds, to the application, to the database, to the network devices, including having a topology, and having a tendency map of the topology of key offerings, is also a valuable feature of this solution.”

    An Information Systems Computer System Controller at an insurance company states, “The business event manager tool that consolidates detailed information from a single instance of equipment is the most valuable thing for me. It provides support for the business tools and the IT services which come from several systems.”


    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.

    Sample Customers
    Ensono, Transamerica, Boston Scientific, Park Place Technologies, inContact, TD Ameritrade, PNC Bank
    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
    Top Industries
    REVIEWERS
    Financial Services Firm32%
    Comms Service Provider21%
    Healthcare Company11%
    Manufacturing Company11%
    VISITORS READING REVIEWS
    Financial Services Firm21%
    Computer Software Company13%
    Government9%
    Manufacturing Company6%
    VISITORS READING REVIEWS
    Financial Services Firm14%
    Government12%
    Computer Software Company11%
    Healthcare Company8%
    Company Size
    REVIEWERS
    Small Business40%
    Midsize Enterprise12%
    Large Enterprise48%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise9%
    Large Enterprise76%
    REVIEWERS
    Small Business25%
    Midsize Enterprise42%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise12%
    Large Enterprise66%
    Buyer's Guide
    Event Monitoring
    February 2024
    Find out what your peers are saying about BMC, ServiceNow, Microsoft and others in Event Monitoring. Updated: February 2024.
    763,955 professionals have used our research since 2012.

    BMC TrueSight Operations Management is ranked 1st in Event Monitoring with 16 reviews while IDERA SQL Diagnostic Manager for SQL Server is ranked 12th in Event Monitoring with 1 review. BMC TrueSight Operations Management is rated 8.2, while IDERA SQL Diagnostic Manager for SQL Server is rated 8.0. The top reviewer of BMC TrueSight Operations Management writes "It improves VM load and has good documentation with easy-to-follow steps on how to set it up, but it has room for improvement in terms of scalability and stability". On the other hand, the top reviewer of IDERA SQL Diagnostic Manager for SQL Server writes " Offers effective monitoring of resources but lacks the ability to connect to an AWS instance and write custom queries". BMC TrueSight Operations Management is most compared with BMC Helix Monitor, Dynatrace, ServiceNow IT Operations Management, New Relic and Zabbix, whereas IDERA SQL Diagnostic Manager for SQL Server is most compared with SolarWinds Database Performance Analyzer, Redgate SQL Toolbelt, Quest Spotlight, Quest Foglight for Databases and SQL Sentry.

    See our list of best Event Monitoring vendors.

    We monitor all Event Monitoring 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.