SQL Diagnostic Manager provides the following new features and fixed issues.
10.2.2 New features
Cluster environment
- A UNC path is set for DataPath for the SQLDM services in a cluster install.
Reports
- SQL Diagnostic Manager runs the Detailed Session report. This report provides detailed session information of your selected SQL Server instance and is included under the Resource Analysis Reports.
- SQL Diagnostic Manager has included the Deadlock Report. This report lets you analyze deadlocks on your SQL Server instance and is included under the Monitor reports.
- SQL Diagnostic Manager allows you to exclude one or more disks when running the Disk Space Usage report.
10.2.2 Fixed issues
IDERA Dashboard
- The errors "Error while fetching data” displayed in the IDERA Dashboard overview widgets are no longer shown.
- The IDERA Dashboard is no longer having issues when displaying data for SQL Diagnostic Manager groups and individuals login accounts.
- SQL Diagnostic Manager is no longer showing slow performance in the IDERA Dashboard.
- The widgets are displaying without problems when SQL Diagnostic Manager has been registered again in the Dashboard.
Web console
- SQL Diagnostic Manager is no longer displaying the error "Page not found" after entering valid credentials in the web console.
- The web console is no longer having issues displaying data.
TempDB
- The Tempdb summary screen is no longer displaying unhandled exceptions. The widgets are updating as expected.
Extended Events
- The query information is collected through Extended Events smoothly and is visible in all instances.
Reports
- When exporting an Alerts report as XML in the Dashboard, the "org/apache/xmlbeans/XmlObject" error is no longer generated.
Query Plan
- The Query plan information is collecting and populating to the Dashboard without problems
Metrics
- The "Availability Group Role Change" metric is generating alerts and notifying users by beeper and email alerts. This metric is generating OK status and working as expected.
Resources
- The Disk selection located in the Resource tab of the desktop console is no longer having issues when displaying data.
- Users are no longer getting the "The stored procedure 'p_GetDiskSizeDetails' doesn't exist (System.Data)" error, when they go to the Disk Size screen located in the Resources tab of the desktop console.
Availability Groups
- The availability groups historical views are displaying accurate information. The Availability Group is no longer having issues when browsing back to previous snapshots.
Alerts
- The alerts status is working as expected when the metrics are set to run alerts in specific thresholds values.
- The thresholds of the metric "Availability Groups Redo Queue" can be extended to higher values.
- The sudden spikes and drastic drops of SQL Diagnostic Manager alerts are no longer occurring
- When the threshold values of a custom counter are updated, the changes are reflected into the linked instances.
- SQL Diagnostic Manager is no longer showing problems while displaying deadlocks information in the Alerts tab of the desktop console.
- The Alerts summary is displaying the correct time zone in the alerts details description.
Other Issues
- SQL Diagnostic Manager is no longer having issues when creating shortcuts for all users.
- SQL Diagnostic Manager is no longer displaying installation failed messages.
- The blocking alerts triggered with no description data when SQL Diagnostic Manager is upgraded, are no longer an issue.
- The exception filter wildcard is working without problems after SQL Diagnostic Manager is upgraded.
- When a user clicks the "Optimize Script" button in the Finding Text of the Analyze option, SQL Diagnostic Manager is able to receive SQL Script without problems.
- After installing SQL Diagnostic Manager, an unhandled exception is shown together to the "Connect to Repository" message.
- SQL Diagnostic Manager is no longer displaying inconsistent Wait stats.