SQL Diagnostic Manager provides the following new features and fixed issues.
10.5 New Features
- SQL Diagnostic Manager now includes Prescriptive Analysis improvements (embedded SQL Doctor), updated user interface that matches SQL Doctor workflows, and updated recommendations (specifically for Azure SQL and Amazon RDS).
- This release includes Cloud DBaaS user interface improvements that ease the management of Azure SQL and Amazon RDS management supported metrics.
- SQL Diagnostic Manager now includes Alerting improvements:
- New alert templates with revised thresholds and ranks.
- New conditions for Alert Responses.
- New Alert filter to avoid false positives from spikes, filter by percentage of time over a period exceeding threshold.
- PowerShell command to Apply Alert template.
- New Alerts and metrics for Azure SQL and Amazon RDS specifically.
- All alert priority levels were updated for existing alerts and for user customization.
- New alert template reports.
10.5 Fixed Issues
Alerts
SQLDM-19380 The Alert Suppression settings for the Availability Group Synchronization Health metric now functions as expected.
SQLDM-28167 Alert Summary for the Blocking Session Wait Time (Seconds) metric is not displaying time using the local time zone.
SQLDM-29019 The alerts "SQL Server Agent unable to monitor" and "WMI service is unavailable" are no longer triggered when the monitored servers are successfully connected to the WMI service.
Analysis
SQLDM-26371 SQL Diagnostic Manager is no longer prompting an error when performing an Analysis, which was caused by the Prescriptive Service not installing "TracerX.Logger.dlll" file.
SQLDM-28684 History Browser is no longer used for Prescriptive Analytics with the revised interface.
SQLDM-29891 SQL Diagnostic Manager now successfully completes analysis and the results are displayed as expected.
Web Console
SQLDM-28317 The SQL Diagnostic Manager Web Console correctly displays the statuses of monitored instance.
SQLDM-29215 The SQL Diagnostic Manager Web Console now correctly honors the Application Security settings that is configured in the SQL Diagnostic Manager Desktop Console.
SQLDM-30087 The IDERA Dashboard now correctly displays the federation drop down menu.
Metrics
SQLDM-28570 The 'Days since last backup' metric no longer generates alerts for databases that have never been backed up
SQLDM-29192 The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds).
SQLDM-29425 When configuring the "Oldest Open Transaction" metric, SQL Diagnostic Manager now correctly saves the exclusion filter value when wildcards are used.
Desktop Console
SQLDM-28912 Improved the performance of the SQL Diagnostic Manager Desktop Client when updating properties of a monitored SQL Server instance.
SQLDM-29467 Index rebuilding operation in SQLDM desktop console now correctly works and is no longer displaying errors.
Reports
SQLDM-28960 The Deadlock Report now correctly displays all the information about the deadlocks occurred in the monitored instances.
SQLDM-29427 The error "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" is no longer displaying when running the "Detailed Session Report".
SQLDM-29689 The Deadlock Report now correctly shows the total number of deadlocks.
SQLDM-29767 The Database Statistics report no longer encounters a timeout error when generating the report.
SQLDM-29917 The Detailed Session Report now successfully deploys to SSRS.
Services
SQLDM-29432 When monitoring a SQL Server instance using a privilege minimized user, Query Monitor and Wait Statistics collection will now resume upon a restart of the SQL Diagnostic Manager services.
SQLDM-29521 The SQLDM Management Service no longer crashes when a server has been registered as a Linux instance.
SQL Server supported versions
SQLDM-29447 SQL Diagnostic Manager now correctly monitors SQL Server 2000 instances.
SQLDM-29545 SQLDM now correctly monitors SQL Server 2005 instances.
SQLDM-29658 The error "SQL Agent unable to monitor" is no longer prompting when monitoring instances running specific SQL Server versions.
Memory
SQLDM-29492 SQLDM now correctly shows the OS memory usage on the newly added servers.
Upgrade
SQLDM-29529 The "Error interpreting File Activity Collector: Invalid column name 'unused_size'" error is no longer displaying after upgrading to SQLDM 10.3.
SQLDM-29715 The SQLDM desktop console now correctly works after an upgrade to 10.3.1 version.
Sysadmin Permissions
SQLDM-29931 SQL Diagnostic Manager no longer generates an error message indicating that sysadmin rights are required in order to collect OS Metrics.
Mirroring
SQLDM-29985 SQLDM now correctly refreshes the Mirroring history of a database.
Query Waits
SQLDM-30183 The refresh error when navigating in the Query Waits screen is no longer displaying.
Azure
SQLDM-30189 SQL Diagnostic Manager is no longer generating an error related to Procedure Cache when monitoring Azure SQL Database.