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 (always on) 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.
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."
AlwaysOn
SQLDM-31473 Monitored AlwaysOn servers are successfully contacted, making the AlwaysOn Listener - DB accessible.
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 Topology Replication 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.