• Home
  • IDERA SQL Diagnostic Manager for SQL Server vs. Precisely Optimize DB2

IDERA SQL Diagnostic Manager for SQL Server vs Precisely Optimize DB2 comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Download the complete report
Buyer's Guide
Database Development and Management
April 2024
Executive Summary

We performed a comparison between IDERA SQL Diagnostic Manager for SQL Server and Precisely Optimize DB2 based on real PeerSpot user reviews.

Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management.
To learn more, read our detailed Database Development and Management Report (Updated: April 2024).
Download the complete report
768,578 professionals have used our research since 2012.
Featured Review
Anonymous User
Offers effective monitoring of resources but lacks the ability to connect to an AWS instance and write custom queries.
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... Read more →
Use Precisely Optimize DB2?
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
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 →

    Information Not Available
    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
    768,578 professionals have used our research since 2012.
    Questions from the Community
    What do you like most about IDERA SQL Diagnostic Manager for SQL Server?
    Top Answer:The ability to go back and look at historical data is the most valuable feature.
    Read all 2 answers   →
    What needs improvement with IDERA SQL Diagnostic Manager for SQL Server?
    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 »
    Read all 2 answers   →
    What is your primary use case for IDERA SQL Diagnostic Manager for SQL Se...
    Top Answer:We use it mainly for monitoring, including CPU, memory, and disk space, and for troubleshooting purposes.
    Read all 2 answers   →
    Ask a question

    Earn 20 points

    Ranking
    11th
    out of 62 in Database Development and Management
    Views
    978
    Comparisons
    650
    Reviews
    1
    Average Words per Review
    394
    Rating
    7.0
    27th
    out of 62 in Database Development and Management
    Views
    256
    Comparisons
    227
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    Comparisons
    Also Known As
    IDERA SQL DM, IDERA SQL Diagnostic Manager
    Precisely Syncsort Optimize DB2, Syncsort Elevate DB2
    Learn More
    IDERA
    Precisely
    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.

    Elevate DB2 is the leading solution for Db2 SQL workload performance analysis and optimization on z/OS, identifying and helping DBAs save Db2 resources, improve performance, and dramatically reduce the impact of application and environmental changes.

    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
    British Telecom
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm13%
    Government12%
    Computer Software Company11%
    Healthcare Company7%
    No Data Available
    Company Size
    REVIEWERS
    Small Business25%
    Midsize Enterprise42%
    Large Enterprise33%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise12%
    Large Enterprise68%
    No Data Available
    Buyer's Guide
    Database Development and Management
    April 2024
    Download Free Report
    Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management. Updated: April 2024.
    DOWNLOAD NOW
    768,578 professionals have used our research since 2012.

    IDERA SQL Diagnostic Manager for SQL Server is ranked 11th in Database Development and Management with 9 reviews while Precisely Optimize DB2 is ranked 27th in Database Development and Management. IDERA SQL Diagnostic Manager for SQL Server is rated 8.0, while Precisely Optimize DB2 is rated 0.0. The top reviewer of IDERA SQL Diagnostic Manager for SQL Server writes "Proactively alerts us on a wide variety of issues, but it has not scaled out well with our large environment". On the other hand, IDERA SQL Diagnostic Manager for SQL Server is most compared with SolarWinds Database Performance Analyzer, Quest Spotlight, Redgate SQL Toolbelt, Quest Foglight for Databases and SQL Sentry, whereas Precisely Optimize DB2 is most compared with DBmaestro Database Source Control.

    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.