Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 2

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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

...

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

...