View Source

SQL Diagnostic Manager provides the following new features and fixed issues:

10.5.1 New Features

SQL Diagnostic Manager now includes a new Server Uptime report.
This release includes three new default values for the History Browser range.
The "Days since last backup" alert configuration includes the option to include or exclude Read-Only databases.

10.5.1 Fixed Issues

Alerts

The SQLDM Desktop Console now displays the correct alerts when hovering the mouse over an object on the Server pane.

Alert timeline view is now displaying the time based on the Operating System settings.

SQL Diagnostic Manager now correctly checks and alerts High Fragmentation on the databases.

Alert Suppression for the SQL Server Service metric is now working as expected.

Alert Responses no longer requires the 'Where Alert Rank' option to be enabled in order to be triggered as expected.

Upgrade

Install/Upgrade of SQL Diagnostic Manager will no longer fail when the service account's password contains a special character.

Upgrade attempts of SQL Diagnostic Manager should no longer encounter an error regarding a constraint on the CloudProviders table.

An issue preventing upgrades from versions 10.4.2 and 10.4.3 has been resolved.

The custom Dashboards are no longer being deleted when upgrading from SQLDM 10.4.

Azure

The snapshot data collection is no longer failing for Azure SQL PaaS instances.

SQL Diagnostic Manager now correctly monitors Azure DBaaS and is no longer displaying errors.

SQL Diagnostic Manager now correctly displays Session details on Azure SQL Database.

SQLDM now correctly displays databases hosted in Azure SQL PaaS.

Desktop Console

Powered off instances are no longer shown as active in the SQLDM console.

The SQLDM Desktop Console will now properly convert the timestamps to local time when viewing the backup/restore history of a database.

SQL Diagnostic Manager will now generate a warning when the SQLDM Desktop Console is launched if it determines that the license key will be expiring soon.

Custom Counters

The Custom Counter reports now correctly displays data.

Query Waits

SQLDM now correctly shows the Query Wait collector status.

The timeline on the Query Waits view will now be displayed in the correct order.

SQL Diagnostic Manager now correctly detects all the specific disk drives for each SQL Server registered.

Services

SQLDM desktop console now correctly connects to the SQLdmManagement Service and is no longer throwing exception errors.

IDERA Dashboard

The SQLDM Web Console now displays timestamps using local time.

The SQLDM Web Console now correctly displays the Last Backup Date of a database.

SQL Diagnostic Manager can now be manually registered in the IDERA Dashboard.

vCenter

vCenter servers for monitored SQL servers in SQLDM can be added without problems.

Metrics

*The 'Days since last backup' metric has been updated to include additional advanced options specific for availability groups.

SQLDM now properly monitors the status of DTC and SQL Server Agent when collecting operating system statistics using OLE Automation.

Reports

The Disk Space Usage report in the SQL Server Reporting Services portal is no longer asking the value for the Disk parameter.

SQL Diagnostic Manager now collects deadlocks in Session > Blocking View and in Reports when using Extended Events or SQL Trace.

Database Growth Forecast report now correctly shows sufficient data.

Availability Groups

The "Aggregate Data SQLdmRepository" and "Groom SQLdm Repository" SQL Agent jobs now correctly run when the SQLDM Repository Database is hosted in an availability group.

SQL Diagnostic Manager is now showing correct mount points for monitored secondary replicas.

The databases in an SQLDM Availability Group now correctly capture growth statistics.

SQLDM Desktop Console no longer crashes when accessing the Availability Group view under Databases.

Improve the load time on the Availability Group databases view.

SQL Diagnostic Manager is no longer displaying errors and is successfully connected to servers holding repositories in an availability group without a listener.