SQL Diagnostic Manager provides the following new features and fixed issues.

13.1 New Features

SQL Diagnostic Manager presents the following features and enhancements:

  • Improves security by providing Multi-Factor Authentication (MFA) and Single Sign On (SSO) support for Windows Client and Browser interfaces through OIDC authentication. Both Okta and Entra ID were specifically tested and documented for this release, however, any other OIDC service should also work equally well with SQL DM. For more information about OIDC usage, see OpenID Connect authentication.
  • Includes new custom counters for CloudWatch for Amazon RDS instances. Simply select the CloudWatch counter in the Add Custom Counter dialog. For more information about this feature, see Select AWS RDS System Counter.
  • SQL Diagnostic Manager provides Experimental Support only for Windows Server 2025 and SQL Server 2025. Experimental Support means that this platform is not fully tested and has limited support.
  • Improves secure internal product communications between agents, console, and repository.

13.1 Fixed Issues

Alerts

SQLDM-32912 SQL Diagnostic Manager no generates duplicate alerts for SQL Agent Deadlocks.

SQLDM-32844 The Configure Alerts window now includes all available alert recommendations.

SQLDM-32641 Resolves an issue causing the server list to not populate when attempting to apply an alert template, configuring alerts, or managing custom counters.

SQLDM-32570 SQL DM now generates an Unable to Connect alert without issue.

SQLDM-32467 Card and Details views now display the correct number of active alerts per instance.

SQLDM-32402 Updates the message for the Configuring Alert Templates window to more clearly state that changes to alert templates do not affect monitored server settings until the template is applied. That functionality ensures that all alert settings, not only those modified, are applied to the server.

Alerts Response

SQLDM-32844 and SQLDM-32783 Resolve issues with the Where metric severity is unchanged for a specific period of time option. One issue is that when selected, it results in the selection of both that option and Where metric severity has changed after saving the initial selection. The second issue is that some users received email notifications of issues based on a set number of seconds rather than minutes, i.e. a notification setting of 30 minutes resulted in the system sending notifications every 30 seconds instead.

SQLDM-32759 The email notification for the Blocking / Deadlock Alert now includes:

    • the session ID causing the block or deadlock
    • information about the SQL Server with Session ID of blocking other sessions
    • the blocking session (SPID)
    • blocking or deadlock query information including the SQL statements and session details incolved
    • blocking duration 

Analysis

SQLDM-32667 Resolves an issue preventing some users from manually running a SQL DM analysis. 

Custom Counters

SQLDM-30385 Custom counters in templates now are properly applied for new servers.

DM Console

SQLDM-32970 The Console Dashboard Charts (Memory Areas, Buffer Caches, and others) now show only one value for the Y axis.

SQLDM-32836 Resolves an issue causing some users to experience a Console failure when marking all analysis results for export.

General

SQLDM-32883 Resolves an issue causing an error when some users attempted to view the Server Summary after upgrading to SQL DM 13.0.0.

SQLDM-32873 Users now can successfully add a new SQL Server in IDERA Monitoring without receiving an unnecessary error preventing a successful server addition.

SQLDM-32855 The UI now displays an Edit option for the AWS Access Key, AWS Secret Key, and AWS Region in the Properties window.

SQLDM-32819 Resolves an issue preventing users from adding a deleted user account back to the Application Security page.

SQLDM-32789 Adds a new Last Job Start Time column when displaying job lists.

SQLDM-32787 Users no longer receive an error message when attempting to stop the SQL DM Management Service.

SQLDM-32753 Resolves an issue causing a "System.ArgumentException: An item with the same key has already been added" error in the Collection Service logs and preventing collection and processing of data.

SQLDM-32732 Optimized code to improve Collection Service performance in an OLTP environment.

SQLDM-32728 Resolves an issue causing the VM Configuration window to not populate associated fields when the user clicks Link Instances to VMs.

SQLDM-32727 Resolves an issue causing the card view to display No Alerts for all servers on the Dashboard.

SQLDM-32703 Adds Encrypt Connection and Trust Server Certificate checkboxes when configuring authentication for users to connect to the repository using those features.

SQLDM-32406 Resolves an issue preventing some MIBs from properly compiling.

SQLDM-32386 Adds options in the Servers view to Enable, Disable, and Schedule server Maintenance Mode by right-clicking the server and following the menu items.

SQLDM-32383 Resolves an issue causing a SQL Server Browser Service Unable to Monitor alert after switching to OLE Automation.

SQLDM-30783 The Text Size (MB) for tables no longer displays 0.0 when a non-zero value exists.

Graphs

SQLDM-31550 Resolves issues with some graphs when rendering Azure SQLDB data.

Install/Upgrade

SQLDM-32899 The SQL DM Management Service no longer fails after upgrading to version 13.0.2.

SQLDM-32879 SQL DM now correctly displays historical snapshots saved before upgrading to SQL DM 13.0.0.

SQLDM-32872 Resolves an issue preventing some users from successfully installing or upgrading the remote SQL DM Desktop Clients using SQL DM 13.0.1.69 Maintenance Pack.

SQLDM-32804 SQL Diagnostic Manager installs a currently-supported version of Microsoft ASP .NET Core.

SQLDM-32160 SQL DM installations/upgrades now accept double quotation marks (") and spaces as special characters in passwords.

Metrics

SQLDM-32914 Resolves an issue with the SQL Server Memory Usage (Percent) metric triggering alerts when still in acceptable range after upgrading from SQL DM 12.3.4 to 13.0.2.33. 

SQLDM-32789 Resolved an issue causing the Unsubscribed Transaction Time metric to provide incorrect data.

Queries

SQLDM-32556 Resolves an issue causing Signature/Standard graphical views to display data even when Query Monitor is disabled.

Reports

SQLDM-32835 Users no longer receive a "Cast exception" error when attempting to open an Analysis report from the Analyze tab.

SQLDM-32811 The scheduled SSRS AG Topology report email no contains all relevant data.

SQLDM-32522 SQL DM now offers the Server Database Availability report that offers the up time, down time, and availability percentage of a server's databases.

SQLDM-32164 Resolves an issue causing both the Database Full Percent and Filegroup Space Full Percent metrics to falsely report zero space availability.

IDERA Web Console

SQLDM-32895 The IDERA Web Console's Alerts view no longer displays the alert's datetime as UTC values rather than local time.

SQLDM-32828 The IDERA Web Console now retains all user-performed actions rather than reverting to default after an automatic refresh.

SQLDM-32826 Resolves an issue preventing users from checking/unchecking selected charts in the Add Chart and Add Dashboard sections of the Manage Charts dialog box.

SQLDM-32809 The IDERA Web Console auto-refresh feature now simply refreshes the data in each graph rather than reloading the entire page.

SQLDM-32807 The IDERA Web Console remains in history mode after an auto-refresh if the user is in that mode when the refresh occurs.

SQLDM-32073 Improves server status response time of the IDERA Web Console.

UI

SQLDM-32694 Fixes the alignment for the Alert Filter Exclude text box. 

SQLDM-32676 Resolves a sizing issue with the Advanced Alert Configuration window.

SQLDM-32647 Resolves a sizing issue with the x-axis of the some usage charts. 

SQLDM-32316 Resolves a sizing issue with the Advanced Options window.