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.
Average Rating: 4.1/5.0
Total Reviews: 14
How Do G2 Users Rate SQL Diagnostic Manager?
- Monitoring: 8.9/10 (Category avg: 9.0/10)
- Has the product been a good partner in doing business?: 7.7/10 (Category avg: 9.0/10)
- Reporting: 8.3/10 (Category avg: 8.7/10)
- Logging: 8.6/10 (Category avg: 8.6/10)
Who Is the Company Behind SQL Diagnostic Manager?
- Seller: Idera, Inc.
- Year Founded: 2007
- HQ Location: Austin, US
-
Twitter: @MigrationWiz
482 Twitter followers -
LinkedIn® Page: www.linkedin.com
285 employees on LinkedIn®
Who Uses This Product?
- Company Size: 57% Medium, 29% Large
What Do G2 Reviewers Say About SQL Diagnostic Manager?
AI-generated summary from verified user reviews
Pros
- Users commend the SQL query optimization insights provided by SQL Diagnostic Manager, enhancing performance and reducing deadlocks.
- Users find the easy installation of SQL Diagnostic Manager quite beneficial for optimizing SQL queries efficiently.
- Users value the quick issue resolution capabilities of SQL Diagnostic Manager, which enhances incident management and prevention.
- Users value the effective diagnosing and reporting capabilities of SQL Diagnostic Manager for streamlined troubleshooting.
Cons
- Users frequently experience poor customer support, facing delays and difficulties in resolving issues effectively.
- Users report delay issues with SQL Diagnostic Manager, which can hinder prompt database performance monitoring.
- Users find the difficult setup of SQL Diagnostic Manager time-consuming and support hard to reach during issues.
- Users find SQL Diagnostic Manager to be expensive, which can be a barrier for smaller organizations or teams.
- Users find the inefficient alert system challenging, as it lacks customization and can be overwhelming for effective use.
What Are Recent G2 Reviews of SQL Diagnostic Manager?
"Instant Alerts That Keep Issues Under Control"
Rating: 5.0/5.0 stars
— Clifton D.
Rating: 5.0/5.0 stars
— Aarón V.

