Versions Compared

Old Version 33

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 34

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.

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.

...

11.1 New Features

  • SQL Diagnostic Manager includes full support for Azure SQL. This feature includes the following resources for the Azure SQL database:
    • 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.
    Amazon RDS.
  • This release includes the completion of Azure SQL Amazon RDS alerts that were added in previous releases. Among other features, these These alerts include:
  • New alerts notify if the allocated resources are more than needed.
  • New displays Added display for newly collected metrics.
  • New alert templates with revised thresholds and priority/rank specifically for DBaaS (Azure SQL and Amazon RDS)Interface User features include UI Scaling (support for 4K monitors and scaled fonts) and a new dark mode theme.
  • This version includes a new server wizard that uses Azure profile credentials, allowing you to discover other Azure DB assets.
  • Azure profile credentials collect metrics from Azure monitor to extend SQL Diagnostic Manager.
  • Prescriptive Analytics improvements, including new recommendations for Azure SQL DBaaS and Amazon RDS.

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.

  • Heatmap view and Grid view improvements for monitored servers in the desktop console.
  • Amazon RDS SQL Alerts and Alert Templates improvements.
  • Prescriptive Analitycs improvements for Amazon RDS monitored servers.

11.1 Fixed Issues

History Browser

Status
colourGreen
titleSQLDM-29103
 The History Browser returns query results within a 60-seconds time frame

Metrics

Status
colourGreen
titleSQLDM-29161
 The SQL Server Agent Job (Percent) metric correctly calculates the percentage value.

Status
colourGreen
titleSQLDM-30761
 The 'Database Full (Percent)' metric is working as expected when the Alert Suppression is configured.

Status
colourGreen
titleSQLDM-30764
 The default configuration of the "SQL Server Error Log" metric correctly applies the 10MB file size limit.

Status
colourGreen
titleSQLDM-30770
 The SQL Server Browser metric is no longer raising alerts when only a default instance exists on the monitored server.

Status
colourGreen
titleSQLDM-30986
 The "Days since last backup" metric is no longer raising alerts for read-only databases that have been excluded from the metric.

Status
colourGreen
titleSQLDM-31110
 The SQL Server Agent Job Failure metric correctly raises alerts as expected.

Status
colourGreen
titleSQLDM-31237
 The "Days since last backup" metric now correctly works in Availability Groups environments.

Status
colourGreen
titleSQLDM-31239
 The SQL Server Agent Status metric correctly returns to an OK state when the service is detected to have been started.

Alerts

Status
colourGreen
titleSQLDM-29189
 The "The deadlock victim was spid 0 with application name 'unknown' by user 'unknown' on host 'unknown" alerts are no longer displaying.

Status
colourGreen
titleSQLDM-29208
 Alert Response rules are now correctly starting Query-wait statistic collection as it was configured.

Status
colourGreen
titleSQLDM-30465
 Corrected various issues with the Deadlock graphs and Alerts view within the SQLDM Web Console.

Status
colourGreen
titleSQLDM-30502
 Fragmentation alerts are triggering successfully after performing an upgrade.

Status
colourGreen
titleSQLDM-30782
 SQLDM now raises alerts for Database Full (percent) metric in console when filtering by percentage.

Status
colourGreen
titleSQLDM-30963
 The alert for the "Page Life Expectancy" metric now takes the correct thresholds showing the right alerts.

Status
colourGreen
titleSQLDM-30973
 The advanced "filter by percentage" option correctly raises alerts as expected.

Status
colourGreen
titleSQLDM-31061
 The advanced alert filter for the 'Data File Autogrowth' alert is now correctly excluding databases.

Status
colourGreen
titleSQLDM-31297
 SQLDM automatically applies certain alert templates based on the server type of the monitored instance.

General

Status
colourGreen
titleSQLDM-30069
 The Database widget under the Overview screen is now displaying data for the historical mode.

Status
colourGreen
titleSQLDM-30083
 Monitored instances are now correctly removed from SQLDM.

Status
colourGreen
titleSQLDM-30977
 SQLDM is no longer encountering an overflow error when a monitored SQL Server Agent Job is running longer than usual.

Status
colourGreen
titleSQLDM-31036
 SQL Diagnostic Manager is correctly sending OK status notifications and email notifications.

Status
colourGreen
titleSQLDM-31080
 SQLDM desktop console is no longer showing slow performance when monitoring a large number of instances.

Status
colourGreen
titleSQLDM-31094
 SQLDM correctly applies baseline settings to other monitored instances.

Status
colourGreen
titleSQLDM-31198
 Customized Dashboards in the SQLDM Desktop Client are now correctly saved in the repository database.

Status
colourGreen
titleSQLDM-31202
SQLDM successfully applies new baselines' configuration to monitored instances.

Status
colourGreen
titleSQLDM-31420
 Now SQL Diagnostic Manager successfully shows paging graphics in the Memory Screen of the Resources tab.

Services

Status
colourGreen
titleSQLDM-30435
 Improved the stability of the SQLDM Management Service.

Availability Groups

Status
colourGreen
titleSQLDM-30512
 SQLDM now correctly monitors Availability Group servers with read/write permissions.

Reports

Status
colourGreen
titleSQLDM-31001
 The Disk Statistic report is now correctly showing the total number of drives of a monitored server.

Status
colourGreen
titleSQLDM-31106
 When the user runs the report for CPU or Memory statistics selecting Show Baseline, it returns Actual and Baseline Stats.

Status
colourGreen
titleSQLDM-31117
 The "Top Query" report now works successfully for all production servers.

Status
colourGreen
titleSQLDM-31152
 The Database Growth Forecast report correctly categorizes system databases when using the database selectorSQLDM-30312 SQLDM now correctly triggers and notifies alerts for the Session CPU Time after performing an upgrade.



Scroll pdf ignore
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
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse