Features

• Added a scalable Microsoft Windows User Interface to support UHD monitors and scalable Windows fonts.
• Added new Dark Mode for users who prefer dark background interfaces.
• Added a Heatmap Overview in Windows Console to better triage the relative health of a large number of Microsoft SQL Server environments.
• Improved Grid Overview with Alert Status by Category. The highly configurable grid overview displays user selected key instance metrics in order of preference, but now alert status of each category can be interpreted at-a-glance as well.
• Added full support for Amazon RDS for SQL Server.
• Added new alerts and alert template for Amazon RDS - All existing applicable alerts with on-premises SQL Server are enabled in addition to new alerts specific to RDS SQL.
  • Alerts to identify bottlenecks and insufficient resources allocated that may affect application performance.
  • Alerts to notify when resources may be over-allocated and money might be saved by reducing resources assigned.
• Consistency with on-premises SQL Server monitoring - Monitor Amazon RDS, Microsoft Azure SQL and on-premises SQL Server from a single-pane-of-glass and an interface organized in the same manner as on-premises SQL Server monitoring to avoid the learning curve associated with different products or plug-ins.

Features

• SQL Diagnostic Manager includes full support for Microsoft Azure SQL. This feature includes the following resources for the Azure SQL database:
  • Compatibility for Azure SQL Managed Instance with on-premises.
  • Elastic pools allow you to manage and scale multiple databases.
  • Single databases typically are used for development and small apps.
• This release includes the completion of Azure SQL alerts that were added previously. Among other features, these alerts include:
  • New alerts notify if the allocated resources are more than needed.
  • New displays for newly collected metrics.
• Added new alert templates with revised thresholds and priority/rank specifically for DBaaS (Azure SQL and Amazon RDS).
• Added new server wizard that uses Azure profile credentials, allowing you to discover other Azure DB assets.
• Azure profile credentials collect metrics from Azure monitor to extend SQL Diagnostic Manager.
• Prescriptive Analytics improvements, including new recommendations for Azure SQL DBaaS and Amazon RDS.

Fixes

• Alerts
  • SQL Diagnostic Manager now correctly alerts table fragmentation based on the table size configuration.
  • The advanced Alert Filter for the "Longest Running version Store Transaction (Minutes)" alert is working as configured.
  • The 'Clear Alert" option in the 'Availability Group Role Change' alert has been restored.
  • SQLDM shows "Recommendations are available" operational alert in the Active Alert list.
  • SQLDM Disk space alerts are now correctly triggering after an upgrade.
  • The Disk Full alerts are no longer triggered for excluded disks in the alerts configuration.
  • SQL Diagnostic Manager now correctly shows the correct alerts and thresholds for page life expectancy metric when using the Critical-Only Template.
  • The "Show Historical View" button in the Alerts Tab is now working as expected.
• Alert Response
  • The 'Enable the Query Wait' Alert Action will properly execute when an Alert Response is triggered.
• Availability Groups
  • SQL Diagnostic Manager no longer encounters an error when removing an instance that happens to be a replica within an availability group.
  • SQLDM now discovers preferred replica information from Availability Group settings.
• Cloud Monitoring
  • The notifications for blocked sessions and SQL Agent Job Failures when monitoring RDS instances are now working correctly.
• Custom Counters
  • The newly created custom counters are added to the existing templates and can be applied to new servers.
  • The Custom Counter alerts when using T-SQL script are raising correctly.
• Database
  • The Database status is now displaying accurate status.
• Extended Events
  • SQLDM now correctly add new servers and allows to select 'Extended Events' as the collection method for the Activity Monitor.
  • The performance of the query that collects Replication Statistics has been improved.
• General
  • SQL Diagnostic Manager now correctly monitors its own repository.
  • SQLDM installation is now completing successfully when the service account credentials contain special characters.
  • SQL Diagnostic Manager now correctly reports the Publisher Names for SQL Server 2016 SP2 or later.
  • Desktop Console Views now correctly keeps the custom views.
  • IDERA Newsfeed is correctly configured after installing SQL Diagnostic Manager.
  • SQL Diagnostic Manager now correctly displays baselines.
  • SQLDM Desktop console now correctly shows the critical SQL Server Service status.
  • SQL Diagnostic Manager successfully checks SQL Browser Service Alert status when the Remote Administrative connection is disabled and there is only a default SQL Server instance installed.
  • SQL Diagnostic Manager displays the correct information when you select a secondary tab.
  • The pause button now correctly works and it is integrated with the refresh button.
  • SQL Diagnostic Manager now correctly displays the "Session Details" grid.
  • The Query History view under the Queries tab is working as expected.
  • The "View Session Details" option is now correctly working.
  • The "View Locks" option is now correctly working.
• Graphs
  • The 'Disk busy per disk' metric graph now correctly loads under the Disk option from the Resources tab.
  • The blocking displayed in the reports and in the graphs are synced correctly.
  • The Alert Configuration window is no longer displaying inaccurate threshold graphs.
• Hyper-V
  • SQL DM successfully connects to Hyper-V Host Configuration.
• IDERA Dashboard
  • SQLDM web console is no longer reporting FIPS compliant environment errors.
  • The IDERA Dashboard login information is now correctly encrypted.
  • The SQLDM Web Console no longer encounters exceptions when IDERA Dashboard and the monitored instances are in different time zones.
  • The Overview tab in the web console is no longer displaying an exception when clicking the summary under the Active Alerts widget.
• Maintenance Mode
  • SQL Diagnostic Manager no longer erroneously reporting "Maintenance mode started" when maintenance mode has been disabled.
• Notifications
  • The Databases category metrics now correctly raise alerts and send email notifications.
• Query Monitor
  • SQLDM now correctly creates historical snapshots when Query Monitor is enabled and configured to use Query Store.
  • Powerscript now successfully enables Query Monitor.
• Reports
  • SQLDM successfully runs SSRS reports when more than 126 instances are selected.
• Services
  • SQLDM successfully collects information for disk drives volume formatted in ReFS.
• Upgrade
  • After upgrading SQLDM from 10.3 to 10.4 version, the Queries tab now correctly loads information.
  • SQLDM now correctly triggers and notifies alerts for the Session CPU Time after performing an upgrade.