SQL Diagnostic Manager provides the following new features and fixed issues:
10.5.1 New Features
- SQL Diagnostic Manager now includes a new Server Uptime report.
- This release includes three new default values for the History Browser range.
- The "Days since last backup" alert configuration includes the option to include or exclude Read-Only databases.
10.5.1 Fixed Issues
Alerts
SQLDM-28938 The SQLDM Desktop Console now displays the correct alerts when hovering the mouse over an object on the Server pane.
SQLDM-29434 Alert timeline view is now displaying the time based on the Operating System settings.
SQLDM-29594 SQL Diagnostic Manager now correctly checks and alerts High Fragmentation on the databases.
SQLDM-29840 Alert Suppression for the SQL Server Service metric is now working as expected.
SQLDM-30434 Alert Responses no longer requires the 'Where Alert Rank' option to be enabled in order to be triggered as expected.
Upgrade
SQLDM-29408 Install/Upgrade of SQL Diagnostic Manager will no longer fail when the service account's password contains a special character.
SQLDM-30381 Upgrade attempts of SQL Diagnostic Manager should no longer encounter an error regarding a constraint on the CloudProviders table.
SQLDM-30370 An issue preventing upgrades from versions 10.4.2 and 10.4.3 has been resolved.
SQLDM-30369 The custom Dashboards are no longer being deleted when upgrading from SQLDM 10.4.
Azure
SQLDM-29523 The snapshot data collection is no longer failing for Azure SQL PaaS instances.
SQLDM-30299 SQL Diagnostic Manager now correctly monitors Azure DBaaS and is no longer displaying errors.
SQLDM-30188 SQL Diagnostic Manager now correctly displays Session details on Azure SQL Database.
SQLDM-30013 SQLDM now correctly displays databases hosted in Azure SQL PaaS.
Desktop Console
SQLDM-29782 Powered off instances are no longer shown as active in the SQLDM console.
SQLDM-30244 The SQLDM Desktop Console will now properly convert the timestamps to local time when viewing the backup/restore history of a database.
SQLDM-30136 SQL Diagnostic Manager will now generate a warning when the SQLDM Desktop Console is launched if it determines that the license key will be expiring soon.
Custom Counters
SQLDM-30100 The Custom Counter reports now correctly displays data.
Query Waits
SQLDM-29671 SQLDM now correctly shows the Query Wait collector status.
SQLDM-30098 The timeline on the Query Waits view will now be displayed in the correct order.
SQLDM-30012 SQL Diagnostic Manager now correctly detects all the specific disk drives for each SQL Server registered.
Services
SQLDM-29997 SQLDM desktop console now correctly connects to the SQLdmManagement Service and is no longer throwing exception errors.
IDERA Dashboard
SQLDM-20002 The SQLDM Web Console now displays timestamps using local time.
SQLDM-28516 The SQLDM Web Console now correctly displays the Last Backup Date of a database.
SQLDM-29921 SQL Diagnostic Manager can now be manually registered in the IDERA Dashboard.
vCenter
SQLDM-29900 vCenter servers for monitored SQL servers in SQLDM can be added without problems.
Metrics
SQLDM-29802 *The 'Days since last backup' metric has been updated to include additional advanced options specific for availability groups.
SQLDM-29785 SQLDM now properly monitors the status of DTC and SQL Server Agent when collecting operating system statistics using OLE Automation.
Reports
SQLDM-28878 The Disk Space Usage report in the SQL Server Reporting Services portal is no longer asking the value for the Disk parameter.
SQLDM-29020 SQL Diagnostic Manager now collects deadlocks in Session > Blocking View and in Reports when using Extended Events or SQL Trace.
SQLDM-29685 Database Growth Forecast report now correctly shows sufficient data.
Availability Groups
SQLDM-19304 The "Aggregate Data SQLdmRepository" and "Groom SQLdm Repository" SQL Agent jobs now correctly run when the SQLDM Repository Database is hosted in an availability group.
SQLDM-28366 SQL Diagnostic Manager is now showing correct mount points for monitored secondary replicas.
SQLDM-20369 The databases in an SQLDM Availability Group now correctly capture growth statistics.
SQLDM-28629 SQLDM Desktop Console no longer crashes when accessing the Availability Group view under Databases.
SQLDM-28907 Improve the load time on the Availability Group databases view.
SQLDM-29229 SQL Diagnostic Manager is no longer displaying errors and is successfully connected to servers holding repositories in an availability group without a listener.
SQLDM-29547 SQLDM is no longer having problems collecting Database size data when monitoring Availability Groups instances.
Wait Statistics
SQLDM-29463 The Wait statistics are no longer displaying inconsistent values.
Deadlock
SQLDM-29006 The SQL Queries from the deadlock drop down output are no longer truncated.
Other issues
SQLDM-28694 SQLDM now correctly shows the closest historical snapshot when switching servers.
SQLDM-28606 SQLDM no longer generates login failures for 'SQLDiagMgr' in the SQL Server Error Log.
SQLDM-28603 SQL Diagnostic Manager now correctly shows the table sizes.
SQLDM-28327 SQLDM now correctly collects the CPU virtualization information on Hyper-V virtual environment.