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.