--- title: SQL Diagnostic Manager Reviews meta_title: 'SQL Diagnostic Manager Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 14 reviews by the users' company size, role or industry to find out how SQL Diagnostic Manager works for a business like yours. aggregate_rating: rating_value: 4.1 review_count: 14 scale: '5' date_modified: '2026-09-28' parent_category: name: Monitoring url: https://www.g2.com/categories/monitoring --- # SQL Diagnostic Manager Reviews **Vendor:** Idera, Inc. **Category:** [Database Monitoring Tools](https://www.g2.com/categories/database-monitoring) **Average Rating:** 4.1/5.0 **Total Reviews:** 14 **AI Enabled:** This product embeds AI to enhance or extend its core functionality. ## About SQL Diagnostic Manager IDERA SQL Diagnostic Manager (SQL DM) is a leading SQL Server performance monitoring, diagnostics, and optimization platform for database administrators managing on-premises, cloud, and hybrid environments. Now in version 14, SQL Diagnostic Manager delivers enterprise-grade visibility into SQL Server health, availability, query performance, and resource utilization — with built-in AI-powered query and workload index optimization introduced in the latest release. SQL Diagnostic Manager monitors every critical layer of the SQL Server stack — from query execution plans, wait statistics, blocking chains, deadlocks, and TempDB pressure to OS resources, virtualization, storage, and cloud-level cost metrics. Its agentless, low-overhead architecture collects full diagnostic data without impacting production performance. With AI built directly into Query Monitor, DBAs can turn slow or expensive queries into actionable index recommendations in minutes — for a single query or an entire competing workload. The AI is DBA-controlled: all recommendations require explicit review and approval before any change is applied. No table data is ever sent to AI services. SQL Diagnostic Manager supports SQL Server on-premises, Azure SQL Database, Azure SQL Managed Instance, Amazon RDS for SQL Server, and Google Cloud SQL. Its customer-owned data repository enables multi-year forensic analysis with no ingest fees and predictable per-instance pricing. Trusted by 50,000+ database professionals, SQL Diagnostic Manager is used at enterprises including Franciscan Health, the University of Notre Dame, and the National Organization for Research. Key capabilities: real-time monitoring and alerting, AI-powered query and workload optimization, prescriptive tuning recommendations, deadlock and blocking chain analysis, TempDB and I/O diagnostics, replication monitoring, Query Store integration, adaptive baseline alerting, cost observability for cloud environments, customizable dashboards and reports, and a 14-day free trial with no credit card required. ## SQL Diagnostic Manager Pros & Cons Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews. **What users like:** - Users commend the **SQL query optimization insights** provided by SQL Diagnostic Manager, enhancing performance and reducing deadlocks. (2 reviews) - Users find the **easy installation** of SQL Diagnostic Manager quite beneficial for optimizing SQL queries efficiently. (1 reviews) - Users value the **quick issue resolution** capabilities of SQL Diagnostic Manager, which enhances incident management and prevention. (1 reviews) - Users value the **effective diagnosing and reporting** capabilities of SQL Diagnostic Manager for streamlined troubleshooting. (1 reviews) **What users dislike:** - Users frequently experience **poor customer support** , facing delays and difficulties in resolving issues effectively. (2 reviews) - Users report **delay issues** with SQL Diagnostic Manager, which can hinder prompt database performance monitoring. (1 reviews) - Users find the **difficult setup** of SQL Diagnostic Manager time-consuming and support hard to reach during issues. (1 reviews) - Users find SQL Diagnostic Manager to be **expensive** , which can be a barrier for smaller organizations or teams. (1 reviews) - Users find the **inefficient alert system** challenging, as it lacks customization and can be overwhelming for effective use. (1 reviews) - Limited Customization (1 reviews) - Overcomplicated Interface (1 reviews) - Slow Performance (1 reviews) - Time-Consumption (1 reviews) ## SQL Diagnostic Manager Reviews ### 1. Instant Alerts That Keep Issues Under Control **Rating:** 5.0/5.0 stars **Reviewed by:** Clifton D. | Senior Production Database Administrator, Computer Software, Enterprise (> 1000 emp.) **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Source: G2 invite:** Invitation from G2. This reviewer was not provided any incentive by G2 for completing this review. **Reviewed Date:** July 21, 2026 **What do you like best about SQL Diagnostic Manager?** I love how it will let me know when there is an alert to fix! **What do you dislike about SQL Diagnostic Manager?** I wish the web interface has the same information as the thick client. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** It helps me identify slow queries and then optimize them to speed things up. ### 2. A good experience **Rating:** 5.0/5.0 stars **Reviewed by:** Aarón V. | Instrutor, Small-Business (50 or fewer emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 22, 2024 **What do you like best about SQL Diagnostic Manager?** My experience has been very pleasant, I am satisfied in its entirety and the various functions **What do you dislike about SQL Diagnostic Manager?** Complexity: The interface can be overwhelming for new users, requiring a learning curve to navigate effectively.

Performance Overhead: Some users report that it can introduce performance overhead, especially in heavily loaded environments.

Cost: It can be expensive, particularly for smaller organizations or teams.

Customization Limitations: While it offers a lot of features, some users feel there are limitations in terms of customizing alerts or reports to meet specific needs.

Support: Experiences with customer support can vary, and some users have reported delays or issues with resolution. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** Performance Monitoring: It provides real-time monitoring of SQL Server performance metrics, helping identify bottlenecks and optimize performance.

Alerting and Notifications: Users receive alerts for critical issues, enabling proactive management and minimizing downtime.

Historical Analysis: The tool tracks historical data, allowing for trend analysis and long-term planning. ### 3. Good tool for query optimisation **Rating:** 3.5/5.0 stars **Reviewed by:** Bhanu Datta A. | Software Engineer, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 15, 2024 **What do you like best about SQL Diagnostic Manager?** It has good explanation and details for SQL query optimisation. It is also easy to install **What do you dislike about SQL Diagnostic Manager?** Though installation is easy the setup takes time and there were issues during the setup and support was hard to contact **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** It gives explanation for SQL query optimisation and it helps in improving performance of application by optimising queries ### 4. Diagnosing SQL tasks **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Source: Thank You page:** Invitation from G2. This reviewer was not provided any incentive by G2 for completing this review. **Reviewed Date:** February 17, 2025 **What do you like best about SQL Diagnostic Manager?** Easy to handle interface. good diagnosing and reporting **What do you dislike about SQL Diagnostic Manager?** Nothing. It is a good diagnosis tool that helps a lot in diagnosing **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** It helps in diagnosing and monitoring sql server issues ### 5. Good and bad about the Sql diagnostic manager **Rating:** 3.0/5.0 stars **Reviewed by:** Varun B. | Data analyst, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 23, 2024 **What do you like best about SQL Diagnostic Manager?** Its ability to find out the queries creating deadlocks and queries that are talking too much time and space to run. **What do you dislike about SQL Diagnostic Manager?** Some of the basic indexing and ways to reduce the run time needs to be figured out by the user himself. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** To flag the slow running queries. ### 6. Improving the overall efficiency of database administration **Rating:** 5.0/5.0 stars **Reviewed by:** Sai C. | BI specialist, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 27, 2024 **What do you like best about SQL Diagnostic Manager?** With SQL Diagnostic Manager, incidents can be quickly identified, fixed, and prevented. **What do you dislike about SQL Diagnostic Manager?** Not major ones. Concentrating more on the timing issues **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** Performances ease to use ### 7. Reliable source to run queries **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thanks for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thanks for completing this review. **Reviewed Date:** October 11, 2024 **What do you like best about SQL Diagnostic Manager?** I like the query optimisation and detailed explanation **What do you dislike about SQL Diagnostic Manager?** There is nothing I disliked so far thank you **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** Helping with the data extraction ### 8. Reliable tool for DBA **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Pharmaceuticals | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through a business email account **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** October 10, 2024 **What do you like best about SQL Diagnostic Manager?** query optimization, detailed descriptions of the query. **What do you dislike about SQL Diagnostic Manager?** I haven't found anything to dislike so far. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** Query optimization ### 9. IDERA SQL diagnostic manager a very reliable SQL insight tool for DBA **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Automotive | Enterprise (> 1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Current User:** The reviewer uploaded a screenshot or submitted the review in-app verifying them as current user. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** September 19, 2023 At G2, we prefer fresh reviews and we like to follow up with reviewers. They may not have updated their review text, but have updated their review. **What do you like best about SQL Diagnostic Manager?** The best diagnostics tools for the servers. easy to install and configure, low costing, and its query optimizing feature is fantastic. **What do you dislike about SQL Diagnostic Manager?** In my opinion, I didn't find anything annoying so far. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** I am using this tool to monitor queries and manage performance. through this tool, one can quickly find out queries which causes slowing down the process and via this tool we can optimize the query. ### 10. Review SQL Diagnostic Manager **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** April 14, 2020 **What do you like best about SQL Diagnostic Manager?** The SQL Diagnostic Manager is the best apparatus for following the occasions which are going on the SQL server. With the assistance of this, we can without much of a stretch recognize issues in our database level. The highlights which are given by SQL Diagnostic Manager, for example, catch logs, query optimization, alerts, and so forth. **What do you dislike about SQL Diagnostic Manager?** The initial setup takes too much time. There are lots of configurations we have to do for setting up the database. The tool should have a pre-configured template, which can easily use by naive users as well. SQL Diagnostic Manager configuration part needs improvement. The tool overall perfect and very user friendly. **Recommendations to others considering SQL Diagnostic Manager:** Best tool for query optimization. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** Resolved query performance-related issues. ### 11. Diagnostic manager is intuitive, user friendly tool that helped us to get handle on blocking issues **Rating:** 4.0/5.0 stars **Reviewed by:** Veronika K. | Broker, Real Estate, Mid-Market (51-1000 emp.) **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** May 24, 2019 **What do you like best about SQL Diagnostic Manager?** User friendly interface, ability to create custom reports that can be presented to IT management, ability to set up lifetime Alerts and ability to analyse queries on a fly. **What do you dislike about SQL Diagnostic Manager?** Limited abilities when it comes to creating custom reports. I would be happy to see more more flexibility/ease of use. **Recommendations to others considering SQL Diagnostic Manager:** SQLDM is useful when you need to monitor SQL server health, set up custom alerts and reports, drill down into issues quickly. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** We had implemented SQL based Warehouse Management system that unfortunately proven to have a problem with data contention and produced a lot of blocking and deadlocking in a database. Idera SQL DM was very helpful as we were able to set up easily readable, graphic, detailed alerts every time when blocking occurred and had it e-mailed to business analysts who could quickly help to resolve the issue at hand. Also, we were able to produce weekly reports that helped us identify what areas of application needed improvement and report it to a vendor. ### 12. My SQL Diagnostic Manager review **Rating:** 2.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through a business email account **Source: Seller invite:** Invitation from a seller or affiliate. This reviewer was not provided any incentive by G2 for completing this review. **Reviewed Date:** April 22, 2019 **What do you like best about SQL Diagnostic Manager?** What I like most about SQL Diagnostic Manager is that I can check the performance of my query in real time. **What do you dislike about SQL Diagnostic Manager?** It is a very expensive tool for the features it has. **Recommendations to others considering SQL Diagnostic Manager:** I recommend it even being expensive, because it makes it much easier to analyze the queries. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** I solved a series of queries that needed a lot of time to execute and I was able to analyze and verify where the problem was. ### 13. Easy and efficient tool for DBA **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** July 06, 2019 **What do you like best about SQL Diagnostic Manager?** Helps to monitor performance, alert and diagnose solutions easily and it keeps track of all events happening on sql server **What do you dislike about SQL Diagnostic Manager?** Takes time to load up. Less configurable **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** Monitoring the production system, diagnosing issues before customer reports ### 14. Best tool for DBA **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) This reviewer's identity has been verified by our review moderation team. They have asked not to show their name, job title, or picture. **Validated Reviewer:** Validated through LinkedIn **Incentivized:** This reviewer was offered a nominal gift card as thank you for completing this review. **Source: G2 invite:** Invitation from G2. This reviewer was offered a nominal gift card as thank you for completing this review. **Reviewed Date:** May 16, 2019 **What do you like best about SQL Diagnostic Manager?** Very useful to keep track of all the events happening on SQL Server. It helps to detect the problem. Good for monitoring. **What do you dislike about SQL Diagnostic Manager?** Takes them to load up. Sometimes it's time out and says no data to show. Not so smooth if you are new to this. Not user friendly. **What problems is SQL Diagnostic Manager solving and how is that benefiting you?** Keeping track and monitoring problems on production and report them before anyone. - [View SQL Diagnostic Manager pricing details and edition comparison](https://www.g2.com/products/sql-diagnostic-manager/reviews?section=pricing&secure%5Bexpires_at%5D=2026-09-30+11%3A45%3A27+-0500&secure%5Bsession_id%5D=31d247cf-afef-410f-84e3-22533c58b540&secure%5Btoken%5D=56f8bf427fafcfc0ddfaae65958edbca1f95e346fc7e4fa0e7f7407dd328e18d&format=llm_user) ## SQL Diagnostic Manager Features **Functionality** - Monitoring - Alerting - Logging - Response Time - Reporting - Data Visualization - Performance Monitoring - Real-Time Monitoring - Server Monitoring - Real-Time Reporting - Uptime Reporting - Transaction Monitoring - Real-Time Data **Agentic AI - Database Monitoring** - Multi-step Planning - Adaptive Learning - Proactive Assistance - Third-Party Integrations - Capacity Planning **Additional Functionality** - Resource Management - Anomaly Detection - Visual Analytics - Remote Monitoring & Management - Secure Data Storage - Dashboard - Generative AI - Configuration Management - API - User Management - Capacity Management - Diagnostic Tools - Dependency Tracking - Troubleshooting - Reporting & Statistics - Reporting/Analytics - Predictive Analytics - Audit Management - Real-Time Notifications - Application Management - Data Storage Management - Application-Level Analysis - Multitenancy - Query Analysis - Performance Management - Access Controls/Permissions - Compliance Management - Historical Trend Analysis - Alerts/Notifications - Summary Reports - AI Copilot - Event Logs - Dashboard Creation - Automated Discovery - Prioritization - Issue Tracking - Activity Dashboard - Performance Metrics - Resource Optimization - Real-Time Analytics - Status Tracking ## Top SQL Diagnostic Manager Alternatives - [Datadog](https://www.g2.com/products/datadog/reviews) - 4.4/5.0 (715 reviews) - [Dynatrace](https://www.g2.com/products/dynatrace/reviews) - 4.5/5.0 (1,238 reviews) - [SolarWinds Database Observability](https://www.g2.com/products/database-observability/reviews) - 4.5/5.0 (224 reviews)