Idera launches SQL Diagnostic Manager 14.0 with AI index recommendations

Idera, Inc. released Structured Query Language (SQL) Diagnostic Manager 14.0 for SQL Server, adding an AI-powered workflow that connects query and workload monitoring to index and query recommendations. The update targets the gap between identifying performance issues and taking tuning actions inside the Query Monitor process.

The company said SQL Diagnostic Manager 14.0 is built to monitor, diagnose, and tune SQL Server performance across on-premises (on-prem), hybrid, and cloud environments using deep analytics and broad observability. Idera also described the product as using minimal overhead and an agentless architecture designed for full data collection.

SQL Diagnostic Manager 14.0 includes query-level observability such as plan history, Query Store integration, and execution comparison. It also includes root-cause insight into waits, blocking chains, deadlocks, TempDB pressure, I/O latency, and fragmentation, plus cross-tier visibility from SQL Server to Operating System (OS), virtualization, storage, and cloud resources.

For the new AI-powered index optimization, Idera said DBAs can submit problematic queries, including table structure and index schema context, to its Artificial Intelligence (AI) engine. Recommendations can cover a single high-impact query or competing queries that must perform well together, with workload-aware index design guidance intended to improve read performance while considering write overhead and index sprawl, and no suggestions are automatically applied; DBAs choose what to implement via copy/paste. “SQL Diagnostic Manager 14.0 is a clear signal of where we're headed—bringing practical AI into the hands of DBAs in a way that's safe, controlled, and immediately useful,” said Max Hunsicker, General Manager at Idera. “This release reflects Idera's commitment to staying on the leading edge of technology while continuing to deliver the SQL Server solutions our global customers rely on every day.” Idera said SQL Diagnostic Manager 14.0 was available today.