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

 SQL Diagnostic Manager now accurately generates database alerts for SQL Server 2022, displaying the correct database status alerts.

The Alerts view displays all the current alerts when applying the "All" filter to the Server field.

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.

SQL Diagnostic Manager effectively generates the Blocking Session Wait Time alert, displaying the Real-Time view and Block details when selected.

SQL Diagnostic Manager allows you to snooze Alerts without any errors.

SQL Diagnostic Manager enables you to export and import alert templates, keeping all your previous configurations.

and SQL Diagnostic Manager properly applies all the Alert recommendations for your servers.

SQL Diagnostic Manager successfully shows Operational Alerts in the Alert view. 

The Days since last backup alert considers the backup preference settings, working as expected.

SQL Diagnostic Manager provides useful alert recommendations in the Configure Alerts view. 

SQL Diagnostic Manager provides useful recommendations for Missing Index alerts, pointing to the affected tables.

Alerts Response

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

SQL Diagnostic Manager now supports displaying analysis results for servers across different time zones.

Custom Counters

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

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.

SQL Diagnostic Manager accurately displays Query History data from the Queries view, ensuring consistency with the Details data from the Sessions view.

SQL Diagnostic Manager 13.0 allows you to successfully apply the Baseline configuration to the available monitored SQL Server instances. 

SQL Diagnostic Manager now offers more detailed information about the monitored instances, including their version details. 

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

SQL Diagnostic Manager 13.0 successfully refreshes the data in the Details tab of the Session view, ensuring accurate and error-free execution.

 SQL Diagnostic Manager supports Alternative Windows Collections accounts for instances with High Availability group servers.

SQL Diagnostic Manager lets you minimize and maximize the My Server and Tags tree view with the latest SQLdm version.

The SQL Diagnostic Manager console now correctly displays the tags assigned to the logged-in user.

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

SQL Diagnostic Manager now correctly shows the session data when configuring a custom range for the historical view.

Now SQL Diagnostic Manager supports PowerShell cmdlets for registering or editing Azure DBs.

SQL Diagnostic Manager 13.0 detects duplicate users and displays the "The login name already exists, please enter a different login name" error.

 TracerX has been updated to 6.1.

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

The Block Graphs feature provides the details of blocking alerts when double-clicking on the blocking alert.

SQL Diagnostic Manager now successfully displays data for the Tempdb Space Used by File graph.

SQL Diagnostic Manager displays Memory Usage graph data correctly.

High Availability Groups

SQL Diagnostic Manager displays the correct row information for tables with clustered column storage index on SQL Server 2017.

Metrics

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.

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.

The Availability Group Name is now displayed in the Alert Metrics Details section and is included in the alert email.

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

SQL Diagnostic Manager displays user session information for SQL Azure managed server.

Queries

Query Monitor successfully collects data for Azure Databases servers.

The Diagnose Query feature performs a query analysis as expected and provides recommendations related to the selected query. 

A new index has been added to improve the performance of the Queries views. 

The Diagnose Query feature is working correctly, displaying the recommendations for the selected query within the Statement Mode tab of the Queries view.

Reports

The Baseline statistics report is generated successfully without any errors.

SQL Diagnostic Manager generates the Disk space usage report successfully when defaulting to 'No Disk Exclusion'. 

In SQL Diagnostic Manager, you can now generate reports successfully using the <All Instances> filter option.

The Block Report and Deadlock Report widgets correctly display the synced data with their corresponding reports.

IDERA Web Console

Users with view-only permissions can successfully log in to the SQLDM Web Console.

SQLDM Web Console now accurately displays the Network Response Time metric.

SQLDM Web Console now correctly displays the Cache Hit Ratio metric.

SQLDM Web Console correctly displays the server details in the Thumbnails view on the Home tab. 

SQLDM Web Console now correctly displays all server technical details in the Server Overview charts view.

IDERA Web Console displays graphs correctly with ascending time axes.

SQLDM Web Console now displays the Disk metrics graphs in the server's time zone.

 The SQL Diagnostic Manager Installation Wizard warns you about any problems that may occur during the installation of the IDERA Web Console.

The performance of the IDERA Web Console has been enhanced to reduce high CPU usage and decrease the time required to display graphs.

IDERA Web Console now successfully displays data on all widgets, including the SQL Server Memory Usage (Percent).

UI

SQL Diagnostic Manager has improved the date/time axis on the Memory Usage chart for better clarity and more precise data visualization.

SQL Diagnostic Manager has improved the Advanced Alert Configuration Wizard, making it easier to configure metrics.

SQL Diagnostic Manager has corrected the console resizing feature to avoid performance issues in affected views.

Upgrade

SQL Diagnostic Manager successfully monitors SQL Azure databases after an upgrade, fixing the unhandled exception on the Server Overview.

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.

SQL Diagnostic Manager successfully applies the configured Alert Templates to the selected servers.

SQL Diagnostic Manager successfully upgrades the LWWC while keeping the original SQLdmWebConsoleUI.exe.config file.

New indexes have been added to improve the performance of the repository database. 

General stability improvements have been added for the SQLdm Management Service.

After upgrading, SQL Diagnostic Manager retains the thresholds defined in the Advanced Alert Configuration for monitored servers.

SQL Diagnostic Manager generates the Deadlock report when the grooming is configured.