SQL Diagnostic Manager provides the following new features and fixed issues.
12.
...
3 New Features
SQL Diagnostic Manager
...
presents 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
...
and enhancements:
- An Improved User Interface with the following changes:
- A new organization Grid View which allows a better glance at your instance metrics and properties.
- An updated Windows Console Grid View similar to SQL Diagnostic Web Console.
- A renovated Card View style, providing you with the same reliable information with a better-summarized look.
- An improved administration dialog to change the scale Health Index Factor for SQL Diagnostic Manager Console.
- A new Search feature for handling long lists across your servers, filters, alerts, and more.
A Step Forward or Backward with the drill-down option.
Info |
---|
Administrative actions are not included, only the actions associated with drill-downs are maintained. |
- A new Automated Responses for ServiceNow action providers. To configure it, you must provide the Service Now information such as URL, Username, Password, and Alert Source.
12.3 Fixed Issues
Reports
12.0 Fixed Issues
Reports
Status |
---|
colour | Green |
---|
title | SQLDM-30439 |
---|
|
When the Deadlock report is generated, SQLDM sends the email with the correct data. Status |
---|
colour | Green |
---|
title | SQLDM-30657 |
---|
|
The Disk Space History report is now correctly generated when selecting a "last 30 days" period. Status |
---|
colour | Green |
---|
title | SQLDM-30887 |
---|
|
SQL Diagnostic Manager added a synchronization state column to the Availability Group topology report. Status |
---|
colour | Green |
---|
title | SQLDM-31171 |
---|
|
The Deadlock Report includes all the collected data. Status |
---|
colour | Green |
---|
title | SQLDM-31240 |
---|
|
Custom Counters reports are now exported successfully. Status |
---|
colour | Green |
---|
title | SQLDM-31386 |
---|
|
The Availability Group Statistics report works as expected. The report is generated within the expected time The "Server Uptime" report records the correct values for the uptime and downtime of a specific instance.31419The Database Statistics report is now generating data correctly for a custom range of time The Deadlock report lists all the deadlocks and no deadlock is repeated.
31452 The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager Database Growth report now shows the correct data for the newly created database.
31488 SQL Diagnostic Manager correctly identifies query records where query plans have been successfully collected The Add Custom Report wizard's UI works as expected.
31518 SQL SQL Diagnostic Manager now successfully collects data for the Database Growth Forecast generates the "Template Comparison" report.
Alerts
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-31606 |
---|
|
In the Overview Dashboard, the Lock Waits report correctly displays data for all the instances. Status |
---|
colour | Green |
---|
title | SQLDM-31663 |
---|
|
The Server Uptime report works as expected when selecting a server.Alerts
SQL Diagnostic Manager accurately displays alert data in the Historical Snapshots tooltip for a specific instance. Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-3046132347 |
---|
|
SQL SQL Diagnostic Manager
now successfully saves correctly applies the "
Where metric severity has changed is in place" alert rule
when the checked/unchecked condition is changed.
30768 The default value for the user field under the "Alternative Windows Authorization" feature is Blank now SQL Diagnostic Manager now correctly generates the OS Privileged CPU and User CPU Usage alerts.
30776 The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds SQL Diagnostic Manager now correctly generates the OS Privileged CPU and User CPU Usage alerts.
30930 The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully The Filegroup Space Full (percent) and Log Full (percent) alerts are working as expected.
31190 SQL Diagnostic Manager provides all the information of the The Blocking Session Wait Time (secondsSeconds) alert is working as expected. The date and time displayed are equal to the deadlock creation time.when enabling Capture Blocking (SQL 2005+).
31256 Deadlock Alert Notification does not work as expected since it is not possible to configure. You can successfully configure e-mail notifications, including "and" conditions
Status |
---|
colour | Green |
---|
title | SQLDM-31390 |
---|
|
The All Servers Thumbnail view works as expected when a server alert triggers a status change.31341 SQL DM now takes primary nodes instances to generate the Days since last backup alert, avoiding false alerts.
Status |
---|
colour | Green |
---|
title | SQLDM-31424 |
---|
|
The Session CPU Time(seconds) alert raises for on-premise instances. You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3
Status |
---|
colour | Green |
---|
title | SQLDM-31481 |
---|
|
The Filegroup Space Full (percent) and the Log full (percent) alerts work as expected.31485 The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details Days since last backup alert works as expected on secondary replicas (always on) instances.
Status |
---|
colour | Green |
---|
title | 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.31597 SQL SQL Diagnostic Manager gets Baseline alerts successfully.only displays the active alerts on the environment views.
Alerts Response
Status |
---|
colour | Green |
---|
title | SQLDM-3161332215 |
---|
|
SQL Diagnostic Manager successfully notifies alerts for failed SQL Jobs by sending an emailimproved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule.31687 After upgrading to SQLDM 12, SQL Diagnostic Manager 11.1.6 now triggers the correct Days since last backup alerts.
Status |
---|
colour | Green |
---|
title | SQLDM-31651 |
---|
|
The File Group Space Full (Percentage) alert correctly reports within the expected parametersmaintains the "Email (SMTP) Provider" alert response configuration.31675 CPU Activity Percentage alert displays values under 100 when querying dbo.ServerStatistics database.tabase With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider.
31785 SQL Diagnostic Manager now correctly triggers the Days since last backup alert for secondary replicas.
...
You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.
Custom Counters
30491 SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations SQL DM Repository does not use Deprecated Data Types anymore when SQL Server 2019 hosts it.
31052 SQL SQL Diagnostic Manager successfully refreshes data of the selected server, keeping the original server nameapplies Custom Counter in new Servers when using templates.
31191 SQL Diagnostic Manager allows selecting more than one-month of data across servers.and applying custom counters to all servers when creating metric alert responses for cluster environments.
31103 Users' permissions are now working as expected. Users with view access permissions cannot access all options in SQL Diagnostic Manager
Status |
---|
colour | Green |
---|
title | SQLDM-31199 |
---|
|
The History Browser Range is properly populated according to the selected time range. Status |
---|
colour | Green |
---|
title | SQLDM-31100 |
---|
|
...
When using the SQL Diagnostic Manager manual Maintenance Mode, the instances remain linked to Custom Counters.
General
Status |
---|
colour | Green |
---|
title | SQLDM-3130231974 |
---|
|
SQL SQL Diagnostic Manager server type remains unchanged after adding or updating the server. Status |
---|
colour | Green |
---|
title | SQLDM-31332 |
---|
|
SQL Diagnostic Manager is no longer displaying the “Reading default instances failed:System.InvalidCastException" error when saving historical snapshotssupports Extended Event Options for the Activity Monitor and the Query Monitor properties.31385 SQL Diagnostic Manager now saves the configuration for the newly added Baseline SQL Diagnostic Manager allows user accounts to apply alert templates to a monitor instance.
31449 When SQL Diagnostic Manager installation completes successfully, the Installshield Logs are deleted.
Status |
---|
colour | Green |
---|
title | SQLDM-31495 |
---|
|
SQL DM is no longer raising unhandled exceptions when adding a server (Azure, Amazon, Windows). Status |
---|
colour | Green |
---|
title | SQLDM-31500 |
---|
|
...
improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
Status |
---|
colour | Green |
---|
title | SQLDM-31528 |
---|
|
The grooming is no longer filling the transaction log.SQL Diagnostic Manager allows you to successfully add a new user through the Application Security tab Status |
---|
colour | Green |
---|
title | SQLDM-31547 |
---|
|
SQL Diagnostic Manager now installs the correct Native Client 2012 version.31582 SQL DM supports 4K resolution by successfully scaling and displaying screens, icons, and text.
Status |
---|
colour | Green |
---|
title | SQLDM-31536 |
---|
|
SQL Diagnostic Manager is no longer prompting unhandled exceptions when launching. SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly
Status |
---|
colour | Green |
---|
title | SQLDM-31648 |
---|
|
Password values are masked in the 'SQLDMMasterInstaller.log'.31630 After installing With SQL Diagnostic Manager, the Connect to SQLDM Repository dialog pops up successfully to specify the location of your repositoryyou can personalize the dashboard view by choosing a specific dashboard to display.
Status |
---|
colour | Green |
---|
title | SQLDM-3168332232 |
---|
|
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 |
---|
colour | Green |
---|
title | SQLDM-31831 |
---|
|
SQL Diagnostic Manager shows the correct supported version on the Server Wizard Status |
---|
colour | Green |
---|
title | SQLDM-31827 |
---|
|
SQL Diagnostic Manager opens the properties window for unreachable instances in the expected time frame.Database
allows you to grant users access to specific instances through the Application Security window.
30775 The refreshing time for the Database Summary and Availability Groups is shorter than before. You can successfully export the Analyze report of a monitored instance
Status |
---|
colour | Green |
---|
title | SQLDM-30871 |
---|
|
The LastDatabaseCollectionTime database is successfully populated in the repository as well as in the console application with an offline database.31628 The SQL Databases summary shows the right values for the Compatibility level column.
DM Console
Status |
---|
colour | Green |
---|
title | SQLDM-30869 |
---|
|
SQL Diagnostic Manager shortened the loading times in the Queries view and you can properly navigate between tabs in DM console. Status |
---|
colour | Green |
---|
title | SQLDM-31046 |
---|
|
SQL Diagnostic manager now works as expected when navigating across different instances tabs SQL Diagnostic Manager successfully displays the history browser for SQL Server Azure-managed instances.31458 SQL SQL Diagnostic Manager Console only installer checks for the right .NET Framework.
Status |
---|
colour | Green |
---|
title | SQLDM-31517 |
---|
|
SQL DM is no longer showing a refresh error when navigating to the Files Tab under the Database tab. Status |
---|
colour | Green |
---|
title | SQLDM-31516 |
---|
|
SQL DM is no longer showing a refresh error when navigating to the Disk Size Tab under the Resources tab.successfully monitors and displays information for scale-out installations, showing the correct version.
On-Premises
Status |
---|
colour | Green |
---|
title | SQLDM-31515 |
---|
|
SQL DM is no longer displaying a refresh error when navigating to the TempDB Summary Tab under the Databases tab. Status |
---|
colour | Green |
---|
title | SQLDM-31818 |
---|
|
After a closeout, SQL Diagnostic Manager keeps the servers added to the new custom views created in "My views". Status |
---|
colour | Green |
---|
title | SQLDM-31844 |
---|
|
SQL Diagnostic Manager Console works as expected when the Server View Refresh is set at 30 seconds for large environments....
The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
Status |
---|
colour | Green |
---|
title | SQLDM-30998 |
---|
|
Tempdb disks work as expected. They save the drive information SQLDM Web Console successfully displays all the alerts of the monitored instance. Besides, the hostname name returns the server name on which the query runs....
instances after an upgrade.
30905 Disabling Collection of Replication Statistics feature is now working correctly.
Status |
---|
colour | Green |
---|
title | SQLDM-31410 |
---|
|
The ServerActivity table is no longer growing unexpectedly large. Status |
---|
colour | Green |
---|
title | SQLDM-31453 |
---|
|
SQL DM now successfully generates the reports and alerts for the fragmentation table.Analysis
Dates are now displayed in the proper format on SQLDM Web Console
Status |
---|
colour | Green |
---|
title | SQLDM-31051 |
---|
|
The Analyze tab is working as expected.31259 SQL Diagnostic Manager shows recommendations correctly when monitoring Azure SQLDBcorrectly displays graphics in the Web Console, since the graphics order has been fixed.
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.
Status |
---|
colour | Green |
---|
title | SQLDM-31600 |
---|
|
The prescriptive analysis performs as expected for scheduled jobs.Services
Status |
---|
colour | Green |
---|
title | SQLDM-31099 |
---|
|
SQLdmManagementService.exe successfully runs after upgrading SQL Diagnostic Manager. Status |
---|
colour | Green |
---|
title | SQLDM-31254 |
---|
|
The SQLdmCollectionService log now shows the expected logging information. Status |
---|
colour | Green |
---|
title | SQLDM-31436 |
---|
|
SQLdm Management service now successfully updates the repository....
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
31116 The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively The IDERA Dashboard performance was improved and is working as expected.
High Availability Groups
31146 The High Availability Groups successfully collect replication metrics, showing them in the Replication tab of the Server's Services view.
Status |
---|
colour | Green |
---|
title | SQLDM-31594 |
---|
|
Days since last backup works as expected on secondary replica (always on) instances.Upgrade
The "Days since the last backup" alert functions as intended according to the backup preference settings for High Availability Groups
Status |
---|
colour | Green |
---|
title | SQLDM-31186 |
---|
|
SQL Diagnostic Manager now works as expected when upgrading to the latest version with SQL server 2005 instances. Status |
---|
colour | Green |
---|
title | SQLDM-3169231875 |
---|
|
After upgrading to SQL DM 11.1.6, SQLDM shows correctly the main views ensuring its proper functioning.Graphs
Status |
---|
colour | Green |
---|
title | SQLDM-31282 |
---|
|
SQL Diagnostic Manager now correctly displays the graphics from the Dashboard view. Status |
---|
colour | Green |
---|
title | SQLDM-31486 |
---|
|
SQL Diagnostic Manager now displays the graph text fully, graphs have a gradient, and all databases are listed under the databases dropdown. Status |
---|
colour | Green |
---|
title | SQLDM-31801 |
---|
|
The overview tab now correctly displays the transactions per second graph.DBaaS
Diagnostic Manager successfully monitors listener status in a High Availability environment while monitoring replicas.
Upgrade
31357 SQL SQL Diagnostic Manager disables some metrics that Azure SQL DBaaS Template cannot monitor.
Status |
---|
colour | Green |
---|
title | SQLDM-31376 |
---|
|
The Dashboard of the Overview tab for Azure-managed instances now displays the network widget.displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.431396 Query Monitor works as expected. It collects no data for Azure SQL Instances when it is not enabled.
Status |
---|
colour | Green |
---|
title | SQLDM-31467 |
---|
|
SQLDM now allows reconfiguring instances from Windows to AzureDB After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files
Status |
---|
colour | Green |
---|
title | SQLDM-31571 |
---|
|
The Analysis Configuration view is available for RDS instances. Status |
---|
colour | Green |
---|
title | SQLDM-3152632181 |
---|
|
Query Monitor successfully collects data on Azure SQL MI servers. Status |
---|
colour | Green |
---|
title | SQLDM-31529 |
---|
|
The BDaaS Metric Category has two new subcategories for Amazon RDS and Azure DB You can successfully upgrade SQL Diagnostic Manager to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags.31554 SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade The Analyze features are now available for Azure SQL Instances.
Status |
---|
colour | Green |
---|
title | SQLDM-31679 |
---|
|
SQL Diagnostic manager now adds SQL Azure DBaaS instances and successfully refreshes its servers' alerts.31608 SQL DM Console successfully traces sessions on monitored Azure Managed Instances.
Metrics
Status |
---|
colour | Green |
---|
title | SQLDM-31373 |
---|
|
The Filegroup Space Full(Percent) metric is no longer displaying false data. Status |
---|
colour | Green |
---|
title | SQLDM-31450 |
---|
|
The SQL Server services metric status now works as expected. Status |
---|
colour | Green |
---|
title | SQLDM-31494 |
---|
|
The Advanced Options window behaves as expected with all metrics. SQL Diagnostic Manager successfully triggers notifications for "SQL Server Agent Job Failure" alerts after an upgrade.
DBaaS
Status |
---|
colour | Green |
---|
title | SQLDM-31604 32221 |
---|
|
The SQL Server CPU Usage (Percent) metric now reports within the expected values. SQL Diagnostic Manager keeps the last Sever selection and Time Period for using them when configuring a new report. Metrics
Status |
---|
colour | Green |
---|
title | SQLDM-3169532130 |
---|
|
SQL SQL Diagnostic Manager now successfully saves increased the maximum critical threshold values value for the Oldest Open Transaction (minutes) metric....
"Version Store Size (MB)" metric.
31477 By default the metric Days since last backup is deselected in the Alert Configuration popup for cloud servers.
Status |
---|
colour | Green |
---|
title | SQLDM-31672 |
---|
|
SQL Diagnostic Manager now successfully triggers an Alert Response when all the custom counters are "Critical."AlwaysOn
Status |
---|
colour | Green |
---|
title | SQLDM-31473 |
---|
|
Monitored AlwaysOn servers are successfully contacted, making the AlwaysOn Listener - DB accessible....
SQL diagnostic Manager successfully displays the "SQL Server CPU Usage" metric after upgrading to SQLDM 12.
31435 Query Details are displayed by clicking the globe icon on Statement Mode and Signature Mode.
Status |
---|
colour | Green |
---|
title | SQLDM-31566 |
---|
|
The Queries tab gets Data loaded faster than before.Replication
The "Procedure Cache Hit Ratio" metric has been improved on Azure SQL Managed Instance and Azure DB.
Charts
Status |
---|
colour | Green |
---|
title | SQLDM-31462 |
---|
|
SQLDM allows monitoring Services from the Replication tab. Status |
---|
colour | Green |
---|
title | SQLDM-31300 |
---|
|
SQL Diagnostic Manager now displays the correct Topology Replication data....
SQL Diagnostic Manager correctly shows the Total Deadlock data in the Overview and Sessions charts after an upgrade.History Browser
Status |
---|
colour | Green |
---|
title | SQLDM-3130332019 |
---|
|
SQL Diagnostic Manager works as expected while attempting to apply a template to a monitored instancesuccessfully collects historical data in the History Browser for all the monitored servers.31602 By default, SQL DM automatically selects a template in the Add Servers Wizard SQL Diagnostic Manager correctly displays historical data for TempDB summary in the history browser and across multiple time ranges.