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

SQLDM-27123 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

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

Metrics

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

Web Console

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

SQLDM-29173 Improved performance of the SQL Diagnostic Manager Web Console.

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

Deadlocks

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

Desktop Console

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

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

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

SQLDM-29220 The Desktop console is no longer displaying random exceptions.

Alerts

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

SQLDM-28824 SQLDM now correctly imports Alert templates.

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

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

Powershell

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

Table Statistics

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

Reports

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

Services

SQLDM-29437 Improved memory consumption by the SQLdm Management Service.

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

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



IDERAProductsPurchase | Support | Community | Resources | About Us | Legal