SQL Diagnostic Manager provides the following new features and fixed issues.
...
12.
...
Cluster environment
- A UNC path is set for DataPath for the SQLDM services in a cluster install.
Reports
- SQL Diagnostic Manager runs the Detailed Session report. This report provides detailed session information of your selected SQL Server instance and is included under the Resource Analysis Reports.
- SQL Diagnostic Manager has included the Deadlock Report. This report lets you analyze deadlocks on your SQL Server instance and is included under the Monitor reports.
- SQL Diagnostic Manager allows you to exclude one or more disks when running the Disk Space Usage report.
10.2.2 Fixed issues
IDERA Dashboard
- The errors "Error while fetching data” displayed in the IDERA Dashboard overview widgets are no longer shown.
- The IDERA Dashboard is no longer having issues when displaying data for SQL Diagnostic Manager groups and individuals login accounts.
- SQL Diagnostic Manager is no longer showing slow performance in the IDERA Dashboard.
- The widgets are displaying without problems when SQL Diagnostic Manager has been registered again in the Dashboard.
Web console
- SQL Diagnostic Manager is no longer displaying the error "Page not found" after entering valid credentials in the web console.
- The web console is no longer having issues displaying data.
TempDB
- The Tempdb summary screen is no longer displaying unhandled exceptions. The widgets are updating as expected.
Extended Events
- The query information is collected through Extended Events smoothly and is visible in all instances.
Reports
- When exporting an Alerts report as XML in the Dashboard, the "org/apache/xmlbeans/XmlObject" error is no longer generated.
Query Plan
- The Query plan information is collecting and populating to the Dashboard without problems
Metrics
- The "Availability Group Role Change" metric is generating alerts and notifying users by beeper and email alerts. This metric is generating OK status and working as expected.
Resources
- The Disk selection located in the Resource tab of the desktop console is no longer having issues when displaying data.
- Users are no longer getting the "The stored procedure 'p_GetDiskSizeDetails' doesn't exist (System.Data)" error, when they go to the Disk Size screen located in the Resources tab of the desktop console.
Availability Groups
- The availability groups historical views are displaying accurate information. The Availability Group is no longer having issues when browsing back to previous snapshots.
Alerts
- The alerts status is working as expected when the metrics are set to run alerts in specific thresholds values.
- The thresholds of the metric "Availability Groups Redo Queue" can be extended to higher values.
- The sudden spikes and drastic drops of SQL Diagnostic Manager alerts are no longer occurring
- When the threshold values of a custom counter are updated, the changes are reflected into the linked instances.
- SQL Diagnostic Manager is no longer showing problems while displaying deadlocks information in the Alerts tab of the desktop console.
- The Alerts summary is displaying the correct time zone in the alerts details description.
Other Issues
- SQL Diagnostic Manager is no longer having issues when creating shortcuts for all users.
- SQL Diagnostic Manager is no longer displaying installation failed messages.
- The blocking alerts triggered with no description data when SQL Diagnostic Manager is upgraded, are no longer an issue.
- The exception filter wildcard is working without problems after SQL Diagnostic Manager is upgraded.
- When a user clicks the "Optimize Script" button in the Finding Text of the Analyze option, SQL Diagnostic Manager is able to receive SQL Script without problems.
- After installing SQL Diagnostic Manager, an unhandled exception is shown together to the "Connect to Repository" message.
- SQL Diagnostic Manager is no longer displaying inconsistent Wait stats.
3 New Features
SQL Diagnostic Manager 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 Fixed Issues
Reports
Status |
---|
colour | Green |
---|
title | SQLDM-32143 |
---|
|
The "Server Uptime" report records the correct values for the uptime and downtime of a specific instance. Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-31873 |
---|
|
The Database Statistics report is now generating data correctly for a custom range of time.
Status |
---|
colour | Green |
---|
title | SQLDM-31680 |
---|
|
The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager.
Status |
---|
colour | Green |
---|
title | SQLDM-31683 |
---|
|
SQL Diagnostic Manager correctly identifies query records where query plans have been successfully collected.
Status |
---|
colour | Green |
---|
title | SQLDM-30535 |
---|
|
SQL Diagnostic Manager successfully 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-32347 |
---|
|
SQL Diagnostic Manager correctly applies the "Where metric severity has changed is in place" alert rule. Status |
---|
colour | Green |
---|
title | SQLDM-32194 |
---|
|
The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.
Status |
---|
colour | Green |
---|
title | SQLDM-32182 |
---|
|
The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds.
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32173 |
---|
|
The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully.
Status |
---|
colour | Green |
---|
title | SQLDM-32021 |
---|
|
SQL Diagnostic Manager provides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+).
Status |
---|
colour | Green |
---|
title | SQLDM-31941 |
---|
|
You can successfully configure e-mail notifications, including "and" conditions.
Status |
---|
colour | Green |
---|
title | SQLDM-31737 |
---|
|
You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3.
Status |
---|
colour | Green |
---|
title | SQLDM-31256 |
---|
|
The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details.
Status |
---|
colour | Green |
---|
title | SQLDM-28938 |
---|
|
SQL Diagnostic Manager only displays the active alerts on the environment views.
Alerts Response
Status |
---|
colour | Green |
---|
title | SQLDM-32215 |
---|
|
SQL Diagnostic Manager improved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule. Status |
---|
colour | Green |
---|
title | SQLDM-32030 |
---|
|
After upgrading to SQLDM 12, SQL Diagnostic Manager maintains the "Email (SMTP) Provider" alert response configuration.
Status |
---|
colour | Green |
---|
title | SQLDM-31876 |
---|
|
With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider.
Status |
---|
colour | Green |
---|
title | SQLDM-30889 |
---|
|
You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.
Custom Counters
Status |
---|
colour | Green |
---|
title | SQLDM-32148 |
---|
|
SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations.
Status |
---|
colour | Green |
---|
title | SQLDM-30385 |
---|
|
SQL Diagnostic Manager successfully applies Custom Counter in new Servers when using templates.
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32040 |
---|
|
SQL Diagnostic Manager allows selecting and applying custom counters to all servers when creating metric alert responses for cluster environments.
Status |
---|
colour | Green |
---|
title | SQLDM-32034 |
---|
|
When using the SQL Diagnostic Manager manual Maintenance Mode, the instances remain linked to Custom Counters.
General
Status |
---|
colour | Green |
---|
title | SQLDM-31974 |
---|
|
SQL Diagnostic Manager supports Extended Event Options for the Activity Monitor and the Query Monitor properties. Status |
---|
colour | Green |
---|
title | SQLDM-31303 |
---|
|
SQL Diagnostic Manager allows user accounts to apply alert templates to a monitor instance.
Status |
---|
colour | Green |
---|
title | SQLDM-30861 |
---|
|
SQL Diagnostic Manager improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
Status |
---|
colour | Green |
---|
title | SQLDM-32339 |
---|
|
SQL Diagnostic Manager allows you to successfully add a new user through the Application Security tab. Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32267 |
---|
|
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
Status |
---|
colour | Green |
---|
title | SQLDM-32256 |
---|
|
With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display.
Status |
---|
colour | Green |
---|
title | SQLDM-32232 |
---|
|
SQL Diagnostic Manager now allows you to grant users access to specific instances through the Application Security window. Status |
---|
colour | Green |
---|
title | SQLDM-32227 |
---|
|
You can successfully export the Analyze report of a monitored instance.
Status |
---|
colour | Green |
---|
title | SQLDM-32178 |
---|
|
SQL Diagnostic Manager successfully displays the history browser for SQL Server Azure-managed instances.
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32063 |
---|
|
SQL Diagnostic Manager successfully monitors and displays information for scale-out installations, showing the correct version.
On-Premises
Status |
---|
colour | Green |
---|
title | SQLDM-31859 |
---|
|
The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
Status |
---|
colour | Green |
---|
title | SQLDM-32333 |
---|
|
SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade. Status |
---|
colour | Green |
---|
title | SQLDM-32291 |
---|
|
Dates are now displayed in the proper format on SQLDM Web Console.
Status |
---|
colour | Green |
---|
title | SQLDM-32274 |
---|
|
SQL Diagnostic Manager correctly displays graphics in the Web Console, since the graphics order has been fixed.
Status |
---|
colour | Green |
---|
title | SQLDM-32242 |
---|
|
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
Status |
---|
colour | Green |
---|
title | SQLDM-32228 |
---|
|
The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.
High Availability Groups
Status |
---|
colour | Green |
---|
title | SQLDM-32147 |
---|
|
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-31875 |
---|
|
SQL Diagnostic Manager successfully monitors listener status in a High Availability environment while monitoring replicas.Upgrade
Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-32421 |
---|
|
SQL Diagnostic Manager displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4
Status |
---|
colour | Green |
---|
title | SQLDM-32299 |
---|
|
After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files.
Status |
---|
colour | Green |
---|
title | SQLDM-32181 |
---|
|
You can successfully upgrade SQL Diagnostic Manager to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags. Status |
---|
colour | Green |
---|
title | SQLDM-32150 |
---|
|
SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade.
Status |
---|
colour | Green |
---|
title | SQLDM-32026 |
---|
|
SQL Diagnostic Manager successfully triggers notifications for "SQL Server Agent Job Failure" alerts after an upgrade.
DBaaS
Status |
---|
colour | Green |
---|
title | SQLDM-32221 |
---|
|
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-32130 |
---|
|
SQL Diagnostic Manager increased the maximum critical threshold value for the "Version Store Size (MB)" metric. Status |
---|
colour | Green |
---|
title | SQLDM-32109 |
---|
|
SQL diagnostic Manager successfully displays the "SQL Server CPU Usage" metric after upgrading to SQLDM 12.
Status |
---|
colour | Green |
---|
title | SQLDM-31812 |
---|
|
The "Procedure Cache Hit Ratio" metric has been improved on Azure SQL Managed Instance and Azure DB.
Charts
Status |
---|
colour | Green |
---|
title | SQLDM-31870 |
---|
|
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-32019 |
---|
|
SQL Diagnostic Manager successfully collects historical data in the History Browser for all the monitored servers. Status |
---|
| |
---|
colour | Green |
---|
title | SQLDM-31951 |
---|
|
SQL Diagnostic Manager correctly displays historical data for TempDB summary in the history browser and across multiple time ranges.
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...