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