SQL Diagnostic Manager provides the following new features and fixed issues.
13.0 New Features
SQL Diagnostic Manager presents the following features and enhancements:
- SQL Diagnostic Manager now supports the Entra ID Authentication method for all monitoring accounts for on-prem instances or DBaaS environments, including Azure DB, Azure Managed Instance, and Azure Elastic Pool. This new feature comes with several benefits, such as:
- Enhancement of the Azure Discovery feature in SQL Diagnostic Manager by avoiding manually entering credentials for each database or instance.
- Ease of adding large numbers of Azure resources with shared Entra ID credentials.
- More secure connections through Azure SQL than SQL Server authentication.
- Allows you to copy certain property settings to another monitored instance.
- By default, disables the 'Table Statistics' collection for new instances.
- Operations Alerts are now available for alert responses.
Finally, we have newly implemented features for the SQLDM Web Console that improve its performance:
- Automatic data refresh every minute.
- Windows Authentication is the default authentication method.
13.0 Fixed Issues
Alerts
SQLDM-32735 SQL Diagnostic Manager now accurately generates database alerts for SQL Server 2022, displaying the correct database status alerts.
SQLDM-32629 The Alerts view displays all the current alerts when applying the "All" filter to the Server field.
SQLDM-32528 SQL Diagnostic Manager alerts work as expected for model_msdb and model_replicatedmaster databases in SQL Server 2022 environments. It no longer triggers backup alerts.
SQLDM-32521 SQL Diagnostic Manager effectively generates the Blocking Session Wait Time alert, displaying the Real-Time view and Block details when selected.
SQLDM-32354 SQL Diagnostic Manager allows you to snooze Alerts without any errors.
SQLDM-32330 SQL Diagnostic Manager enables you to export and import alert templates, keeping all your previous configurations.
SQLDM-32293 and SQLDM-32764 SQL Diagnostic Manager properly applies all the Alert recommendations for your servers.
SQLDM-32245 SQL Diagnostic Manager successfully shows Operational Alerts in the Alert view.
SQLDM-32147 The Days since last backup alert considers the backup preference settings, working as expected.
SQLDM-32087 SQL Diagnostic Manager provides useful alert recommendations in the Configure Alerts view.
SQLDM-31718 SQL Diagnostic Manager provides useful recommendations for Missing Index alerts, pointing to the affected tables.
Alerts Response
SQLDM-32517 When adding a Power Shell Script as an Alert Response, the Power Shell command action defaults to PS ISE x64 when clicking the Test button.
Analysis
SQLDM-32420 SQL Diagnostic Manager now supports displaying analysis results for servers across different time zones.
Custom Counters
SQLDM-32699 In SQL Diagnostic Manager 13.0, you can successfully create a custom counter template based on an existing one, keeping previously defined thresholds.
DM Console
SQLDM-32697 The Activity Monitor option is disabled by default and the Types of SQL Server activities to capture are grayed out. Once you enable the Activity Monitor, all related options become accessible and can be configured.
SQLDM-32678 SQL Diagnostic Manager accurately displays Query History data from the Queries view, ensuring consistency with the Details data from the Sessions view.
SQLDM-32664 SQL Diagnostic Manager 13.0 allows you to successfully apply the Baseline configuration to the available monitored SQL Server instances.
SQLDM-32626 SQL Diagnostic Manager now offers more detailed information about the monitored instances, including their version details.
SQLDM-32597, SQLDM-32594, and SQLDM-32344 SQL Diagnostic Manager displays the instance name and related information in the server thumbnail on the Server Overview dashboard. However, if the name exceeds the maximum length allowed, it will be truncated. View the full server name by hovering over the thumbnail to see it in a tooltip.
SQLDM-32559 SQL Diagnostic Manager 13.0 successfully refreshes the data in the Details tab of the Session view, ensuring accurate and error-free execution.
SQLDM-32503 SQL Diagnostic Manager supports Alternative Windows Collections accounts for instances with High Availability group servers.
SQLDM-32168 SQL Diagnostic Manager lets you minimize and maximize the My Server and Tags tree view with the latest SQLdm version.
SQLDM-32153 The SQL Diagnostic Manager console now correctly displays the tags assigned to the logged-in user.
SQLDM-26085 SQL Diagnostic Manager now fully captures and displays the SQL text in the Last Command window of the Details tab within the Sessions view.
General
SQLDM-32604 SQL Diagnostic Manager now correctly shows the session data when configuring a custom range for the historical view.
SQLDM-32582 Now SQL Diagnostic Manager supports PowerShell cmdlets for registering or editing Azure DBs.
SQLDM-32479 SQL Diagnostic Manager 13.0 detects duplicate users and displays the "The login name already exists, please enter a different login name" error.
SQLDM-31574 TracerX has been updated to 6.1.
SQLDM-30980 SQL Diagnostic Manager successfully adds instances, displaying both the instance name and IP address. Additionally, the replication tab shows the subscriber details without any errors.
Graphs
SQLDM-32702 The Block Graphs feature provides the details of blocking alerts when double-clicking on the blocking alert.
SQLDM-32670 SQL Diagnostic Manager now successfully displays data for the Tempdb Space Used by File graph.
SQLDM-32615 SQL Diagnostic Manager displays Memory Usage graph data correctly.
High Availability Groups
SQLDM-30236 SQL Diagnostic Manager displays the correct row information for tables with clustered column storage index on SQL Server 2017.
Metrics
SQLDM-32466 The Database Status metric now correctly alerts you to the severity level after its threshold value has been changed from the default setting. Besides the Template Comparison report displays the Restoring and Recovery Pending status.
SQLDM-32381 In SQL Diagnostic Manager 13.3, updating the Days Since Last Backup metric thresholds in a template does not affect the thresholds of monitored instances.
SQLDM-32373 The Availability Group Name is now displayed in the Alert Metrics Details section and is included in the alert email.
SQLDM-32368 The Database Status metric now correctly alerts you to the severity level after its threshold value has been changed from the default setting.
On-Premises
SQLDM-31161 SQL Diagnostic Manager displays user session information for SQL Azure managed server.
Queries
SQLDM-32397 Query Monitor successfully collects data for Azure Databases servers.
SQLDM-32395 The Diagnose Query feature performs a query analysis as expected and provides recommendations related to the selected query.
SQLDM-32384 A new index has been added to improve the performance of the Queries views.
SQLDM-31691 The Diagnose Query feature is working correctly, displaying the recommendations for the selected query within the Statement Mode tab of the Queries view.
Reports
SQLDM-32502 The Baseline statistics report is generated successfully without any errors.
SQLDM-32308 SQL Diagnostic Manager generates the Disk space usage report successfully when defaulting to 'No Disk Exclusion'.
SQLDM-32247 In SQL Diagnostic Manager, you can now generate reports successfully using the <All Instances> filter option.
SQLDM-30037 The Block Report and Deadlock Report widgets correctly display the synced data with their corresponding reports.
IDERA Web Console
SQLDM-32644 Users with view-only permissions can successfully log in to the SQLDM Web Console.
SQLDM-32614 SQLDM Web Console now accurately displays the Network Response Time metric.
SQLDM-32613 SQLDM Web Console now correctly displays the Cache Hit Ratio metric.
SQLDM-32602 SQLDM Web Console correctly displays the server details in the Thumbnails view on the Home tab.
SQLDM-32537 SQLDM Web Console now correctly displays all server technical details in the Server Overview charts view.
SQLDM-32535 IDERA Web Console displays graphs correctly with ascending time axes.
SQLDM-32508 SQLDM Web Console now displays the Disk metrics graphs in the server's time zone.
SQLDM-32441 The SQL Diagnostic Manager Installation Wizard warns you about any problems that may occur during the installation of the IDERA Web Console.
SQLDM-32431 The performance of the IDERA Web Console has been enhanced to reduce high CPU usage and decrease the time required to display graphs.
SQLDM-31714 IDERA Web Console now successfully displays data on all widgets, including the SQL Server Memory Usage (Percent).
UI
SQLDM-31714 SQL Diagnostic Manager has improved the date/time axis on the Memory Usage chart for better clarity and more precise data visualization.
SQLDM-31714 SQL Diagnostic Manager has improved the Advanced Alert Configuration Wizard, making it easier to configure metrics.
SQLDM-31714 SQL Diagnostic Manager has corrected the console resizing feature to avoid performance issues in affected views.
Upgrade
SQLDM-32734 SQL Diagnostic Manager successfully monitors SQL Azure databases after an upgrade, fixing the unhandled exception on the Server Overview.
SQLDM-32692 The SQL Diagnostic Manager's Upgrade Wizard now correctly identifies the current installation path of the SQLDM Web console when upgrading from 12.3.7 to 13.0.
SQLDM-32681 SQL Diagnostic Manager successfully applies the configured Alert Templates to the selected servers.
SQLDM-32654 SQL Diagnostic Manager successfully upgrades the LWWC while keeping the original SQLdmWebConsoleUI.exe.config file.
SQLDM-32618 New indexes have been added to improve the performance of the repository database.
SQLDM-32492 General stability improvements have been added for the SQLdm Management Service.
SQLDM-32378 After upgrading, SQL Diagnostic Manager retains the thresholds defined in the Advanced Alert Configuration for monitored servers.
SQLDM-31942 SQL Diagnostic Manager generates the Deadlock report when the grooming is configured.