SQL Diagnostic Manager provides the following new features and fixed issues.
11.0 New Features
- SQL Diagnostic Manager includes full support for Azure SQL. This feature includes the following resources for the Azure SQL database:
- The compatibility for Azure SQL Managed Instance with on-premises.
- Elastic pools that 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 in previous releases. Among other features, these alerts include:
- New alerts notify if the allocated resources are more than needed.
- New displays for newly collected metrics.
- New alert templates with revised thresholds and priority/rank specifically for DBaaS (Azure SQL and Amazon RDS)
- This version includes a 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.
11.0 Fixed Issues
Alerts
SQLDM-29184 SQL Diagnostic Manager now correctly alerts table fragmentation based on the table size configuration.
SQLDM-30421 The advanced Alert Filter for the "Longest Running version Store Transaction (Minutes)" alert is working as configured.
SQLDM-30487 The 'Clear Alert" option in the 'Availability Group Role Change' alert has been restored.
SQLDM-30528 SQLDM shows "Recommendations are available" operational alert in the Active Alert list.
SQLDM-30788 SQLDM Disk space alerts are now correctly triggering after an upgrade.
SQLDM-30825 The Disk Full alerts are no longer triggered for excluded disks in the alerts configuration.
SQLDM-30963 SQL Diagnostic Manager now correctly shows the correct alerts and thresholds for page life expectancy metric when using the Critical-Only Template.
SQLDM-31039 The "Show Historical View" button in the Alerts Tab is now working as expected.
Alert Response
SQLDM-29208 The 'Enable the Query Wait' Alert Action will properly execute when an Alert Response is triggered.
Availability Groups
SQLDM-30083 SQL Diagnostic Manager no longer encounters an error when removing an instance that happens to be a replica within an availability group.
SQLDM-30197 SQLDM now discovers preferred replica information from Availability Group settings.
Cloud Monitoring
SQLDM-30344 The notifications for blocked sessions and SQL Agent Job Failures when monitoring RDS instances are now working correctly.
Custom Counters
SQLDM-30385 The newly created custom counters are added to the existing templates and can be applied to new servers.
SQLDM-30524 The Custom Counter alerts when using T-SQL script are raising correctly.
Database
SQLDM-30575 The Database status is now displaying accurate status.
Extended Events
SQLDM-29005 SQLDM now correctly add new servers and allows to select 'Extended Events' as the collection method for the Activity Monitor.
SQLDM-29033 The performance of the query that collects Replication Statistics has been improved.
General
SQLDM-29384 SQL Diagnostic Manager now correctly monitors its own repository.
SQLDM-29408 SQLDM installation is now completing successfully when the service account credentials contain special characters.
SQLDM-30114 SQL Diagnostic Manager now correctly reports the Publisher Names for SQL Server 2016 SP2 or later.
SQLDM-30364 Desktop Console Views now correctly keeps the custom views.
SQLDM-30453 IDERA Newsfeed is correctly configured after installing SQL Diagnostic Manager.
SQLDM-30480 SQL Diagnostic Manager now correctly displays baselines.
SQLDM-30493 SQLDM Desktop console now correctly shows the critical SQL Server Service status.
SQLDM-30770 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.
SQLDM-30936 SQL Diagnostic Manager displays the correct information when you select a secondary tab.
SQLDM-31025 The pause button now correctly works and it is integrated with the refresh button.
SQLDM-31042 SQL Diagnostic Manager now correctly displays the "Session Details" grid.
SQLDM-31068 The Query History view under the Queries tab is working as expected.
SQLDM-31070 The "View Session Details" option is now correctly working.
SQLDM-31071 The "View Locks" option is now correctly working.
Graphs
SQLDM-29069 The 'Disk busy per disk' metric graph now correctly loads under the Disk option from the Resources tab.
SQLDM-30037 The blocking displayed in the reports and in the graphs are synced correctly.
SQLDM-30137 The Alert Configuration window is no longer displaying inaccurate threshold graphs.
Hyper-V
SQLDM-28327 SQL DM successfully connects to Hyper-V Host Configuration.
IDERA Dashboard
SQLDM-30032 SQLDM web console is no longer reporting FIPS compliant environment errors.
SQLDM-30260 The IDERA Dashboard login information is now correctly encrypted.
SQLDM-30350 The SQLDM Web Console no longer encounters exceptions when IDERA Dashboard and the monitored instances are in different time zones.
SQLDM-30526 The Overview tab in the web console is no longer displaying an exception when clicking the summary under the Active Alerts widget.
Maintenance Mode
SQLDM-30686 SQL Diagnostic Manager no longer erroneously reporting "Maintenance mode started" when maintenance mode has been disabled.
Notifications
SQLDM-30859 The Databases category metrics now correctly raise alerts and send email notifications.
Query Monitor
SQLDM-30397 SQLDM now correctly creates historical snapshots when Query Monitor is enabled and configured to use Query Store.
SQLDM-30664 Powerscript now successfully enables Query Monitor.
Reports
SQLDM-21051 SQLDM successfully runs SSRS reports when more than 126 instances are selected.
Services
SQLDM-28648 SQLDM successfully collects information for disk drives volume formatted in ReFS.
Upgrade
SQLDM-30170 After upgrading SQLDM from 10.3 to 10.4 version, the Queries tab now correctly loads information.
SQLDM-30312 SQLDM now correctly triggers and notifies alerts for the Session CPU Time after performing an upgrade.