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

Compare with Current View Page History

« Previous Version 54 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, SQL Diagnostic Manager sends the email with the correct data.

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

Alerts

SQLDM-30461 Database Full (Percent) alert is woking as expected, it is not displaying false data.

SQLDM-30461 SQL Diagnostic Manager now successfully saves the Where metric severity has changed condition when it is checked or unchecked.

SQLDM-30768 SQL Diagnostic Manager correctly monitors the servers and SQLDM Management service memory consumption is as expected.

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

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-31390 The All Servers Thumbnail view works as expected when a server alert triggers a status change.

SQLDM-31341 SQL Diagnostic Manager 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-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.

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-31785 SQL Diagnostic Manager now correctly triggers the Days since last backup alert for secondary replicas.

General

SQLDM-28362 SQL Diagnostic Manager now correctly detects the drives with WMI and OLE automation for added local instances.

SQLDM-30364 Desktop Console view keeps custom views changes after adding servers.

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-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 warnings 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 alert works as expected on secondary replica (always on) instances.

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

SQLDM-31646 Availability Group snapshots displays without any error message.

Upgrade

SQLDM-30360 The Aggregate Data SQLdmRepository works as expected after upgrading SQLDM to 10.4.2.20.

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-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-30332The correct value of the OS memory usage metric now displays in the dashboard graph and in the alert configuration.

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 with suppression value.

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 Days since last backup metric 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-25488 SQL Diagnostic Manager does not show the 'Key already exists' exception anymore when columns are modified in the Event Occurrences Grid of the Query view's Signature Mode tab

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

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

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

SQLDM-31642 The Queries view loads faster and work as expected.

Query Waits

SQLDM-29645 SQL Diagnostic Manager is loading correctly when Query Waits uses Extended Events.

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.

History Browser

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



  • No labels