SQL Diagnostic Manager for SQL Server v14.1主要版本2026年5月21日
功能
Introduces new AI-powered optimization workflows designed to help DBA diagnose and improve SQL Server performance faster and with greater confidence:
Use the AI Powered Query Optimization feature to optimize a single, problematic SQL query to reduce execution time based on your current schema and index structure.
Use the AI Powered Schema & Index Optimization feature to generate optimal index structures for a set of queries (up to five) to minimize cumulative execution time across all queries.
Use the AI Optimization History tab to view previous AI optimization sessions including queries analyzed, schema submitted, and AI recommendations. This tab provides a complete audit trail of all optimization activities performed in SQL DM.
These features are currently offered for SQL DM desktop version only.
SQL DM disables AI features by default. Contact your administrator to enable these features.
修正
Alerts
Resolves an issue causing the daily "SQL Server Status: Unable to Connect" to falsely alert for all registered AG nodes.
Resolves an issue causing the "Where refresh occurred during a specific time frame" alert condition to disappear once saved in a rule.
General
Updates OAuth2 authentication functionality.
Resolves an issue causing the SQLdm Management Service to crash at random times.
Resolves an issue preventing an analysis from returning any results.
Resolves an issue causing SQL DM to display a permissions error when it really is a network issue causing the failure.
Resolves an issue causing the Historical Snapshots view to display some inaccurate information.
Resolves an issue causing SQL DM to grant db_owner permissions to some users when granting view access.
Web Console
Resolves an issue that allowed some user accounts without permission to the SQLdm repository or its host instance to access the Web Console.
The Web Console includes a Signal Icon in the upper-right corner of the window that indicates when new SQL DM product and marketing information is available.
SQL Compliance Manager v8.42026年4月7日
功能
Support for SQL Server 2025 and Windows Server 2025
Now fully supports SQL Server 2025 (for both Repository and Monitored Instance) and Windows Server 2025, improving compatibility with the latest SQL and Windows Server environments.
Console Display Signal Icon
Displays a Signal Icon to indicate when new product news is available. The icon appears in the top-right corner of the SQL Compliance Manager console. Hovering over the icon shows a tooltip with the following information:
Green Icon - New news available.
White Icon - No news available.
Orange Icon - Unable to connect to update server.
修正
Resolved an issue in Reports where the Login Parameter did not display all the login lists, preventing users from running reports for selected logins.
Fixed an issue where Extended Event files were not created when the 'WHERE' clause reached the 3,000-character limit.
Resolved an issue where changes to SQL Server settings were not detected, preventing users from monitoring and tracking these updates.
SQL Management Suite - includes SQL Compliance Manager v8.32026年1月22日
功能
Event Alerts
Enhanced SQL Object Handling with Schema Name Support
SQL Compliance Manager 8.3 enhances the capabilities of Event Alerts, introducing Schema Name Support across the Event Alert Wizard, String Search Dialog, and RuleProcessor, with improved SQL Object Handling and expanded Event Alert coverage.
修正
Resource Usage
Resolved an issue where Capturing Login Events could cause excessive CPU usage.
Fixed an issue where the Collection Server trace directory could not process backlog files.
Fixed a case where, after upgrading the SQL Compliance Manager version, it would populate the ObjectType column in the event repository with a value of 0 for certain event classes.
Updated UI terminology by changing “Collection Servers” to “Collection Services” for improved clarity and consistency.
SQL Management Suite - includes SQL Diagnostic Manager for SQL Server v13.32026年1月8日
功能
Improved the web UI by including the following Resources tabs available in the Windows console:
Summary.
CPU.
Memory.
Disk.
Disk Size.
修正
Alerts
Resolved an issue causing a false alert for the SQL Server CPU Usage (Percent) showing 100%.
Resolved an issue causing a false alert for the SQL Server Memory Usage (Percent) showing 100%.
Resolved an issue causing WMI connection errors.
No longer triggers false alerts generated from the AG primary replica and listener nor does it register the listener.
DM Console
Dashboard charts such as Memory Areas and Buffer Caches no longer show double values on the Y axis.
General
Resolved an issue causing Windows connection failures when multiple accounts are used with the Alternative Authentication option.
Resolved an issue causing the Tables & Indexes tab contents to not properly refresh.
Resolved an issue preventing the Analyze feature from properly displaying a complete SQL script in the list of queries.
Resolved an issue preventing some users from seeing new indexes upon upgrading to SQL DM 13.0.
Resolved an issue preventing some users from viewing their C drive in the Resources tab.
Resolved an issue preventing Azure Managed Instances from inclusion in historical snapshots.
SQL Server no longer remains in maintenance mode after scheduled maintenance time is over.
An issue causing the password to unmask when switching between authentication types is resolved.
The Properties dialog now properly displays the added Access Key, Secret Access Key, and Region values when registering an RDS instance.
The Query Execution Plan now properly appears and with correct colors.
SQL DM now displays the name and details of a stored procedure when viewing events.
Query Monitor
Resolved an issue causing Query Monitor to use an incorrect alternate authentication.
Resolved an issue that allows the Signature and Standard graphical views to display data even with Query Monitor disabled.
The alternative authentication option no longer causes SQL Server connection failures when using multiple accounts.
Reports
Resolved an issue causing the Table Growth Forecast graph to not include all data.
The Disk Space Usage report now correctly displays information for all drives and includes those drives in the report disk filter.
UI
The Connect to Repository dialog user interface no longer is shifted and hiding some controls.
Web Console
Resolved an issue preventing the Web Console from loading the Alerts tab and causing a delay when updating the server status.
Resolved an issue causing the Web Console to display incorrect transaction scaling.
The Web Console now correctly lists server dashboard charts with connection of the DMSO cluster database.
Web Console graphs no longer hide lower values because of graphical display.