You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 40 Next »

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

12.0 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

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

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

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

SQLDM-31171 The Deadlock Report includes all the collected data.

SQLDM-31240 Custom Counters reports are now exported successfully.

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

SQLDM-31419 The Deadlock report lists all the deadlocks and no deadlock is repeated.

SQLDM-31452 Database Growth report now shows the correct data for the newly created database.

SQLDM-31488 The Add Custom Report wizard's UI works as expected.

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

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

SQLDM-31663 The Server Uptime report works as expected when selecting a server.

Alerts

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

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

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

SQLDM-30930 The Filegroup Space Full (percent) and Log Full (percent) alerts are working as expected.

SQLDM-31190 The Blocking Session Wait Time (seconds) alert is working as expected. The date and time displayed are equal to the deadlock creation time.

SQLDM-31256 Deadlock Alert Notification does not work as expected since it is not possible to configure.

SQLDM-31390 The All Servers Thumbnail view works as expected when a server alert triggers a status change.

SQLDM-31341 SQL DM now takes primary nodes instances to generate the Days since last backup alert, avoiding false alerts.

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

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

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

SQLDM-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.

SQLDM-31597 SQL Diagnostic Manager gets Baseline alerts successfully.

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

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

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

SQLDM-31675  CPU Activity Percentage alert displays values under 100 when querying dbo.ServerStatistics database.tabase.

SQLDM-31785 SQL Diagnostic Manager now correctly triggers the Days since last backup alert for secondary replicas.

General

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

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

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

SQLDM-31103 Users' permissions are now working as expected. Users with view access permissions cannot access all options in SQL Diagnostic Manager

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

SQLDM-31100 When adding a new server, the Advanced Encryption Options section shows the correct options to encrypt connections.

SQLDM-31302 SQL Diagnostic Manager server type remains unchanged after adding or updating the server.

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

SQLDM-31385 SQL Diagnostic Manager now saves the configuration for the newly added Baseline.

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

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

SQLDM-31500 SQL DM now allows special characters for usernames or passwords.

SQLDM-31528 The grooming is no longer filling the transaction log.

SQLDM-31547 SQL Diagnostic Manager now installs the correct Native Client 2012 version.

SQLDM-31582 SQL DM supports 4K resolution by successfully scaling and displaying screens, icons, and text.

SQLDM-31536 SQL Diagnostic Manager is no longer prompting unhandled exceptions when launching.

SQLDM-31648 Password values are masked in the 'SQLDMMasterInstaller.log'.

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

SQLDM-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.

SQLDM-31831 SQL Diagnostic Manager shows the correct supported version on the Server Wizard

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

Database

SQLDM-30775 The refreshing time for the Database Summary and Availability Groups is shorter than before.

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

SQLDM-31628 The SQL Databases summary shows the right values for the Compatibility level column.

DM Console

SQLDM-30869 SQL Diagnostic Manager shortened the loading times in the Queries view and you can properly navigate between tabs in DM console.

SQLDM-31046 SQL Diagnostic manager now works as expected when navigating across different instances tabs.

SQLDM-31458 SQL Diagnostic Manager Console only installer checks for the right .NET Framework.

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

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

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

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

SQLDM-31844 SQL Diagnostic Manager Console works as expected when the Server View Refresh is set at 30 seconds for large environments.

Disks

SQLDM-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

SQLDM-30905 Disabling Collection of Replication Statistics feature is now working correctly.

SQLDM-31410 The ServerActivity table is no longer growing unexpectedly large.

SQLDM-31453 SQL DM now successfully generates the reports and alerts for the fragmentation table.

Analysis

SQLDM-31051 The Analyze tab is working as expected.

SQLDM-31259 SQL Diagnostic Manager shows recommendations correctly when monitoring Azure SQLDB.

SQLDM-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 Alerts and collecting OS data.

SQLDM-31600 The prescriptive analysis performs as expected for scheduled jobs.

Services

SQLDM-31099 SQLdmManagementService.exe successfully runs after upgrading SQL Diagnostic Manager.

SQLDM-31254 The SQLdmCollectionService log now shows the expected logging information.

SQLDM-31436 SQLdm Management service now successfully updates the repository.

IDERA Dashboard

SQLDM-31116 The IDERA Dashboard performance was improved and is working as expected.

High Availability Groups

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

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

SQLDM-31473 Monitored AlwaysOn servers are successfully contacted, making the AlwaysOn Listener - DB accessible.

Upgrade

SQLDM-31186 SQL Diagnostic Manager now works as expected when upgrading to the latest version with SQL server 2005 instances.

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

Graphs

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

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

SQLDM-31801 The overview tab now correctly displays the transactions per second graph.

DBaaS

SQLDM-31357 SQL Diagnostic Manager disables some metrics that Azure SQL DBaaS Template cannot monitor.

SQLDM-31376 The Dashboard of the Overview tab for Azure-managed instances now displays the network widget.

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

SQLDM-31467 SQLDM now allows reconfiguring instances from Windows to AzureDB

SQLDM-31571 The Analysis Configuration view is available for RDS instances.

SQLDM-31526 Query Monitor successfully collects data on Azure SQL MI servers.

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

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

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

SQLDM-31608 SQL DM Console successfully traces sessions on monitored Azure Managed Instances.

Metrics

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

SQLDM-31450 The SQL Server services metric status now works as expected.

SQLDM-31494 The Advanced Options window behaves as expected with all metrics.

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

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

Alert Response

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

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

Queries

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

SQLDM-31566 The Queries tab gets data loaded faster than before.

Replication

SQLDM-31462 SQLDM allows monitoring Services from the Replication tab.

SQLDM-31300 SQL Diagnostic Manager now displays the correct Replication Topology data.

Template

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

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


  • No labels