SQL Diagnostic Manager provides the following new features and fixed issues.
12.
...
3 New Features
SQL Diagnostic Manager
...
- 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.
presents the following features 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
| Info |
|---|
| title | IDERA 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. |
...
Fixed Issues
Reports
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3183032143 |
|---|
|
The Top Servers by Percent Usage report correctly displays CPU SQL Usage (Percent) values"Server Uptime" report records the correct values for the uptime and downtime of a specific instance.31668The Database Statistics report is now generating data correctly for a custom range of time SQL Diagnostic Manager now successfully exports the Plan XML (Estimated) report from the Event Occurrences detail view.
31663 The Server Uptime report pops up a "Select SQL Server" message when you do not select a server, otherwise, it works as expected The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager.
31639 SQL Diagnostic Manager correctly gathers, stores, and reports Database Statisticsidentifies query records where query plans have been successfully collected.
31543 SQL SQL Diagnostic Manager 12.2 correctly generates the Enterprise Summary reports including the SQL Server version of your instancessuccessfully generates the "Template Comparison" report.
Alerts
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-32393 |
|---|
|
SQL Diagnostic Manager accurately displays alert data in the Historical Snapshots tooltip for a specific instance.
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-31452 |
|---|
|
The Database Growth Forecast report is correctly generated SQL Diagnostic Manager correctly applies the "Where metric severity has changed is in place" alert rule.
30663 The Disk Space History report correctly lists the disk available on the monitored instances The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.
30657 The Disk Space History report is correctly generated for seven, 15, and 30 days The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds.
30497 The Transaction Log statistics successfully return historical data.
...
The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully.
31924 SQL Diagnostic Manager 12.2 correctly triggers email notifications for Database Full (Percent) and Filegroup Full Space (Percent) alertsprovides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+).
31848 You can successfully configure e-mail notifications, including "and" conditions SQL Diagnostic Manager 12.2 successfully triggers email notifications for Log Full (Percent) alerts.
31791 You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3 The Blocked Sessions alert is successfully triggered in the configured response alert time.
31721 The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details SQL Diagnostic Manager successfully triggers the Unsubscribed Transactions (Seconds) alert once is configured and enabled.
31676 The CPU Statistics report correctly shows trends for CPU usage, displaying the correct values for the CPUActivityPercentange alert. SQL Diagnostic Manager only displays the active alerts on the environment views.
Alerts Response
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3165432215 |
|---|
|
SQL SQL Diagnostic Manager allows you to clear the recommendation alerts from the Alert Recommendation window until it raises againimproved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule.31501 After upgrading to SQLDM 12, SQL Diagnostic Manager maintains the "Email (SMTP) Provider" alert response configuration SQL Diagnostic Manager allows you to snooze operational alerts but not clear them from recommendations.
31251 With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider The Alert Configuration timeout value has been changed to get better performance.
31147 You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.
Custom Counters
SQL Diagnostic Manager now correctly generates Blocking alerts and reports.31045 SQL Diagnostic Manager correctly excludes databases from the Days Since Last Backup metric when exclusions are defined SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations.
31004 SQL Diagnostic Manager correctly monitors the status of the DTC service SQL Diagnostic Manager successfully applies Custom Counter in new Servers when using templates.
29420 SQL Diagnostic Manager dismisses Availability Group Role Change alerts correctly.
...
allows selecting and applying custom counters to all servers when creating metric alert responses for cluster environments.
31601 When using the 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.
...
manual Maintenance Mode, the instances remain linked to Custom Counters.
General
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32041 |
|---|
|
Users can now successfully add an existing user from one cluster to another while maintaining the original security settings SQL Diagnostic Manager supports Extended Event Options for the Activity Monitor and the Query Monitor properties.32029 SQL SQL Diagnostic Manager allows you to correctly check the licensed SQL Server instances in the Manage Servers windowuser accounts to apply alert templates to a monitor instance.
32015 SQL Diagnostic Manager console works as expected with more than 100 servers registered.improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3196732339 |
|---|
|
SQL Diagnostic Manager can now successfully enable/disable Maintenance modes using Tagsallows you to successfully add a new user through the Application Security tab.31950 SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly The Tags view displays data with more than 100 created tags.
31833 With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display The Add Server Wizard now saves the Query Monitor settings when the SQL Server instance is added.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3181932232 |
|---|
|
SQL SQL Diagnostic Manager 12.2 successfully connects to monitored SQL servers after the KB5004442 Microsoft patch has been appliednow allows you to grant users access to specific instances through the Application Security window.31709 You can successfully export the Analyze report of a monitored instance The SQL Diagnostic Manager Management Service no longer crashes when there are more than one SNMP action provider configured.
31469 SQL Diagnostic Manager 12.2 response time has been improvedsuccessfully displays the history browser for SQL Server Azure-managed instances.
31257 SQL Diagnostic Manager's recommendation engine has been updated to include additional recommendations found in SQL Doctor. SQL Diagnostic Manager successfully monitors and displays information for scale-out installations, showing the correct version.
On-Premises
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3101231859 |
|---|
|
The SQL Diagnostic Manager repository database now supports 2012 and higher compatibility levels. The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28750 |
|---|
|
SQL Diagnostic Manager correctly displays the session status of ROLLBACK after a session is killed....
SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade.30895 SQL Diagnostic Manager now successfully displays Disk Activity information for cluster shared volume drives (CSVFS) databases.
...
Dates are now displayed in the proper format on SQLDM Web Console.
31457 SQL Diagnostic Manager correctly populates the list of mount points on the monitored instances.
...
displays graphics in the Web Console, since the graphics order has been fixed.
31554 You can now successfully perform the Analysis Status of Azure instances.
...
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
31588 The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively SQL Diagnostic Manager services perform successfully, making it possible that the Aggregation and Grooming jobs to work as expected.
High Availability Groups
31972 The "Days since the last backup" alert functions as intended according to the backup preference settings for The Long Send Rate (KB/s) metric now works as expected in High Availability Groups.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-30194 |
|---|
|
The Availability Group History browser successfully displays the replica role status on particular instances SQL Diagnostic Manager successfully monitors listener status in a High Availability environment while monitoring replicas.Upgrade
31623 The user can successfully add a new user after upgrading SQL Diagnostic Manager .
...
displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4
32052 After upgrading, SQL Diagnostic Manager no longer generates sys.availability_group_listeners errors when monitoring Azure SQL Databases.does not raise any unhandled exception related to missing files.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31474 |
|---|
|
Forecast alerts are successfully generated for Azure Manage Instance and Azure SQL Databases....
You can successfully upgrade SQL Diagnostic Manager to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags.31946 SQL Diagnostic Manager correctly reports the correct values for the SQL Server Usage (Percent) metric SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade.
31556 SQL Memory Usage metric correctly calculates the percentage of the total memory used by Azure SQL servers. SQL Diagnostic Manager successfully triggers notifications for "SQL Server Agent Job Failure" alerts after an upgrade.
DBaaS
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31298 |
|---|
|
SQL Server Agent Long Running Job (Percent) metric now provides the correct value....
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-3196532130 |
|---|
|
SQL SQL Diagnostic Manager correctly associates query data to the correct monitored instanceincreased the maximum critical threshold value for the "Version Store Size (MB)" metric.31846 SQL Diagnostic Manager successfully gathers query data through Query Monitor on instances containing databases that have a trailing space in the database name SQL diagnostic Manager successfully displays the "SQL Server CPU Usage" metric after upgrading to SQLDM 12.
31552 SQL Diagnostic Manager allows you to successfully refresh your data in any Query View. The "Procedure Cache Hit Ratio" metric has been improved on Azure SQL Managed Instance and Azure DB.
Charts
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31365 |
|---|
|
Users can now successfully configure the Query monitoring on any environment. 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-3096732019 |
|---|
|
SQL 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.History Browser
collects historical data in the History Browser for all the monitored servers.
30840. SQL Diagnostic Manager correctly displays historical data for TempDB summary in the history browser and across multiple time ranges History Browser successfully changes the custom settings when moved to other servers.