Versions Compared

Old Version 33

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Barrientos

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.

Info

Customers that have installed SQLDM 11.0.0.3871 build and want to install the new build 11.0.0.3886 will require to uninstall and reinstall. If you do not need Azure SQL SQL or Managed Instance support, there is no reason to uninstall and reinstall.

...

12.3 New Features

SQL Diagnostic Manager

...

  • The compatibility for Azure SQL Managed Instance with on-premises.
  • Elastic pools allow you to manage and scale multiple databases.
  • Single databases typically are used for development and small apps.

...

  • New alerts notify if the allocated resources are more than needed.
  • New displays for newly collected metrics.

...

11.0 Fixed Issues

Alerts

SQLDM-29184 SQL Diagnostic Manager now correctly alerts table fragmentation based on the table size configuration.

SQLDM-30421 The advanced Alert Filter for the "Longest Running version Store Transaction (Minutes)" alert is working as configured.

SQLDM-30487 The 'Clear Alert" option in the 'Availability Group Role Change' alert has been restored.

SQLDM-30528 SQLDM shows "Recommendations are available" operational alert in the Active Alert list.

SQLDM-30788 SQLDM Disk space alerts are now correctly triggering after an upgrade.

SQLDM-30825 The Disk Full alerts are no longer triggered for excluded disks in the alerts configuration.

SQLDM-30963 SQL Diagnostic Manager now correctly shows the correct alerts and thresholds for page life expectancy metric when using the Critical-Only Template.

SQLDM-31039 The "Show Historical View" button in the Alerts Tab is now working as expected.

Alert Response

SQLDM-29208 The 'Enable the Query Wait' Alert Action will properly execute when an Alert Response is triggered.

Availability Groups

SQLDM-30083 SQL Diagnostic Manager no longer encounters an error when removing an instance that happens to be a replica within an availability group.

SQLDM-30197 SQLDM now discovers preferred replica information from Availability Group settings.

Cloud Monitoring

SQLDM-30344 The notifications for blocked sessions and SQL Agent Job Failures when monitoring RDS instances are now working correctly.

Custom Counters

SQLDM-30385 The newly created custom counters are added to the existing templates and can be applied to new servers.

SQLDM-30524 The Custom Counter alerts when using T-SQL script are raising correctly.

Database

SQLDM-30575 The Database status is now displaying accurate status.

Extended Events

SQLDM-29005 SQLDM now correctly add new servers and allows to select 'Extended Events' as the collection method for the Activity Monitor.

SQLDM-29033 The performance of the query that collects Replication Statistics has been improved.

General

SQLDM-29384 SQL Diagnostic Manager now correctly monitors its own repository.

SQLDM-29408 SQLDM installation is now completing successfully when the service account credentials contain special characters.

SQLDM-30114 SQL Diagnostic Manager now correctly reports the Publisher Names for SQL Server 2016 SP2 or later.

SQLDM-30364 Desktop Console Views now correctly keeps the custom views.

SQLDM-30453 IDERA Newsfeed is correctly configured after installing SQL Diagnostic Manager.

SQLDM-30480 SQL Diagnostic Manager now correctly displays baselines.

SQLDM-30493 SQLDM Desktop console now correctly shows the critical SQL Server Service status.

SQLDM-30770 SQL Diagnostic Manager successfully checks SQL Browser Service Alert status when the Remote Administrative connection is disabled and there is only a default SQL Server instance installed.

SQLDM-30936 SQL Diagnostic Manager displays the correct information when you select a secondary tab.

SQLDM-31025 The pause button now correctly works and it is integrated with the refresh button.

SQLDM-31042 SQL Diagnostic Manager now correctly displays the "Session Details" grid.

SQLDM-31068 The Query History view under the Queries tab is working as expected.

SQLDM-31070 The "View Session Details" option is now correctly working.

SQLDM-31071 The "View Locks" option is now correctly working.

Graphs

SQLDM-29069 The 'Disk busy per disk' metric graph now correctly loads under the Disk option from the Resources tab.

SQLDM-30037 The blocking displayed in the reports and in the graphs are synced correctly.

SQLDM-30137 The Alert Configuration window is no longer displaying inaccurate threshold graphs.

Hyper-V

SQLDM-28327 SQL DM successfully connects to Hyper-V Host Configuration.

IDERA Dashboard

SQLDM-30032 SQLDM web console is no longer reporting FIPS compliant environment errors.

SQLDM-30260 The IDERA Dashboard login information is now correctly encrypted.

SQLDM-30350 The SQLDM Web Console no longer encounters exceptions when IDERA Dashboard and the monitored instances are in different time zones.

SQLDM-30526 The Overview tab in the web console is no longer displaying an exception when clicking the summary under the Active Alerts widget.

Maintenance Mode

SQLDM-30686 SQL Diagnostic Manager no longer erroneously reporting "Maintenance mode started" when maintenance mode has been disabled.

Notifications

SQLDM-30859 The Databases category metrics now correctly raise alerts and send email notifications.

Query Monitor

SQLDM-30397 SQLDM now correctly creates historical snapshots when Query Monitor is enabled and configured to use Query Store.

SQLDM-30664 Powerscript now successfully enables Query Monitor.

Reports

SQLDM-21051 SQLDM successfully runs SSRS reports when more than 126 instances are selected.

Services

SQLDM-28648 SQLDM successfully collects information for disk drives volume formatted in ReFS.

Upgrade

SQLDM-30170 After upgrading SQLDM from 10.3 to 10.4 version, the Queries tab now correctly loads information.

SQLDM-30312 SQLDM now correctly triggers and notifies alerts for the Session CPU Time after performing an upgrade.

...

Newtabfooter
aliasIDERA
urlhttp://www.idera.com

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver

...

Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore

...

Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/

...

Newtabfooter
aliasCommunity
urlhttp://community.idera.com

...

Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral

...

Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus

...

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.

    Info

    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

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

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

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

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

Status
colourGreen
titleSQLDM-30535
SQL Diagnostic Manager successfully generates the "Template Comparison" report.

Alerts

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

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

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

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

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

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

Status
colourGreen
titleSQLDM-31941
You can successfully configure e-mail notifications, including "and" conditions.

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

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

Status
colourGreen
titleSQLDM-28938
SQL Diagnostic Manager only displays the active alerts on the environment views.

Alerts Response

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

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

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

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

Custom Counters

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

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

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

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

General

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

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

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

DM Console

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

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

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

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

Status
colourGreen
titleSQLDM-32227
You can successfully export the Analyze report of a monitored instance.

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

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

On-Premises

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

IDERA Web Console

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

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

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

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

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

High Availability Groups

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

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

Upgrade

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

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

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

Status
colourGreen
titleSQLDM-32150
SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade.

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

DBaaS

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

Metrics

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

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

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

Charts

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

History Browser

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

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