Versions Compared

Key

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

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

12.

...

2 New Features

  • SQL Diagnostic Manager 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, SQL Diagnostic Manager sends the email with the correct data.

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

  • offers a brand-new browser interface framework, called SQLDM Web Console, offering:
    • Highly responsive user experience.
    • Light Mode and Dark Mode options.
    • Context-Aware Interface for Mobile and Tablet support.
    • Simplified single-product focus built on a common design but not sharing on a single product.
    • Flexible design to easily update third-party components.
    • Consolidated interface gathering together SQLDM Mobile, SQLDM IDERA Dashboard, and Windows Client. 
Info
titleIDERA Dasboard support

The prior browser interface for SQL Diagnostic Manager in IDERA Dashboard will continue to be supported in addition to the new SQLDM browser interface.  However, it is no longer part of the SQL Diagnostic Manager installation or the preferred browser interface for SQL Diagnostic Manager.  If you wish to continue using IDERA Dashboard, you can install it separately and manually register SQL Diagnostic Manager.

12.2 Fixed Issues

Reports

Status
colourGreen
titleSQLDM-3117131830
The Deadlock report includes all the collected dataTop Servers by Percent Usage report correctly displays CPU SQL Usage (Percent) values.

Status
colourGreen
titleSQLDM-31240
Custom Counters reports are now exported successfully
31668
 SQL Diagnostic Manager now successfully exports the Plan XML (Estimated) report from the Event Occurrences detail view.

Status
colourGreen
titleSQLDM-3138631663
 The Availability Group Statistics report works as expected. The report is generated within the expected timeServer Uptime report pops up a "Select SQL Server" message when you do not select a server, otherwise, it works as expected.

Status
colourGreen
titleSQLDM-31419
 The Deadlock report lists all the deadlocks and no deadlock is repeated
31639
  SQL Diagnostic Manager correctly gathers, stores, and reports Database Statistics.

Status
colourGreen
titleSQLDM-31488
 The Add Custom report wizard's UI works as expected
31543
 SQL Diagnostic Manager 12.2 correctly generates the Enterprise Summary reports including the SQL Server version of your instances.

Status
colourGreen
titleSQLDM-31518
 SQL Diagnostic Manager now successfully collects data for the
31452
  The Database Growth Forecast report is correctly generated.

Status
colourGreen
titleSQLDM-31606
 In the Overview Dashboard, the Lock Waits report correctly displays data for all the
30663
  The Disk Space History report correctly lists the disk available on the monitored instances.

Alerts

Status
colourGreen
titleSQLDM-

...

30657
  The Disk Space History report is correctly generated for seven, 15, and 30 days.

Status
colourGreen
titleSQLDM-30461
SQL Diagnostic Manager now successfully saves the Where metric severity has changed condition when it is checked or unchecked.
30497
  The Transaction Log statistics successfully return historical data.

Alerts

Status
colourGreen
titleSQLDM-30768 31924
SQL Diagnostic Manager correctly monitors the servers and SQLDM Management service memory consumption is as expected12.2 correctly triggers email notifications for Database Full (Percent) and Filegroup Full Space (Percent) alerts.

Status
colourGreen
titleSQLDM-3077631848
 SQL Diagnostic Manager now correctly generates the OS Privileged CPU and User CPU Usage alerts.
Status
colourGreen
titleSQLDM-30930
The Filegroup Space Full (percent) and Log Full (percent) alerts are working as expected when the database is set to 'no autogrowth' and the alerts configuration is set to 'Yes, alert con the currently used size divided by the maximum possible size'12.2 successfully triggers email notifications for Log Full (Percent) alerts.

Status
colourGreen
titleSQLDM-31190
 The Blocking Session Wait Time (seconds) alert is working as expected. The date and time displayed are equal to the deadlock creation
31791
  The Blocked Sessions alert is successfully triggered in the configured response alert time.

Status
colourGreen
titleSQLDM-31390
 The All Servers Thumbnail view works as expected when a server alert triggers a status change.
31721
  SQL Diagnostic Manager successfully triggers the Unsubscribed Transactions (Seconds) alert once is configured and enabled
Status
colourGreen
titleSQLDM-31341
SQL Diagnostic Manager now takes primary nodes instances to generate the Days since last backup alert, avoiding false alerts.

Status
colourGreen
titleSQLDM-3142431676
 The Session CPU Time(seconds) alert raises for on-premise instances. StatuscolourGreentitleSQLDM-31439 When a job exceeds the time limit, the SQL Server Agent Long Running Job (Percent) alert raises. If the job is stopped, completed, or canceled the alert is deactivated.CPU Statistics report correctly shows trends for CPU usage, displaying the correct values for the CPUActivityPercentange alert. 

Status
colourGreen
titleSQLDM-31481
 The Filegroup Space Full (percent) and the Log full (percent) alerts work as expected.

Status
colourGreen
titleSQLDM-31485
 Days since last backup alert works as expected on secondary replicas (AlwaysOn) instances.

31654
 SQL Diagnostic Manager allows you to clear the recommendation alerts from the Alert Recommendation window until it raises again
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-3159731501
 SQL Diagnostic Manager gets Baseline alerts successfullyallows you to snooze operational alerts but not clear them from recommendations.

Status
colourGreen
titleSQLDM-31613
SQL Diagnostic Manager successfully notifies alerts for failed SQL Jobs by sending an email
31251
 The Alert Configuration timeout value has been changed to get better performance.

Status
colourGreen
titleSQLDM-3168731147
SQL  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 parametersnow correctly generates Blocking alerts and reports.

Status
colourGreen
titleSQLDM-3178531045
 SQL Diagnostic Manager now correctly triggers the Days since last backup alert for secondary replicas.

...

excludes databases from the Days Since Last Backup metric when exclusions are defined.

Status
colourGreen
titleSQLDM-2836231004
SQL  SQL Diagnostic Manager now correctly detects the drives with WMI and OLE automation for added local instances. StatuscolourGreentitleSQLDM-30364 Desktop Console view keeps custom views changes after adding servers.

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 namemonitors the status of the DTC service.

Status
colourGreen
titleSQLDM-3119129420
 SQL Diagnostic Manager allows selecting more than one-month of data across servers.dismisses Availability Group Role Change alerts correctly.

General

Status
colourGreen
titleSQLDM-31103
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.

31601
SQL Diagnostic Manager no longer generates the "Unhandled exception: SplitterDistance must be between Panel1MinSize and Width - Panel2MinSize" when using the desktop client under certain screen resolutions.

DM Console

Status
colourGreen
titleSQLDM-31100
 When adding a new server, the Advanced Encryption Options section shows the correct options to encrypt connections.
32041
 Users can now successfully add an existing user from one cluster to another while maintaining the original security settings
Status
colourGreen
titleSQLDM-31302
 SQL Diagnostic Manager server type remains unchanged after adding or updating the server.

Status
colourGreen
titleSQLDM-3133232029
 SQL Diagnostic Manager is no longer displaying the “Reading default instances failed:System.InvalidCastException" error when saving historical snapshots.allows you to correctly check the licensed SQL Server instances in the Manage Servers window.

Status
colourGreen
titleSQLDM-3138532015
 SQL Diagnostic Manager now saves the configuration for the newly added Baseline  SQL Diagnostic Manager console works as expected with more than 100 servers registered.

Status
colourGreen
titleSQLDM-3144931967
When   SQL Diagnostic Manager installation completes successfully, the Installshield Logs are deletedcan now successfully enable/disable Maintenance modes using Tags.

Status
colourGreen
titleSQLDM-31495
SQL DM is no longer raising unhandled exceptions when adding a server (Azure, Amazon, Windows)
31950
  The Tags view displays data with more than 100 created tags.

Status
colourGreen
titleSQLDM-31500
 SQL DM now allows special characters for usernames or passwords.
Status
colourGreen
titleSQLDM-31528
The grooming is no longer filling the transaction log
31833
 The Add Server Wizard now saves the Query Monitor settings when the SQL Server instance is added.

Status
colourGreen
titleSQLDM-3154731819
SQL  SQL Diagnostic Manager now installs the correct Native Client 2012 version.
Status
colourGreen
titleSQLDM-31582
SQL DM supports 4K resolution by successfully scaling and displaying screens, icons, and text12.2 successfully connects to monitored SQL servers after the KB5004442 Microsoft patch has been applied.

Status
colourGreen
titleSQLDM-3153631709
  The SQL Diagnostic Manager is Management Service no longer prompting unhandled exceptions when launching.
Status
colourGreen
titleSQLDM-31648
 Password values are masked in the 'SQLDMMasterInstaller.log'crashes when there are more than one SNMP action provider configured.

Status
colourGreen
titleSQLDM-3163031469
 After installing   SQL Diagnostic Manager , the Connect to SQLDM Repository dialog pops up successfully to specify the location of your repository.
Status
colourGreen
titleSQLDM-31831
SQL Diagnostic Manager shows the correct supported version on the Server Wizard12.2 response time has been improved.

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

Database

Status
colourGreen
titleSQLDM-30775
 The 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.

...

's recommendation engine has been updated to include additional recommendations found in SQL Doctor.

Status
colourGreen
titleSQLDM-3086931012
  The SQL Diagnostic Manager shortened the loading times in the Queries view and you can properly navigate between tabs in DM consolerepository database now supports 2012 and higher compatibility levels.

Status
colourGreen
titleSQLDM-3104628750
 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.

Manager correctly displays the session status of ROLLBACK after a session is killed.

Disks

Status
colourGreen
titleSQLDM-31818
After a closeout, SQL Diagnostic Manager keeps the servers added to
30895
  SQL Diagnostic Manager now successfully displays Disk Activity information for cluster shared volume drives (CSVFS) databases.

Table

the new custom views created in "My views".

Status
colourGreen
titleSQLDM-3184431457
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.

correctly populates the list of mount points on the monitored instances.

Analysis

...

Status
colourGreen
titleSQLDM-30905
Disabling Collection of Replication Statistics feature is now working correctly.

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.

Status
colourGreen
titleSQLDM-31259
SQL Diagnostic Manager shows recommendations correctly when monitoring Azure SQLDB.

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

31554
 You can now successfully perform the Analysis Status of Azure instances
Status
colourGreen
titleSQLDM-31600
 The prescriptive analysis performs as expected for scheduled jobs.

Services

Status
colourGreen
titleSQLDM-31099
SQLdmManagementService.exe successfully runs after upgrading SQL Diagnostic Manager.

Status
colourGreen
titleSQLDM-31254
 The SQLdmCollectionService log now shows the expected logging information.

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

IDERA Dashboard

31588
 SQL Diagnostic Manager services perform successfully, making it possible that the Aggregation and Grooming jobs to work
Status
colourGreen
titleSQLDM-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 alert works as expected on secondary replica (always on) instances
31972
The Long Send Rate (KB/s) metric now works as expected in High Availability Groups.

Status
colourGreen
titleSQLDM-31473
 Monitored AlwaysOn servers are successfully contacted, making the AlwaysOn Listener - DB accessible.
30194
The Availability Group History browser successfully displays the replica role status on particular instances
Status
colourGreen
titleSQLDM-31646
Availability Group snapshots displays without any error message.

Upgrade

Status
colourGreen
titleSQLDM-3036031623
The Aggregate Data SQLdmRepository works as expected after upgrading SQLDM to 10.4.2.20.

Status
colourGreen
titleSQLDM-31186
SQL Diagnostic Manager 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-31282
 SQL Diagnostic Manager now correctly displays the graphics from the Dashboard view.

Status
colourGreen
titleSQLDM-31486
 SQL Diagnostic Manager now displays the graph text fully, graphs have a gradient, and all databases are listed under the databases dropdown.

Status
colourGreen
titleSQLDM-31801
The overview tab now correctly displays the transactions per second graph.

user can successfully add a new user after upgrading SQL Diagnostic Manager. 

DBaaS

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

Status
colourGreen
titleSQLDM-31376
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  SQL Diagnostic Manager no longer generates sys.availability_group_listeners  errors when monitoring Azure SQL Databases.

Status
colourGreen
titleSQLDM-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-31679
 SQL Diagnostic manager now adds SQL Azure DBaaS instances and successfully refreshes its servers' alerts.

31474
 Forecast alerts are successfully generated for Azure Manage Instance and Azure SQL Databases
Status
colourGreen
titleSQLDM-31608
 SQL DM Console successfully traces sessions on monitored Azure Managed Instances.

Metrics

Status
colourGreen
titleSQLDM-30332
The correct value of the OS memory usage metric now displays in the dashboard graph and in the alert configuration.
Status
colourGreen
titleSQLDM-31373 
The
31946
 SQL Diagnostic Manager correctly reports the correct values for the SQL Server Usage 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 with suppression value
31556
 SQL Memory Usage metric correctly calculates the percentage of the total memory used by Azure SQL servers.

Status
colourGreen
titleSQLDM-31494
 The Advanced Options window behaves as expected with all metrics.
Status
colourGreen
titleSQLDM-31604
The SQL Server CPU Usage
31298
 SQL Server Agent Long Running Job (Percent) metric now reports within the expected values.provides the correct value.

Queries

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

...

correctly associates query data to the correct monitored instance.

Status
colourGreen
titleSQLDM-31477
By default, the Days since last backup metric 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.

...

31846
 SQL Diagnostic Manager successfully gathers query data through Query Monitor on instances containing databases that have a trailing space in the database name.

Status
colourGreen
titleSQLDM-31435
 Query Details are displayed by clicking the globe icon on Statement Mode and Signature Mode. StatuscolourGreentitleSQLDM-31540 SQL Diagnostic Manager now includes two options to collect session data for SQL Server: Collect extended data from session details and Collect extended data from locks and blocks
31552
 SQL Diagnostic Manager allows you to successfully refresh your data in any Query View.

Status
colourGreen
titleSQLDM-31566
The Queries tab gets data loaded faster than before
31365
 Users can now successfully configure the Query monitoring on any environment.

Status
colourGreen
titleSQLDM-31642
The Queries view loads faster and work as expected.

Query Waits

...

30967
 SQL Diagnostic Manager successfully provides Query Plans. You can fetch them by clicking on the green icons of the Detail column of the Event Occurrences table

Replication

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

Status
colourGreen
titleSQLDM-31300
SQL Diagnostic Manager now displays the correct Replication Topology 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.

History Browser

Status
colourGreen
titleSQLDM-3119930840.
The History Browser Range is properly populated according to the selected time range  History Browser successfully changes the custom settings when moved to other servers.