SQL Diagnostic Manager 14.3: A Modernized Experience for SQL Server Performance Monitoring
Announcing the General Availability of SQL Diagnostic Manager 14.3 We’re excited to announce the general availability of SQL Diagnostic Manager 14.3, one of the most...
Announcing the General Availability of SQL Diagnostic Manager 14.3
We’re excited to announce the general availability of SQL Diagnostic Manager 14.3, one of the most significant releases in the product’s history.
For years, DBAs have relied on SQL Diagnostic Manager for one reason above all: it tells you what is actually happening inside SQL Server. Waits broken down by database, user, application, and query. Deadlocks captured automatically with the evidence already waiting. Blocking chains as they form. Growth forecasts built from your own history. All of it agentless, across on-prem, hybrid, and cloud, in a repository you own.
For our last release, we brought AI-powered query and workload index optimization directly into that workflow.
With 14.3, we’ve turned our attention to the experience itself: modernizing the console, the reports, and the web, so that all of that depth is faster to reach, easier to read, and simpler to act on.
Same platform. Same answers. A much faster path to them.
“DBAs have trusted SQL Diagnostic Manager for more than two decades because it tells them exactly what’s happening inside SQL Server. SQL DM 14.3 is a release about respect for the DBA’s time. Fewer clicks, clearer answers, faster resolution,” said Max Hunsicker, General Manager at Idera.
What Is SQL Diagnostic Manager 14.3?
SQL Diagnostic Manager is Idera’s SQL Server performance monitoring and diagnostics platform; a single place to monitor performance, pinpoint root cause, and act on it, across every environment where you run SQL Server.
Version 14.3 is a broad release. It modernizes the highest-use areas of the Windows Console, refreshes the entire reporting experience, adds five new enterprise-level reports, brings real-time instance monitoring to the Web Console, substantially expands database-level visibility, and reduces the setup and administrative overhead of running SQL DM at scale.
Here’s what that means in practice.
What’s New in SQL Diagnostic Manager 14.3
A Modernized Console, on Familiar Ground
The single largest piece of this release is a modernization of the Windows Console, and it is not limited to a few dashboard screens.
The refresh spans server and fleet management, Server Overview, sessions and blocking, query performance, server resources, database monitoring, services and logs, and the configuration dialogs that support all of it. Reporting has been refreshed alongside them.
Query Monitor received particular attention. Key performance information is consolidated and easier to scan, so identifying a problem query takes less searching and less manual correlation across screens. In previews, this was the area DBAs reacted to most; not because it looks different, but because it takes fewer steps to reach a conclusion.
The updated dark theme is cleaner and gray-based, and holds up far better through a long shift in a dimly lit operations room.
One thing worth stating plainly: this is a modernization, not a re-platform. Every capability you rely on is still where you expect to find it. If you have been using SQL DM for a decade, you will not need to relearn it, you’ll just spend less time hunting.
Areas included in the modernization:
Server & fleet management: All Servers views, server groups and tags, heat map, server details, fleet navigation
Server Overview Dashboard: Details, Configuration, Active Alerts, Timeline
Configuration: server onboarding, alert configuration, baselines, Query Monitor configuration, maintenance mode, query plans, deadlock investigation, AI features, tags
Reporting: navigation and catalogs, Monitor/Analyze/Plan reports, parameters, drill-through views
Query Monitor Screen: Dark Mode
Five New Enterprise Reports
Most reporting in performance monitoring answers questions about a server. But the questions that come from leadership are rarely about one server. Where is our worst blocking? Which databases are growing fastest? Are we running out of headroom anywhere?
Answering those has historically meant opening instances one at a time and assembling the picture yourself. SQL DM 14.3 adds five enterprise-level reports that answer them across a selected group of monitored servers at once:
Enterprise Top Queries: identifies the highest-impact queries across your monitored SQL Servers
Enterprise Blocking: enterprise-wide visibility into blocking activity, including blocking duration, blocked sessions, and top blocking queries
Enterprise Query Wait Statistics: summarizes query wait activity across servers to show where queries are spending the most time waiting
Enterprise Top Databases: ranks databases across the environment by size, growth, reads, writes, and transaction activity
Enterprise Server Resources: an enterprise view of CPU, disk, and memory utilization, with periods of peak resource activity identified
Alongside them, the full reporting experience has been refreshed; navigation, catalogs, the Monitor/Analyze/Plan report set, parameters, and drill-through views, all for a cleaner and more consistent look across every report you run. Which matters more than it sounds, because these are the artifacts that leave your team and land in front of other people.
Enterprise Top Queries Report
Real-Time Instance Monitoring in the Web Console
The Web Console has become a real part of how customers work; quick access without a Remote Desktop session, a way to check a server from macOS, a link you can send to a colleague instead of a screenshot.
In 14.3, it gains real-time instance monitoring. You can now watch activity on an individual SQL Server as it happens, without waiting for the next collection cycle; bringing one of the most valuable Windows Console capabilities to the browser.
Real-Time Monitoring on the Web Console
Deeper Database Visibility
Database-level investigation has been substantially expanded. Select a database and move through a connected set of views built for actual troubleshooting rather than a summary glance:
Summary: capacity usage and recent trends, with multi-view charts and an at-a-glance summary table
Files: a new Data Explorer covering data files, file groups, transaction logs, and disks
Backup & Restore: full backup and restore history, with filtering
Tables & Indexes: filterable table and index browsing, plus a details panel covering size, indexes, index statistics, and dependencies
Configuration: database-level configuration in a single view
Every tab carries a database selector and refresh control, so you can move between databases without losing your place; a small thing that adds up quickly when you’re comparing four databases at 2 a.m.
Database Statistics Report
Less Setup. Less Noise. Less Administrative Overhead.
The rest of 14.3 is aimed squarely at the friction of running SQL DM across a large estate.
Configuration templates. Save a server’s monitoring configuration as a reusable template and apply it to other servers. If you’ve ever onboarded twenty instances and configured each one by hand, this is the feature you’ll notice first.
Smarter default alert thresholds. Newly monitored servers now start with defaults tuned so that a perfectly healthy environment doesn’t immediately present as critical. You also get greater control over disabling Alert Recommendations. Alerts you can trust from day one, not day thirty.
A modernized installer. A cleaner, more intuitive installation experience from the first screen.
SQLdmRepository on Amazon RDS Custom. You can now deploy the SQL DM repository to an Amazon RDS Custom for SQL Server instance, one of the most-requested items from customers running repository infrastructure in AWS.
Why This Matters for DBAs
Performance monitoring tools tend to be judged on two axes: how much they can tell you, and how quickly you can get to it. Historically, most products are strong on one and weak on the other.
SQL Diagnostic Manager has always been unusually strong on the first. Dimensional wait statistics, automatic deadlock capture, cross-tier visibility from query down to storage and hypervisor, years of forensic history in a repository you own; that depth is genuinely hard to replicate, and it’s why DBAs continue to choose SQL Diagnostic Manager.
14.3 is our investment in the second axis. Fewer screens between a symptom and its cause. Estate-wide questions answered in one report. Live data in the browser when you’re away from your workstation. Templates instead of repetitive setup.
“DBAs don’t only work from their desks anymore, and not every problem waits until they’re back at one. SQL DM 14.3 brings real-time monitoring to the browser, so the visibility DBAs rely on is there wherever they are,” said Hunsicker.
The result is a product that still tells you more than anything else on the market, and now takes less of your attention to use.
Try SQL Diagnostic Manager 14.3 Free
See the modernized experience in your own environment.
Free 14-day trial, full featured; No credit card required
Agentless — monitoring live instances in about five minutes