Versions Compared

Old Version 36

changes.mady.by.user Alejandra Barrientos

Saved on

compared with

New Version 37

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.

...

12.

...

0 New Features

  • SQL Diagnostic Manager includes full support for Amazon RDS.
  • This release includes the completion of Amazon RDS alerts that were added in previous releases. These alerts include:
    • New alerts notify if the allocated resources are more than needed.
    • Added display for newly collected metrics.
  • New Interface User features include UI Scaling (support for 4K monitors and scaled fonts) and a new dark mode theme.
  • This version includes a new 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

  • performs Scale-out Architecture, including the following features:
    • Multiple DM Installations in a single DM Console
    • Targeting +2000 instances over four DM Installations
    • Full Administrative support for DMSO Cluster Environments
  • Connectivity and workability across untrusted domains using an Alternative Windows Collection Account.
  • Support Upgrades from existing Installations.

12.0 Fixed Issues

Reports

Status
colourGreen
titleSQLDM-30439
 When the Deadlock report is generated, SQLDM sends the email with the correct data.

Status
colourGreen
titleSQLDM-30657
The Disk Space History report is now correctly generated when selecting a "last 30 days" period.

Status
colourGreen
titleSQLDM-30887
SQL Diagnostic Manager added a synchronization state column to the Availability Group topology report.

Status
colourGreen
titleSQLDM-31171
The Deadlock Report includes all the collected data.

Status
colourGreen
titleSQLDM-31240
Custom Counters reports are now exported successfully.

Status
colourGreen
titleSQLDM-31386
 The Availability Group Statistics report works as expected. The report is generated within the expected time.

Status
colourGreen
titleSQLDM-31419
 The Deadlock report lists all the deadlocks and no deadlock is repeated.

Status
colourGreen
titleSQLDM-31452
Database Growth report now shows the correct data for the newly created database.

Status
colourGreen
titleSQLDM-31488
 The Add Custom Report wizard's UI works as expected.

Status
colourGreen
titleSQLDM-31518
 SQL Diagnostic Manager now successfully collects data for the Database Growth Forecast report.

Status
colourGreen
titleSQLDM-31606
 In the Overview Dashboard, the Lock Waits report correctly displays data for all the instances.

Status
colourGreen
titleSQLDM-31663
The Server Uptime report works as expected when selecting a server.


Alerts

Status
colourGreen
titleSQLDM-30461
 SQL Diagnostic Manager now successfully saves the "Where metric severity has changed" alert rule when the checked/unchecked condition is changed.

...

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

...

30768
SQL Diagnostic Manager now correctly generates the OS Privileged CPU and User CPU Usage alerts.

Status
colourGreen
titleSQLDM-30776
 SQL Diagnostic Manager now correctly generates the OS Privileged CPU and User CPU Usage alerts.

Status
colourGreen
titleSQLDM-2916130930
 The SQL Server Agent Job (Percent) metric correctly calculates the percentage value Filegroup Space Full (percent) and Log Full (percent) alerts are working as expected.

Status
colourGreen
titleSQLDM-30761
The 'Database Full (Percent) metric
31190
 The Blocking Session Wait Time (seconds) alert is working as expected when the Alert Suppression is configured. The date and time displayed are equal to the deadlock creation time.

Status
colourGreen
titleSQLDM-30764
 The default configuration of the "SQL Server Error Log" metric correctly applies the 10MB file size limit
31256
 Deadlock Alert Notification does not work as expected since it is not possible to configure.

Status
colourGreen
titleSQLDM-30770
 The SQL Server Browser metric is no longer raising alerts when only a default instance exists on the monitored server
31390
 The All Servers Thumbnail view works as expected when a server alert triggers a status change.

Status
colourGreen
titleSQLDM-30986
 The "
31341
 SQL DM now takes primary nodes instances to generate the Days since last backup" metric is no longer raising alerts for read-only databases that have been excluded from the metric alert, avoiding false alerts.

Status
colourGreen
titleSQLDM-31424
 The Session CPU Time(seconds) alert raises for on-premise instances.

Status
colourGreen
titleSQLDM-31110
 The SQL Server Agent Job Failure metric correctly raises alerts
31481
 The Filegroup Space Full (percent) and the Log full (percent) alerts work as expected.

Status
colourGreen
titleSQLDM-
31237
31485
 The "Days  Days since last backup" metric now correctly works in Availability Groups environments alert works as expected on secondary replicas (always on) instances.

Status
colourGreen
titleSQLDM-31537
 The Availability Group Estimated Data Loss (Seconds) triggers a Critical Alert after the Suppression Time alert and a warning Alert before the Suppression time alert.

Status
colourGreen
titleSQLDM-31597
 SQL Diagnostic Manager gets Baseline alerts successfully.

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.

...

31613
SQL Diagnostic Manager successfully notifies alerts for failed SQL Jobs by sending an email.

Status
colourGreen
titleSQLDM-31687
SQL Diagnostic Manager 11.1.6 now triggers the correct Days since last backup alerts.

Status
colourGreen
titleSQLDM-31651
 The File Group Space Full (Percentage) alert correctly reports within the expected parameters.

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
31675 
CPU Activity Percentage alert displays values under 100 when querying dbo.ServerStatistics database.tabase.

Status
colourGreen
titleSQLDM-29208
 Alert Response rules are now correctly starting Query-wait statistic collection as it was configured
31785
 SQL Diagnostic Manager now correctly triggers the Days since last backup alert for secondary replicas.

General

Status
colourGreen
titleSQLDM-30491
 SQL DM Repository does not use Deprecated Data Types anymore when SQL Server 2019 hosts it.

Status
colourGreen
titleSQLDM-31052
 SQL Diagnostic Manager successfully refreshes data of the selected server, keeping the original server name.

Status
colourGreen
titleSQLDM-31191
 SQL Diagnostic Manager allows selecting more than one-month of data across servers.

Status
colourGreen
titleSQLDM-3046531103
Users' permissions are now working as expected. Users with view access permissions cannot access all options in SQL Diagnostic Manager

Status
colourGreen
titleSQLDM-31199
 The History Browser Range is properly populated according to the selected time range.

Status
colourGreen
titleSQLDM-31100
 When adding a new server, the Advanced Encryption Options section shows the correct options to encrypt connections 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
31302
 SQL Diagnostic Manager server type remains unchanged after adding or updating the server.

Status
colourGreen
titleSQLDM-31332
 SQL Diagnostic Manager is no longer displaying the “Reading default instances failed:System.InvalidCastException" error when saving historical snapshots.

Status
colourGreen
titleSQLDM-3078231385
SQL  SQL Diagnostic Manager now raises alerts for Database Full (percent) metric in console when filtering by percentagesaves the configuration for the newly added Baseline.

Status
colourGreen
titleSQLDM-31449
When SQL Diagnostic Manager installation completes successfully, the Installshield Logs are deleted.

Status
colourGreen
titleSQLDM-31495
SQL DM is no longer raising unhandled exceptions when adding a server (Azure, Amazon, Windows).

Status
colourGreen
titleSQLDM-3096331500
 SQL DM now allows special characters for usernames or passwords.

Status
colourGreen
titleSQLDM-31528
The grooming is no longer filling the transaction log.

Status
colourGreen
titleSQLDM-31547
SQL Diagnostic Manager now installs the correct Native Client 2012 version 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
31582
SQL DM supports 4K resolution by successfully scaling and displaying screens, icons, and text.

Status
colourGreen
titleSQLDM-31536
SQL Diagnostic Manager is no longer prompting unhandled exceptions when launching.

Status
colourGreen
titleSQLDM-31061
 The advanced alert filter for the 'Data File Autogrowth' alert is now correctly excluding databases
31648
 Password values are masked in the 'SQLDMMasterInstaller.log'.

Status
colourGreen
titleSQLDM-31630
 After installing SQL Diagnostic Manager, the Connect to SQLDM Repository dialog pops up successfully to specify the location of your repository.

Status
colourGreen
titleSQLDM-31683
SQL Diagnostic Manager now collects plans as expected. Get them by clicking the Details. Note: The color icon does not change to green when a plan is collected.

Status
colourGreen
titleSQLDM-3129731831
SQL Diagnostic Manager automatically applies certain alert templates based on the server type of the monitored instance.

...

shows the correct supported version on the Server Wizard

Status
colourGreen
titleSQLDM-31827
 SQL Diagnostic Manager opens the properties window for unreachable instances in the expected time frame.

Database

Status
colourGreen
titleSQLDM-3006930775
 The Database widget under the Overview screen is now displaying data for the historical mode.refreshing time for the Database Summary and Availability Groups is shorter than before.

Status
colourGreen
titleSQLDM-30871
 The LastDatabaseCollectionTime database is successfully populated in the repository as well as in the console application with an offline database.

Status
colourGreen
titleSQLDM-31628
 The SQL Databases summary shows the right values for the Compatibility level column.

DM Console

Status
colourGreen
titleSQLDM-30083
Monitored instances are now correctly removed from
30869
SQL Diagnostic Manager shortened the loading times in the Queries view and you can properly navigate between tabs in DM console.

Status
colourGreen
titleSQLDM-30977
SQL Diagnostic Manager is no longer encountering an overflow error when a monitored SQL Server Agent Job is running longer than usual
31046
 SQL Diagnostic manager now works as expected when navigating across different instances tabs.

Status
colourGreen
titleSQLDM-31458
 SQL Diagnostic Manager Console only installer checks for the right .NET Framework.

Status
colourGreen
titleSQLDM-31517
SQL DM is no longer showing a refresh error when navigating to the Files Tab under the Database tab.

Status
colourGreen
titleSQLDM-31516
SQL DM is no longer showing a refresh error when navigating to the Disk Size Tab under the Resources tab.

Status
colourGreen
titleSQLDM-31515
SQL DM is no longer displaying a refresh error when navigating to the TempDB Summary Tab under the Databases tab.

Status
colourGreen
titleSQLDM-31818
After a closeout, SQL Diagnostic Manager keeps the servers added to the new custom views created in "My views".

Status
colourGreen
titleSQLDM-3103631844
 SQL SQL Diagnostic Manager Console works as expected when the Server View Refresh is set at 30 seconds for large environments.

Disks

Status
colourGreen
titleSQLDM-30998
Tempdb disks work as expected. They save the drive information of the monitored instance. Besides, the hostname name returns the server name on which the query runs.

Table

Status
colourGreen
titleSQLDM-30905
 After disabling replication statistic collection, replication on tables still happens.

Status
colourGreen
titleSQLDM-31410
 The ServerActivity table is no longer growing unexpectedly large.

Status
colourGreen
titleSQLDM-31453
SQL DM now successfully generates the reports and alerts for the fragmentation table.

Analysis

Status
colourGreen
titleSQLDM-31051
 The Analyze tab is working as expected is correctly sending OK status notifications and email notifications.

Status
colourGreen
titleSQLDM-3108031259
SQL Diagnostic Manager desktop console shows recommendations correctly when monitoring Azure SQLDB.

Status
colourGreen
titleSQLDM-31480
 SQL DM is no longer showing slow performance having issues when monitoring a large number a SQL server account is created by SQL dm Recommended Permissions on-premises script avoiding raising Probe Permission Violation Alerts and collecting OS data.

Status
colourGreen
titleSQLDM-31600
 The prescriptive analysis performs as expected for scheduled jobs.

Services

of instances.

Status
colourGreen
titleSQLDM-3109431099
SQLdmManagementService.exe successfully runs after upgrading SQL Diagnostic Manager 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.
31254
 The SQLdmCollectionService log now shows the expected logging information.

Status
colourGreen
titleSQLDM-31436
SQLdm Management service now successfully updates the repository.

IDERA Dashboard

Status
colourGreen
titleSQLDM-31202
SQLDM successfully applies new baselines' configuration to monitored instances.
31116
The IDERA Dashboard performance was improved and is working as expected.

High Availability Groups

Status
colourGreen
titleSQLDM-31146
The High Availability Groups successfully collect replication metrics, showing them in the Replication tab of the Server's Services view.

Status
colourGreen
titleSQLDM-31594
 Days since last backup works as expected on secondary replica (always on) instances.

Upgrade

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

...

now works as expected when upgrading to the latest version with SQL server 2005 instances.

Status
colourGreen
titleSQLDM-31692
 After upgrading to SQL DM 11.1.6, SQLDM shows correctly the main views ensuring its proper functioning.

Graphs

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

Availability Groups

31282
 SQL Diagnostic Manager now correctly displays the graphics from the Dashboard view.

Status
colourGreen
titleSQLDM-3051231486
SQL  SQL Diagnostic Manager now correctly monitors Availability Group servers with reading/write permissions.

...

displays the graph text fully, graphs have a gradient, and all databases are listed under the databases dropdown.

Status
colourGreen
titleSQLDM-31001
 The Disk Statistic report is
31801
The overview tab now correctly showing the total number of drives of a monitored serverdisplays the transactions per second graph.

DBaaS

Status
colourGreen
titleSQLDM-31357
 SQL Diagnostic Manager disables some metrics that Azure SQL DBaaS Template cannot monitor.

Status
colourGreen
titleSQLDM-3110631376
 When the user runs the report for CPU or Memory statistics selecting Show Baseline, it returns Actual and Baseline Stats The Dashboard of the Overview tab for Azure-managed instances now displays the network widget.

Status
colourGreen
titleSQLDM-31396
 Query Monitor works as expected. It collects no data for Azure SQL Instances when it is not enabled.

Status
colourGreen
titleSQLDM-31117
 The "Top Query" report now works successfully for all production servers
31467
 SQLDM now allows reconfiguring instances from Windows to AzureDB

Status
colourGreen
titleSQLDM-31571
 The Analysis Configuration view is available for RDS instances.

Status
colourGreen
titleSQLDM-31526
 Query Monitor successfully collects data on Azure SQL MI servers.

Status
colourGreen
titleSQLDM-31529
The BDaaS Metric Category has two new subcategories for Amazon RDS and Azure DB.

Status
colourGreen
titleSQLDM-31152
 The Database Growth Forecast report correctly categorizes system databases when using the database selector.

...

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

...

31554
 The Analyze features are now available for Azure SQL Instances.

Status
colourGreen
titleSQLDM-31679
 SQL Diagnostic manager now adds SQL Azure DBaaS instances and successfully refreshes its servers' alerts.

Status
colourGreen
titleSQLDM-31608
 SQL DM Console successfully traces sessions on monitored Azure Managed Instances.

Metrics

Status
colourGreen
titleSQLDM-31373 
The Filegroup Space Full(Percent) metric is no longer displaying false data.

Status
colourGreen
titleSQLDM-31450
 The SQL Server services metric status now works as expected.

Status
colourGreen
titleSQLDM-31494
 The Advanced Options window behaves as expected with all metrics.

Status
colourGreen
titleSQLDM-31604
The SQL Server CPU Usage (Percent) metric now reports within the expected values.

Status
colourGreen
titleSQLDM-31695
 SQL Diagnostic Manager now successfully saves the threshold values for the Oldest Open Transaction (minutes) metric.

Alert Response

Status
colourGreen
titleSQLDM-31477
 By default the metric Days since last backup is deselected in the Alert Configuration popup for cloud servers.

Status
colourGreen
titleSQLDM-31672
 SQL Diagnostic Manager now successfully triggers an Alert Response when all the custom counters are "Critical."

AlwaysOn

Status
colourGreen
titleSQLDM-31473
 Monitored AlwaysOn servers are successfully contacted, making the AlwaysOn Listener - DB accessible.

Queries

Status
colourGreen
titleSQLDM-31435
 Query Details are displayed by clicking the globe icon on Statement Mode and Signature Mode.

Status
colourGreen
titleSQLDM-31566
The Queries tab gets Data loaded faster than before.

Replication

Status
colourGreen
titleSQLDM-31462
 SQLDM allows monitoring Services from the Replication tab.

Status
colourGreen
titleSQLDM-31300
 SQL Diagnostic Manager now displays the correct Topology Replication data.

Template

Status
colourGreen
titleSQLDM-31303
  SQL Diagnostic Manager works as expected while attempting to apply a template to a monitored instance.

Status
colourGreen
titleSQLDM-31602
 By default, SQL DM automatically selects a template in the Add Servers Wizard.