# 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:** 13 ## About SQL Diagnostic Manager IDERA SQL Diagnostic Manager is a powerful SQL Server performance monitoring and diagnostics solution built to help database administrators detect issues early, troubleshoot faster, and optimize performance across on-premises, hybrid, and cloud environments. Designed for organizations that need deep visibility into SQL Server health, availability, and query performance, SQL Diagnostic Manager gives teams a centralized view of their database environment so that they can identify bottlenecks, reduce downtime, and keep critical systems running smoothly. It supports SQL Server environments across on-premises infrastructure as well as cloud platforms, including Azure SQL Database and Amazon RDS for SQL Server. With real-time monitoring, intelligent alerting, customizable dashboards, and detailed diagnostic workflows, SQL Diagnostic Manager helps DBAs move from reactive firefighting to proactive performance management. Teams can analyze wait statistics, resource usage, blocking, query behavior, and historical trends to pinpoint the root cause of slowdowns faster and make more confident tuning decisions. Its monitoring and diagnostic depth helps database administrators understand what happened, why it happened, and what to do next. SQL Diagnostic Manager goes beyond monitoring to intelligent optimization. Built directly into Query Monitor, SQL Diagnostic Manager offers AI-powered query and workload index optimization to help DBAs turn slow or expensive queries into actionable index recommendations in minutes. Users can evaluate a single long-running query or analyze multiple related queries together, allowing the platform to recommend workload-aware indexing strategies that reduce guesswork, minimize tuning risk, and avoid redundant or conflicting changes. Whether your team is managing a handful of SQL Server instances or a large, complex estate, IDERA SQL Diagnostic Manager helps simplify monitoring, accelerate root-cause analysis, and improve database performance with greater speed and confidence. ## SQL Diagnostic Manager Pros & Cons **What users like:** - Users appreciate the **SQL query optimization insights** , enhancing performance by identifying deadlocks and resource-intensive queries. (2 reviews) - Users find the **installation process easy** for SQL Diagnostic Manager, facilitating a quick start to optimization tasks. (1 reviews) - Users value the **rapid issue resolution** in SQL Diagnostic Manager, allowing quick identification and prevention of incidents. (1 reviews) - Users value the **easy-to-handle reporting** interface of SQL Diagnostic Manager, enhancing their diagnostic experience. (1 reviews) **What users dislike:** - Users often experience **poor customer support** , facing delays and difficulties in resolving issues effectively. (2 reviews) - Users experience **delay issues** with SQL Diagnostic Manager that impact the efficiency of their database monitoring. (1 reviews) - Users find the **difficult setup** of SQL Diagnostic Manager frustrating, often leading to delays and challenging support access. (1 reviews) - Users find SQL Diagnostic Manager to be **expensive** , which can be a hurdle for smaller organizations and teams. (1 reviews) - Users often find the **inefficient alert system** frustrating, hindering effective performance monitoring and timely responses. (1 reviews) - Limited Customization (1 reviews) - Overcomplicated Interface (1 reviews) - Slow Performance (1 reviews) - Time-Consumption (1 reviews) ## SQL Diagnostic Manager Reviews ### 1. A good experience **Rating:** 5.0/5.0 stars **Reviewed by:** Aarón V. | Instrutor, Small-Business (50 or fewer emp.) **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 histori ### 2. Good tool for query optimisation **Rating:** 3.5/5.0 stars **Reviewed by:** Bhanu Datta A. | Software Engineer, Mid-Market (51-1000 emp.) **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 ### 3. Diagnosing SQL tasks **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **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 ### 4. 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.) **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. ### 5. Improving the overall efficiency of database administration **Rating:** 5.0/5.0 stars **Reviewed by:** Sai C. | BI specialist, Mid-Market (51-1000 emp.) **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 ### 6. Reliable source to run queries **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Airlines/Aviation | Enterprise (> 1000 emp.) **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 ### 7. Reliable tool for DBA **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Pharmaceuticals | Enterprise (> 1000 emp.) **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 ### 8. 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.) **Reviewed Date:** September 19, 2023 **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. ### 9. Review SQL Diagnostic Manager **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **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. ### 10. 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.) **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. ### 11. 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.) **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. ### 12. 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.) **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 ### 13. Best tool for DBA **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **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 then 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-05-24+08%3A34%3A37+-0500&secure%5Bsession_id%5D=379dc2f6-fadf-48b0-b9c2-827281548461&secure%5Btoken%5D=32afa62951afa67c2460f5c0df3109a9d1ca7115990133cb70065420c7f9bb3f&format=llm_user) ## SQL Diagnostic Manager Features **Functionality** - Monitoring - Alerting - Logging - Response Time - Reporting - Data Visualization **Agentic AI - Database Monitoring** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration - Adaptive Learning - Natural Language Interaction - Proactive Assistance - Decision Making ## Top SQL Diagnostic Manager Alternatives - [Datadog](https://www.g2.com/products/datadog/reviews) - 4.4/5.0 (694 reviews) - [Dynatrace](https://www.g2.com/products/dynatrace/reviews) - 4.5/5.0 (1,231 reviews) - [SolarWinds Database Observability](https://www.g2.com/products/database-observability/reviews) - 4.5/5.0 (220 reviews)