SQL Diagnostic Manager provides the following new features and fixed issues.
10.2.3 New Features
No new features for this version.
10.2.3 Fixed Issues
Installation and Upgrade
- The reported issues when re-installing SQL Diagnostic Manager with a pre-existing repository, have been solved.
- The ongoing SSL errors when attempting to install SQL Diagnostic Manager have been solved for this version.
- The Unable to monitor error "Error interpreting Job Alerts Collector: Invalid column name 'job_last_run_duration'." is no longer displaying when running an upgrade.
- SQL Diagnostic Manager now correctly displays historical snapshots after upgrading.
Analysis
- SQL Diagnostic Manager now correctly displays accurate results when running an Analysis.
Availability Groups
- SQL Diagnostic Manager now correctly connects to Availability Group listeners, and monitoring AlwaysOn instances.
Graphs
- The Session Statistics graph is no longer having issues showing the Y-axis values of the Transactions per Minute graph.
WMI
- The reported problem of WMI not being available on some servers has been fixed.
Dashboard
- IDERA Dashboard is no longer reporting maintenance mode status in actively monitored instances.
- The IDERA Dashboard is displaying data in the Queries view screen, the message "No Data Available. Please try after some time" is no longer showing.
- The IDERA Dashboard is now allowing access to the web console through domain groups and individual accounts.
- Users are no longer having issues when they manually register SQL Diagnostic Manager in the Dashboard.
Services
- The error displayed in the desktop console, when users were trying to connect to the SQLdm Management service, has been fixed.
- SQL Diagnostic Manager is now correctly firing alert emails when the SQLdm Collection service is down.
Metrics
- The changes that users applied to the metrics in the default templates are no longer causing errors.
Grooming
- SQL Diagnostic Manager is no longer displaying erroneous time-range data in the ChangeLog and is complying the user grooming configuration.
- The DatabaseFileStatistics grooming is running as expected and it has stopped timing out.
SQLDM Mobile
- The reported problem when running queries in SQLDM Mobile is no longer an issue in Chrome and other browsers.
Alert Rules and Alert Responses
- SQL Diagnostic Manager now correctly generating emails for all the configured Alert Rules that has the "Where metric severity has changed" option enabled.
- SQLDM is now sending alerts to SCOM for the metrics and severities specified in the rule, without disruption.
- The Alert Response "Send all Alerts to Scom as Alerts" is no longer having issues when the default configuration is changed.
- When the default configuration is changed in the Alert Response "Send all Alerts to SCOM as Alerts", these changes are correctly applied and work as expected.
Alerts
- SQL Diagnostic Manager is notifying the user by email when the alert "Blocking Session Wait Time" has a critical status.
Other issues
- The Sessions, Queries, and Query Waits screens in the desktop console are displaying data normally.
- The errors in the details of a Deadlock occurrence caused by an "intra-query parallelism deadlock" have been fixed.
- SQLDM now correctly displays query data statements. All queries are matching up with their associated databases.
- The error: "Key already exists, Parameter name key (Infragistics2.Shared.v10.3)" is no longer displaying when removing the Details column in the Signature Mode screen located in the Query Monitor.
- The problem that users had when creating custom dashboard in the SQL Diagnostic Manager web console, has been solved.
- The friendly names are no longer being removed by SQL Diagnostic Manager.
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.