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

SQL Diagnostic Manager no generates duplicate alerts for SQL Agent Deadlocks.

The Configure Alerts window now includes all available alert recommendations.

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

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

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

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

and 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.

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

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

Custom Counters

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

DM Console

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

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

General

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

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

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

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

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

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

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.

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

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

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

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

Resolves an issue preventing some MIBs from properly compiling.

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

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

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

Graphs

Resolves issues with some graphs when rendering Azure SQLDB data.

Install/Upgrade

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

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

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.

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

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

Metrics

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. 

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

Queries

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

Reports

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

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

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

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

IDERA Web Console

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

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

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

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

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

Improves server status response time of the IDERA Web Console.

UI

Fixes the alignment for the Alert Filter Exclude text box. 

Resolves a sizing issue with the Advanced Alert Configuration window.

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

Resolves a sizing issue with the Advanced Options window.