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 SQLDM 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 SQLDM 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 SQLDM.
SQLDM-30977 SQLDM 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 SQLDM desktop console is no longer showing slow performance when monitoring a large number of instances.
SQLDM-31094 SQLDM 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 SQLDM now correctly monitors Availability Group servers with read/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.