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

10.4 New features

• Visual Query Plans is now available for launch in the Windows Client context from any query.
• SQL Diagnostic Manager includes an improved collection of Extended Event query plans.
• This release includes new options to exploit Query Store collections for query waits, query plans, and query performance.
• Improved IDERA Dashboard with new alerts grid and instance lists.

10.4 Fixed Issues

Maintenance Mode

Enabling maintenance mode on an ad-hoc basis no longer purges the scheduled maintenance mode settings. This allows users to easily restore schedule maintenance mode settings as needed.

Azure Databases

The SQL Diagnostic Manager Desktop Client is no longer returning error messages when viewing data on monitored Azure Databases.

Metrics

The metric "SQL Server Log size" is triggering alerts as expected.

Web Console

The SQL Diagnostic Manager Web Console is correctly reporting the statuses of the monitored SQL Server instances.

Improved performance of the SQL Diagnostic Manager Web Console.

The SQL Diagnostic Manager Web console correctly recognizes users configured in Application Security.

Deadlocks

SQL Diagnostic Manager is no longer reporting persistent deadlocks from the [p_InsertDatabaseSize] procedure.

Desktop Console

The SQL Diagnostic Manager Desktop Client now correctly displays dates based on the Operating System settings.

The SQLDM Graphical User Interface now correctly responds and no longer hangs.

Improved performance when updating Monitored SQL Server Properties within the SQL Diagnostic Manager Desktop Client.

The Desktop console is no longer displaying random exceptions.

Alerts

SQL Diagnostic Manager now correctly sends alerts in a timely manner via email.

SQLDM now correctly imports Alert templates.

When hovering over a monitored instance on the Servers panes view, the displayed tooltip now correctly displays the current active alerts.

The Alert suppression threshold now correctly works and triggers alerts as expected.

Powershell

The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds).

Table Statistics

Table Statistics collection is now properly excluding specified databases that are hosted on a case sensitive collation.

Reports

The Enterprise Summary report now correctly lists the SQL Server version of the monitored instances.

Services

Improved memory consumption by the SQLdm Management Service.

The SQLdm Management Service remains in a running state if the SQL Server instance hosting the SQLdm Repository database is unavailable.

SQL Diagnostic Manager will correctly report the status of the SQL Server Agent Service on SQL Server 2008 R2 instances.