Idera AI Documentation Assistant

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

12.3 New Features

SQL Diagnostic Manager presents the following features and enhancements:

  • An Improved User Interface with the following changes:
    • A new organization Grid View which allows a better glance at your instance metrics and properties.
    • An updated Windows Console Grid View similar to SQL Diagnostic Web Console.
    • A renovated Card View style, providing you with the same reliable information with a better-summarized look.
  • An improved administration dialog to change the scale Health Index Factor for SQL Diagnostic Manager Console.
  • A new Search feature for handling long lists across your servers, filters, alerts, and more.

  • A Step Forward or Backward with the drill-down option.

    Administrative actions are not included, only the actions associated with drill-downs are maintained.

  •  A new Automated Responses for ServiceNow action providers. To configure it, you must provide the Service Now information such as URL, Username, Password, and Alert Source.

12.3 Fixed Issues

Reports

SQLDM-32143 The "Server Uptime" report records the correct values for the uptime and downtime of a specific instance.

SQLDM-31873 The Database Statistics report is now generating data correctly for a custom range of time.

SQLDM-31680 The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager.

SQLDM-31683 SQL Diagnostic Manager correctly identifies query records where query plans have been successfully collected.

SQLDM-30535 SQL Diagnostic Manager successfully generates the "Template Comparison" report.

Alerts

SQLDM-32393 SQL Diagnostic Manager accurately displays alert data in the Historical Snapshots tooltip for a specific instance.

SQLDM-32347 SQL Diagnostic Manager correctly applies the "Where metric severity has changed is in place" alert rule.

SQLDM-32194 The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.

SQLDM-32182 The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds.

SQLDM-32173 The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully.

SQLDM-32021 SQL Diagnostic Manager provides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+).

SQLDM-31941 You can successfully configure e-mail notifications, including "and" conditions.

SQLDM-31737 You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3.

SQLDM-31256 The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details.

SQLDM-28938 SQL Diagnostic Manager only displays the active alerts on the environment views.

Alerts Response

SQLDM-32215 SQL Diagnostic Manager improved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule.

SQLDM-32030 After upgrading to SQLDM 12, SQL Diagnostic Manager maintains the "Email (SMTP) Provider" alert response configuration.

SQLDM-31876 With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider.

SQLDM-30889 You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.

Custom Counters

SQLDM-32148 SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations.

SQLDM-30385 SQL Diagnostic Manager successfully applies Custom Counter in new Servers when using templates.

SQLDM-32040  SQL Diagnostic Manager allows selecting and applying custom counters to all servers when creating metric alert responses for cluster environments.  

SQLDM-32034 When using the SQL Diagnostic Manager manual Maintenance Mode, the instances remain linked to Custom Counters.

General

SQLDM-31974 SQL Diagnostic Manager supports Extended Event Options for the Activity Monitor and the Query Monitor properties.

SQLDM-31303 SQL Diagnostic Manager allows user accounts to apply alert templates to a monitor instance.

SQLDM-30861 SQL Diagnostic Manager improved the analyzer's performance, providing more accurate analysis recommendations.

DM Console

SQLDM-32339 SQL Diagnostic Manager allows you to successfully add a new user through the Application Security tab.

SQLDM-32267 SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.

SQLDM-32256 With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display.

SQLDM-32232 SQL Diagnostic Manager now allows you to grant users access to specific instances through the Application Security window.

SQLDM-32227 You can successfully export the Analyze report of a monitored instance.

SQLDM-32178 SQL Diagnostic Manager successfully displays the history browser for SQL Server Azure-managed instances.

SQLDM-32063 SQL Diagnostic Manager successfully monitors and displays information for scale-out installations, showing the correct version.

On-Premises

SQLDM-31859 The Permissions Script for User Creation was successfully improved and now works as expected.

IDERA Web Console

SQLDM-32333 SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade.

SQLDM-32291 Dates are now displayed in the proper format on SQLDM Web Console.

SQLDM-32274 SQL Diagnostic Manager correctly displays graphics in the Web Console, since the graphics order has been fixed.

SQLDM-32242 SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.

SQLDM-32228 The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.

High Availability Groups

SQLDM-32147 The "Days since the last backup" alert functions as intended according to the backup preference settings for High Availability Groups.

SQLDM-31875 SQL Diagnostic Manager successfully monitors listener status in a High Availability environment while monitoring replicas.

Upgrade

SQLDM-32421 SQL Diagnostic Manager displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4

SQLDM-32299 After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files.

SQLDM-32181 You can successfully upgrade SQL Diagnostic Manager to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags.

SQLDM-32150 SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade.

SQLDM-32026 SQL Diagnostic Manager successfully triggers notifications for "SQL Server Agent Job Failure" alerts after an upgrade.

DBaaS

SQLDM-32221 SQL Diagnostic Manager keeps the last Sever selection and Time Period for using them when configuring a new report.  

Metrics

SQLDM-32130 SQL Diagnostic Manager increased the maximum critical threshold value for the "Version Store Size (MB)" metric.

SQLDM-32109 SQL diagnostic Manager successfully displays the "SQL Server CPU Usage" metric after upgrading to SQLDM 12.

SQLDM-31812 The "Procedure Cache Hit Ratio" metric has been improved on Azure SQL Managed Instance and Azure DB.

Charts

SQLDM-31870 SQL Diagnostic Manager correctly shows the Total Deadlock data in the Overview and Sessions charts after an upgrade.

History Browser

SQLDM-32019 SQL Diagnostic Manager successfully collects historical data in the History Browser for all the monitored servers.

SQLDM-31951 SQL Diagnostic Manager correctly displays historical data for TempDB summary in the history browser and across multiple time ranges.