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

11.1 New Features

  • SQL Diagnostic Manager includes full support for Amazon RDS.
  • This release includes the completion of Amazon RDS alerts that were added in previous releases. These alerts include:
    • New alerts notify if the allocated resources are more than needed.
    • Added display for newly collected metrics.
  • New Interface User features include UI Scaling (support for 4K monitors and scaled fonts) and a new dark mode theme.
  • This version includes a new Heatmap view and Grid view improvements for monitored servers in the desktop console.
  • Amazon RDS SQL Alerts and Alert Templates improvements.
  • Prescriptive Analitycs improvements for Amazon RDS monitored servers.

11.1 Fixed Issues

History Browser

SQLDM-29103 The History Browser returns query results within a 60-seconds time frame

Metrics

SQLDM-29161 The SQL Server Agent Job (Percent) metric correctly calculates the percentage value.

SQLDM-30761 The 'Database Full (Percent) metric is working as expected when the Alert Suppression is configured.

SQLDM-30764 The default configuration of the "SQL Server Error Log" metric correctly applies the 10MB file size limit.

SQLDM-30770 The SQL Server Browser metric is no longer raising alerts when only a default instance exists on the monitored server.

SQLDM-30986 The "Days since last backup" metric is no longer raising alerts for read-only databases that have been excluded from the metric.

SQLDM-31110 The SQL Server Agent Job Failure metric correctly raises alerts as expected.

SQLDM-31237 The "Days since last backup" metric now correctly works in Availability Groups environments.

SQLDM-31239 The SQL Server Agent Status metric correctly returns to an OK state when the service is detected to have been started.

Alerts

SQLDM-29189 The "The deadlock victim was spid 0 with application name 'unknown' by user 'unknown' on host 'unknown" alerts are no longer displaying.

SQLDM-29208 Alert Response rules are now correctly starting Query-wait statistic collection as it was configured.

SQLDM-30465 Corrected various issues with the Deadlock graphs and Alerts view within the SQLDM Web Console.

SQLDM-30502 Fragmentation alerts are triggering successfully after performing an upgrade.

SQLDM-30782 SQL Diagnostic Manager now raises alerts for Database Full (percent) metric in console when filtering by percentage.

SQLDM-30963 The alert for the "Page Life Expectancy" metric now takes the correct thresholds showing the right alerts.

SQLDM-30973 The advanced "filter by percentage" option correctly raises alerts as expected.

SQLDM-31061 The advanced alert filter for the 'Data File Autogrowth' alert is now correctly excluding databases.

SQLDM-31297 SQL Diagnostic Manager automatically applies certain alert templates based on the server type of the monitored instance.

General

SQLDM-30069 The Database widget under the Overview screen is now displaying data for the historical mode.

SQLDM-30083 Monitored instances are now correctly removed from SQL Diagnostic Manager.

SQLDM-30977 SQL Diagnostic Manager is no longer encountering an overflow error when a monitored SQL Server Agent Job is running longer than usual.

SQLDM-31036 SQL Diagnostic Manager is correctly sending OK status notifications and email notifications.

SQLDM-31080 SQL Diagnostic Manager desktop console is no longer showing slow performance when monitoring a large number of instances.

SQLDM-31094 SQL Diagnostic Manager correctly applies baseline settings to other monitored instances.

SQLDM-31198 Customized Dashboards in the SQLDM Desktop Client are now correctly saved in the repository database.

SQLDM-31202 SQLDM successfully applies new baselines' configuration to monitored instances.

SQLDM-31420 Now SQL Diagnostic Manager successfully shows paging graphics in the Memory Screen of the Resources tab.

Services

SQLDM-30435 Improved the stability of the SQLDM Management Service.

Availability Groups

SQLDM-30512 SQL Diagnostic Manager now correctly monitors Availability Group servers with reading/write permissions.

Reports

SQLDM-31001 The Disk Statistic report is now correctly showing the total number of drives of a monitored server.

SQLDM-31106 When the user runs the report for CPU or Memory statistics selecting Show Baseline, it returns Actual and Baseline Stats.

SQLDM-31117 The "Top Query" report now works successfully for all production servers.

SQLDM-31152 The Database Growth Forecast report correctly categorizes system databases when using the database selector.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal