Page History

SQL Diagnostic Manager provides the following new features and fixed issues.

10.2.

...

3 New

...

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.

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 is no longer having issues displaying historical snapshots when upgrading.

Analysis

...

• 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.

...

• displaying inaccurate results when running an Analysis.       

Availability Groups

• SQL Diagnostic Manager is no longer displaying the error "Page not found" after entering valid credentials in the web console.having issues when connecting to Availability Group listeners, and monitoring AlwaysOn instances.

Graphs

• The Session Statistics graph The web console is no longer having issues displaying datashowing the Y-axis values of the Transactions per Minute graph.

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

...

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 no longer having problems 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 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.

...

• 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 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.

• generating emails for all the configured Alert Rules that has the "Where metric severity has changed" option enabled.
• SQLDM is no longer having issues when sending alerts to SCOM for the metrics and severities specified in the rule.
• The Alert Response "Send all Alerts to Scom as Alerts" is no longer having issues when the default configuration is changed.

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.             
• SQL Diagnostic Manager is no longer displaying errors in the details of a Deadlock occurrence caused by an "intra-query parallelism deadlock".      
• SQLDM is no longer having issues when displaying 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 ManagerSQL Diagnostic Manager is no longer displaying inconsistent Wait stats.

...