SQL Diagnostic Manager provides the following new features and fixed issues.
Customers that have installed SQLDM 11.0.0.3871 build and want to install the new build 11.0.0.3886 will require to uninstall and reinstall. If you do not need Azure SQL SQL or Managed Instance support, there is no reason to uninstall and reinstall.
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 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.