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, allowing you to go 10 steps forward or backward.
| 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.31668 The "Deadlock" report is correctly generated, and the History Browser successfully keeps all the history data 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 instances.successfully generates the "Template Comparison" report.
Alerts
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3145232194 |
|---|
|
The Database Growth Forecast report is correctly generated The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.30663 The Disk Space History report correctly lists the disk available on the monitored instances The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds.
30657 The Disk Space History report is correctly generated for seven, 15, and 30 days SQL Diagnostic Manager provides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+).
30497 The Transaction Log statistics successfully return historical data.
Alerts
You can successfully configure e-mail notifications, including "and" conditions| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31924 |
|---|
SQL Diagnostic Manager 12.2 correctly triggers email notifications for Database Full (Percent) and Filegroup Full Space (Percent) alerts.31848 You can successfully generate "Alert Forecasts" for Active Alerts in SQL SQL Diagnostic Manager 12.2 successfully triggers email notifications for Log Full (Percent) alerts3.
31791 The Blocked Sessions alert is successfully triggered in the configured response alert time"Deadlock" alert is generated as expected and sends alert emails with correct and complete details.
31721 SQL Diagnostic Manager successfully triggers the Unsubscribed Transactions (Seconds) alert once is configured and enabled.only displays the active alerts on the environment views.
Alerts Response
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31676 |
|---|
|
The CPU Statistics report correctly shows trends for CPU usage, displaying the correct values for the CPUActivityPercentange alert. SQL Diagnostic Manager improved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule.31654 Configuring automated responses to alerts on SQL Diagnostic Manager is now possible using the ServiceNow Action provider SQL Diagnostic Manager allows you to clear the recommendation alerts from the Alert Recommendation window until it raises again.
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 SQL Diagnostic Manager now correctly generates Blocking alerts and reports. You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.
Custom Counters
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 When using the SQL Diagnostic Manager manual Maintenance Mode, the instances remain linked to Custom Counters SQL Diagnostic Manager dismisses Availability Group Role Change alerts correctly.
General
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3160131974 |
|---|
|
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....
supports Extended Event Options for the Activity Monitor and the Query Monitor properties.
32041 SQL Diagnostic Manager allows user accounts to apply alert templates to a monitor instance Users can now successfully add an existing user from one cluster to another while maintaining the original security settings.
32029 SQL SQL Diagnostic Manager allows you to correctly check the licensed SQL Server instances in the Manage Servers window.improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3201532232 |
|---|
|
SQL Diagnostic Manager console works as expected with more than 100 servers registerednow allows you to grant users access to specific instances through the Application Security window.| 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 With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display The Tags view displays data with more than 100 created tags.
31833 You can successfully export the Analyze report of a monitored instance The Add Server Wizard now saves the Query Monitor settings when the SQL Server instance is added.
31819 SQL SQL Diagnostic Manager 12.2 successfully connects to monitored SQL servers after the KB5004442 Microsoft patch has been appliedsuccessfully displays the history browser for SQL Server Azure managed instances.
31709 The SQL Diagnostic Manager Management Service no longer crashes when there are more than one SNMP action provider configuredsuccessfully monitors and displays information for scale-out installations, showing the correct version.
31469 SQL Diagnostic Manager 12.2 response time has been improved.successfully stops Activity Monitor extended event collection on remote server when Activity Monitor is disabled.
On-Premises
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31257 |
|---|
|
SQL Diagnostic Manager's recommendation engine has been updated to include additional recommendations found in SQL Doctor. The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31012 |
|---|
|
The SQL Diagnostic Manager repository database now supports 2012 and higher compatibility levels SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade.28750 SQL Diagnostic Manager correctly displays the session status of ROLLBACK after a session is killed.
...
Dates are now displayed in the proper format on SQLDM Web Console.
30895 SQL Diagnostic Manager now successfully displays Disk Activity information for cluster shared volume drives (CSVFS) databases.
...
correctly displays graphics in the Web Console, since the graphics order has been fixed.
31457 SQL Diagnostic Manager correctly populates the list of mount points on the monitored instances.
...
SQLDM Web Console displays the correct values for the CPU usage metric in the Home tab.
31554 You can now successfully perform the Analysis Status of Azure instances.
...
SQLDM Web Console now keeps your configuration settings after logging out of the console.
31588 The Alerts view of SQLDM Web Console allows users to effectively set up Advanced Filters SQL Diagnostic Manager services perform successfully, making it possible that the Aggregation and Grooming jobs to work as expected.
High Availability Groups
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31972 |
|---|
|
The Long Send Rate (KB/s) metric now works as expected in High Availability Groups SQL Diagnostic Manager successfully monitors listener status in a High Availability environment while monitoring replicas.30194 The Availability Group History browser successfully displays the replica role status on particular instancesalert for "Days since the last backup" is functioning as intended according to the backup preference settings for High Availability Groups.
Upgrade
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3162332181 |
|---|
|
The user You can successfully add a new user after upgrading upgrade SQL Diagnostic Manager . ...
to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags.
32052 SQL Diagnostic Manager no longer generates sys.availability_group_listeners errors when monitoring Azure SQL Databases.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31474 |
|---|
Forecast alerts are successfully generated for Azure Manage Instance and Azure SQL Databases.Metrics
successfully updates snapshots and refreshes alerts after an upgrade.
31946 SQL SQL Diagnostic Manager correctly reports the correct values for the SQL Server Usage (Percent) metricsuccessfully triggers notifications for "SQL Server Agent Job Failure" alerts after an upgrade.
31556 SQL Diagnostic Manager correctly pre-fetches the Index database details after an upgrade SQL Memory Usage metric correctly calculates the percentage of the total memory used by Azure SQL servers.
31298 SQL Server Agent Long Running Job (Percent) metric now provides the correct value.
...
After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files.
DBaaS
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3196532221 |
|---|
|
SQL SQL Diagnostic Manager correctly associates query data to the correct monitored instance.keeps the last Sever selection and Time Period for using them when configuring a new report. Metrics
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3184632130 |
|---|
|
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 increased the maximum critical threshold value for the "Version Store Size (MB)" metric.31552 The "Procedure Cache Hit Ratio" metric has been improved on Azure SQL Managed Instance and Azure DB SQL Diagnostic Manager allows you to successfully refresh your data in any Query View.
31365 SQL diagnostic Manager successfully displays the "SQL Server CPU Usage" metric after upgrading to SQLDM 12.
Charts
Users can now successfully configure the Query monitoring on any environment.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3096731870 |
|---|
|
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 tablecorrectly shows the Total Deadlock data in the Overview and Sessions charts after an upgrade.History Browser
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-30840. |
|---|
|
History Browser successfully changes the custom settings when moved to other SQL Diagnostic Manager successfully collects historical data in the History Browser for all the monitored servers.