This build includes many fixed issues, including the following updates from previous releases.

13.1 New Features

SQL Diagnostic Manager presents the following features and enhancements:

• Improves security by providing Multi-Factor Authentication (MFA) and Single Sign On (SSO) support for Windows Client and Browser interfaces through OIDC authentication. Both Okta and Entra ID were specifically tested and documented for this release, however, any other OIDC service should also work equally well with SQL DM. For more information about OIDC usage, see OpenID Connect authentication.
  
• Includes new custom counters for CloudWatch for Amazon RDS instances. Simply select the CloudWatch counter in the Add Custom Counter dialog. For more information about this feature, see Select AWS RDS System Counter.
• SQL Diagnostic Manager provides Experimental Support only for Windows Server 2025 and SQL Server 2025. Experimental Support means that this platform is not fully tested and has limited support.
• Improves secure internal product communications between agents, console, and repository.

13.1 Fixed Issues

Alerts

SQLDM-32912 SQL Diagnostic Manager no generates duplicate alerts for SQL Agent Deadlocks.

SQLDM-32844 The Configure Alerts window now includes all available alert recommendations.

SQLDM-32641 Resolves an issue causing the server list to not populate when attempting to apply an alert template, configuring alerts, or managing custom counters.

SQLDM-32570 SQL DM now generates an Unable to Connect alert without issue.

SQLDM-32467 Card and Details views now display the correct number of active alerts per instance.

SQLDM-32402 Updates the message for the Configuring Alert Templates window to more clearly state that changes to alert templates do not affect monitored server settings until the template is applied. That functionality ensures that all alert settings, not only those modified, are applied to the server.

Alerts Response

SQLDM-32844 and SQLDM-32783 Resolve issues with the Where metric severity is unchanged for a specific period of time option. One issue is that when selected, it results in the selection of both that option and Where metric severity has changed after saving the initial selection. The second issue is that some users received email notifications of issues based on a set number of seconds rather than minutes, i.e. a notification setting of 30 minutes resulted in the system sending notifications every 30 seconds instead.

SQLDM-32759 The email notification for the Blocking / Deadlock Alert now includes:

• • the session ID causing the block or deadlock
  • information about the SQL Server with Session ID of blocking other sessions
  • the blocking session (SPID)
  • blocking or deadlock query information including the SQL statements and session details incolved
  • blocking duration 

Analysis

SQLDM-32667 Resolves an issue preventing some users from manually running a SQL DM analysis. 

Custom Counters

SQLDM-30385 Custom counters in templates now are properly applied for new servers.

DM Console

SQLDM-32970 The Console Dashboard Charts (Memory Areas, Buffer Caches, and others) now show only one value for the Y axis.

SQLDM-32836 Resolves an issue causing some users to experience a Console failure when marking all analysis results for export.

General

SQLDM-32883 Resolves an issue causing an error when some users attempted to view the Server Summary after upgrading to SQL DM 13.0.0.

SQLDM-32873 Users now can successfully add a new SQL Server in IDERA Monitoring without receiving an unnecessary error preventing a successful server addition.

SQLDM-32855 The UI now displays an Edit option for the AWS Access Key, AWS Secret Key, and AWS Region in the Properties window.

SQLDM-32819 Resolves an issue preventing users from adding a deleted user account back to the Application Security page.

SQLDM-32789 Adds a new Last Job Start Time column when displaying job lists.

SQLDM-32787 Users no longer receive an error message when attempting to stop the SQL DM Management Service.

SQLDM-32753 Resolves an issue causing a "System.ArgumentException: An item with the same key has already been added" error in the Collection Service logs and preventing collection and processing of data.

SQLDM-32732 Optimized code to improve Collection Service performance in an OLTP environment.

SQLDM-32728 Resolves an issue causing the VM Configuration window to not populate associated fields when the user clicks Link Instances to VMs.

SQLDM-32727 Resolves an issue causing the card view to display No Alerts for all servers on the Dashboard.

SQLDM-32703 Adds Encrypt Connection and Trust Server Certificate checkboxes when configuring authentication for users to connect to the repository using those features.

SQLDM-32406 Resolves an issue preventing some MIBs from properly compiling.

SQLDM-32386 Adds options in the Servers view to Enable, Disable, and Schedule server Maintenance Mode by right-clicking the server and following the menu items.

SQLDM-32383 Resolves an issue causing a SQL Server Browser Service Unable to Monitor alert after switching to OLE Automation.

SQLDM-30783 The Text Size (MB) for tables no longer displays 0.0 when a non-zero value exists.

Graphs

SQLDM-31550 Resolves issues with some graphs when rendering Azure SQLDB data.

Install/Upgrade

SQLDM-32899 The SQL DM Management Service no longer fails after upgrading to version 13.0.2.

SQLDM-32879 SQL DM now correctly displays historical snapshots saved before upgrading to SQL DM 13.0.0.

SQLDM-32872 Resolves an issue preventing some users from successfully installing or upgrading the remote SQL DM Desktop Clients using SQL DM 13.0.1.69 Maintenance Pack.

SQLDM-32804 SQL Diagnostic Manager installs a currently-supported version of Microsoft ASP .NET Core.

SQLDM-32160 SQL DM installations/upgrades now accept double quotation marks (") and spaces as special characters in passwords.

Metrics

SQLDM-32914 Resolves an issue with the SQL Server Memory Usage (Percent) metric triggering alerts when still in acceptable range after upgrading from SQL DM 12.3.4 to 13.0.2.33. 

SQLDM-32789 Resolved an issue causing the Unsubscribed Transaction Time metric to provide incorrect data.

Queries

SQLDM-32556 Resolves an issue causing Signature/Standard graphical views to display data even when Query Monitor is disabled.

Reports

SQLDM-32835 Users no longer receive a "Cast exception" error when attempting to open an Analysis report from the Analyze tab.

SQLDM-32811 The scheduled SSRS AG Topology report email no contains all relevant data.

SQLDM-32522 SQL DM now offers the Server Database Availability report that offers the up time, down time, and availability percentage of a server's databases.

SQLDM-32164 Resolves an issue causing both the Database Full Percent and Filegroup Space Full Percent metrics to falsely report zero space availability.

IDERA Web Console

SQLDM-32895 The IDERA Web Console's Alerts view no longer displays the alert's datetime as UTC values rather than local time.

SQLDM-32828 The IDERA Web Console now retains all user-performed actions rather than reverting to default after an automatic refresh.

SQLDM-32826 Resolves an issue preventing users from checking/unchecking selected charts in the Add Chart and Add Dashboard sections of the Manage Charts dialog box.

SQLDM-32809 The IDERA Web Console auto-refresh feature now simply refreshes the data in each graph rather than reloading the entire page.

SQLDM-32807 The IDERA Web Console remains in history mode after an auto-refresh if the user is in that mode when the refresh occurs.

SQLDM-32073 Improves server status response time of the IDERA Web Console.

UI

SQLDM-32694 Fixes the alignment for the Alert Filter Exclude text box. 

SQLDM-32676 Resolves a sizing issue with the Advanced Alert Configuration window.

SQLDM-32647 Resolves a sizing issue with the x-axis of the some usage charts. 

SQLDM-32316 Resolves a sizing issue with the Advanced Options window.

13.0 New Features

SQL Diagnostic Manager presents the following features and enhancements:

• SQL Diagnostic Manager now supports the Entra ID Authentication method for all monitoring accounts for on-prem instances or DBaaS environments, including Azure DB, Azure Managed Instance, and Azure Elastic Pool. This new feature comes with several benefits, such as:
  • Enhancement of the Azure Discovery feature in SQL Diagnostic Manager by avoiding manually entering credentials for each database or instance.
  • Ease of adding large numbers of Azure resources with shared Entra ID credentials.
  • More secure connections through Azure SQL than SQL Server authentication.
• Allows you to copy certain property settings to another monitored instance.
• By default, disables the 'Table Statistics' collection for new instances.
• Operations Alerts are now available for alert responses.

Finally, we have newly implemented features for the SQLDM Web Console that improve its performance:

• Automatic data refresh every minute.
• Windows Authentication is the default authentication method.

13.0 Fixed Issues

Alerts

SQLDM-32735 SQL Diagnostic Manager now accurately generates database alerts for SQL Server 2022, displaying the correct database status alerts.

SQLDM-32629 The Alerts view displays all the current alerts when applying the "All" filter to the Server field.

SQLDM-32528 SQL Diagnostic Manager alerts work as expected for model_msdb and model_replicatedmaster databases in SQL Server 2022 environments. It no longer triggers backup alerts.

SQLDM-32521 SQL Diagnostic Manager effectively generates the Blocking Session Wait Time alert, displaying the Real-Time view and Block details when selected.

SQLDM-32354 SQL Diagnostic Manager allows you to snooze Alerts without any errors.

SQLDM-32330 SQL Diagnostic Manager enables you to export and import alert templates, keeping all your previous configurations.

SQLDM-32293 and SQLDM-32764 SQL Diagnostic Manager properly applies all the Alert recommendations for your servers.

SQLDM-32245 SQL Diagnostic Manager successfully shows Operational Alerts in the Alert view. 

SQLDM-32147 The Days since last backup alert considers the backup preference settings, working as expected.

SQLDM-32087 SQL Diagnostic Manager provides useful alert recommendations in the Configure Alerts view. 

SQLDM-31718 SQL Diagnostic Manager provides useful recommendations for Missing Index alerts, pointing to the affected tables.

Alerts Response

SQLDM-32517 When adding a Power Shell Script as an Alert Response, the Power Shell command action defaults to PS ISE x64 when clicking the Test button.

Analysis

SQLDM-32420 SQL Diagnostic Manager now supports displaying analysis results for servers across different time zones.

Custom Counters

SQLDM-32699 In SQL Diagnostic Manager 13.0, you can successfully create a custom counter template based on an existing one, keeping previously defined thresholds. 

DM Console

SQLDM-32697 The Activity Monitor option is disabled by default and the Types of SQL Server activities to capture are grayed out. Once you enable the Activity Monitor, all related options become accessible and can be configured.

SQLDM-32678 SQL Diagnostic Manager accurately displays Query History data from the Queries view, ensuring consistency with the Details data from the Sessions view.

SQLDM-32664 SQL Diagnostic Manager 13.0 allows you to successfully apply the Baseline configuration to the available monitored SQL Server instances. 

SQLDM-32626 SQL Diagnostic Manager now offers more detailed information about the monitored instances, including their version details. 

SQLDM-32597, SQLDM-32594, and SQLDM-32344 SQL Diagnostic Manager displays the instance name and related information in the server thumbnail on the Server Overview dashboard. However, if the name exceeds the maximum length allowed, it will be truncated. View the full server name by hovering over the thumbnail to see it in a tooltip.

SQLDM-32559 SQL Diagnostic Manager 13.0 successfully refreshes the data in the Details tab of the Session view, ensuring accurate and error-free execution.

SQLDM-32503  SQL Diagnostic Manager supports Alternative Windows Collections accounts for instances with High Availability group servers.

SQLDM-32168 SQL Diagnostic Manager lets you minimize and maximize the My Server and Tags tree view with the latest SQLdm version.

SQLDM-32153 The SQL Diagnostic Manager console now correctly displays the tags assigned to the logged-in user.

SQLDM-26085 SQL Diagnostic Manager now fully captures and displays the SQL text in the Last Command window of the Details tab within the Sessions view.

General

SQLDM-32604 SQL Diagnostic Manager now correctly shows the session data when configuring a custom range for the historical view.

SQLDM-32582 Now SQL Diagnostic Manager supports PowerShell cmdlets for registering or editing Azure DBs.

SQLDM-32479 SQL Diagnostic Manager 13.0 detects duplicate users and displays the "The login name already exists, please enter a different login name" error.

SQLDM-31574 TracerX has been updated to 6.1.

SQLDM-30980 SQL Diagnostic Manager successfully adds instances, displaying both the instance name and IP address. Additionally, the replication tab shows the subscriber details without any errors.

Graphs

SQLDM-32702 The Block Graphs feature provides the details of blocking alerts when double-clicking on the blocking alert.

SQLDM-32670 SQL Diagnostic Manager now successfully displays data for the Tempdb Space Used by File graph.

SQLDM-32615 SQL Diagnostic Manager displays Memory Usage graph data correctly.

High Availability Groups

SQLDM-30236 SQL Diagnostic Manager displays the correct row information for tables with clustered column storage index on SQL Server 2017.

Metrics

SQLDM-32466 The Database Status metric now correctly alerts you to the severity level after its threshold value has been changed from the default setting. Besides the Template Comparison report displays the Restoring and Recovery Pending status.

SQLDM-32381 In SQL Diagnostic Manager 13.3, updating the Days Since Last Backup metric thresholds in a template does not affect the thresholds of monitored instances.

SQLDM-32373 The Availability Group Name is now displayed in the Alert Metrics Details section and is included in the alert email.

SQLDM-32368 The Database Status metric now correctly alerts you to the severity level after its threshold value has been changed from the default setting. 

On-Premises

SQLDM-31161 SQL Diagnostic Manager displays user session information for SQL Azure managed server.

Queries

SQLDM-32397 Query Monitor successfully collects data for Azure Databases servers.

SQLDM-32395 The Diagnose Query feature performs a query analysis as expected and provides recommendations related to the selected query. 

SQLDM-32384 A new index has been added to improve the performance of the Queries views. 

SQLDM-31691 The Diagnose Query feature is working correctly, displaying the recommendations for the selected query within the Statement Mode tab of the Queries view.

Reports

SQLDM-32502 The Baseline statistics report is generated successfully without any errors.

SQLDM-32308 SQL Diagnostic Manager generates the Disk space usage report successfully when defaulting to 'No Disk Exclusion'. 

SQLDM-32247 In SQL Diagnostic Manager, you can now generate reports successfully using the <All Instances> filter option.

SQLDM-30037 The Block Report and Deadlock Report widgets correctly display the synced data with their corresponding reports.

IDERA Web Console

SQLDM-32644 Users with view-only permissions can successfully log in to the SQLDM Web Console.

SQLDM-32614 SQLDM Web Console now accurately displays the Network Response Time metric.

SQLDM-32613 SQLDM Web Console now correctly displays the Cache Hit Ratio metric.

SQLDM-32602 SQLDM Web Console correctly displays the server details in the Thumbnails view on the Home tab. 

SQLDM-32537 SQLDM Web Console now correctly displays all server technical details in the Server Overview charts view.

SQLDM-32535 IDERA Web Console displays graphs correctly with ascending time axes.

SQLDM-32508 SQLDM Web Console now displays the Disk metrics graphs in the server's time zone.

SQLDM-32441 The SQL Diagnostic Manager Installation Wizard warns you about any problems that may occur during the installation of the IDERA Web Console.

SQLDM-32431 The performance of the IDERA Web Console has been enhanced to reduce high CPU usage and decrease the time required to display graphs.

SQLDM-31714 IDERA Web Console now successfully displays data on all widgets, including the SQL Server Memory Usage (Percent).

UI

SQLDM-31714 SQL Diagnostic Manager has improved the date/time axis on the Memory Usage chart for better clarity and more precise data visualization.

SQLDM-31714 SQL Diagnostic Manager has improved the Advanced Alert Configuration Wizard, making it easier to configure metrics.

SQLDM-31714 SQL Diagnostic Manager has corrected the console resizing feature to avoid performance issues in affected views.

Upgrade

SQLDM-32734 SQL Diagnostic Manager successfully monitors SQL Azure databases after an upgrade, fixing the unhandled exception on the Server Overview.

SQLDM-32692 The SQL Diagnostic Manager's Upgrade Wizard now correctly identifies the current installation path of the SQLDM Web console when upgrading from 12.3.7 to 13.0.

SQLDM-32681 SQL Diagnostic Manager successfully applies the configured Alert Templates to the selected servers.

SQLDM-32654 SQL Diagnostic Manager successfully upgrades the LWWC while keeping the original SQLdmWebConsoleUI.exe.config file.

SQLDM-32618 New indexes have been added to improve the performance of the repository database. 

SQLDM-32492 General stability improvements have been added for the SQLdm Management Service.

SQLDM-32378 After upgrading, SQL Diagnostic Manager retains the thresholds defined in the Advanced Alert Configuration for monitored servers.

SQLDM-31942 SQL Diagnostic Manager generates the Deadlock report when the grooming is configured.

12.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.

  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

SQLDM-32143 The "Server Uptime" report records the correct values for the uptime and downtime of a specific instance.

SQLDM-31873 The Database Statistics report is now generating data correctly for a custom range of time.

SQLDM-31680 The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager.

SQLDM-31683 SQL Diagnostic Manager correctly identifies query records where query plans have been successfully collected.

SQLDM-30535 SQL Diagnostic Manager successfully generates the "Template Comparison" report.

Alerts

SQLDM-32393 SQL Diagnostic Manager accurately displays alert data in the Historical Snapshots tooltip for a specific instance.

SQLDM-32347 SQL Diagnostic Manager correctly applies the "Where metric severity has changed is in place" alert rule.

SQLDM-32194 The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.

SQLDM-32182 The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds.

SQLDM-32173 The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully.

SQLDM-32021 SQL Diagnostic Manager provides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+).

SQLDM-31941 You can successfully configure e-mail notifications, including "and" conditions.

SQLDM-31737 You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3.

SQLDM-31256 The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details.

SQLDM-28938 SQL Diagnostic Manager only displays the active alerts on the environment views.

Alerts Response

SQLDM-32215 SQL Diagnostic Manager improved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule.

SQLDM-32030 After upgrading to SQLDM 12, SQL Diagnostic Manager maintains the "Email (SMTP) Provider" alert response configuration.

SQLDM-31876 With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider.

SQLDM-30889 You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.

Custom Counters

SQLDM-32148 SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations.

SQLDM-30385 SQL Diagnostic Manager successfully applies Custom Counter in new Servers when using templates.

SQLDM-32040  SQL Diagnostic Manager allows selecting and applying custom counters to all servers when creating metric alert responses for cluster environments.  

SQLDM-32034 When using the SQL Diagnostic Manager manual Maintenance Mode, the instances remain linked to Custom Counters.

General

SQLDM-31974 SQL Diagnostic Manager supports Extended Event Options for the Activity Monitor and the Query Monitor properties.

SQLDM-31303 SQL Diagnostic Manager allows user accounts to apply alert templates to a monitor instance.

SQLDM-30861 SQL Diagnostic Manager improved the analyzer's performance, providing more accurate analysis recommendations.

DM Console

SQLDM-32339 SQL Diagnostic Manager allows you to successfully add a new user through the Application Security tab.

SQLDM-32267 SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.

SQLDM-32256 With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display.

SQLDM-32232 SQL Diagnostic Manager now allows you to grant users access to specific instances through the Application Security window.

SQLDM-32227 You can successfully export the Analyze report of a monitored instance.

SQLDM-32178 SQL Diagnostic Manager successfully displays the history browser for SQL Server Azure-managed instances.

SQLDM-32063 SQL Diagnostic Manager successfully monitors and displays information for scale-out installations, showing the correct version.

On-Premises

SQLDM-31859 The Permissions Script for User Creation was successfully improved and now works as expected.

IDERA Web Console

SQLDM-32333 SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade.

SQLDM-32291 Dates are now displayed in the proper format on SQLDM Web Console.

SQLDM-32274 SQL Diagnostic Manager correctly displays graphics in the Web Console, since the graphics order has been fixed.

SQLDM-32242 SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.

SQLDM-32228 The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.

High Availability Groups

SQLDM-32147 The "Days since the last backup" alert functions as intended according to the backup preference settings for High Availability Groups.

SQLDM-31875 SQL Diagnostic Manager successfully monitors listener status in a High Availability environment while monitoring replicas.

Upgrade

SQLDM-32421 SQL Diagnostic Manager displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4

SQLDM-32299 After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files.

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.

SQLDM-32150 SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade.

SQLDM-32026 SQL Diagnostic Manager successfully triggers notifications for "SQL Server Agent Job Failure" alerts after an upgrade.

DBaaS

SQLDM-32221 SQL Diagnostic Manager keeps the last Sever selection and Time Period for using them when configuring a new report.  

Metrics

SQLDM-32130 SQL Diagnostic Manager increased the maximum critical threshold value for the "Version Store Size (MB)" metric.

SQLDM-32109 SQL diagnostic Manager successfully displays the "SQL Server CPU Usage" metric after upgrading to SQLDM 12.

SQLDM-31812 The "Procedure Cache Hit Ratio" metric has been improved on Azure SQL Managed Instance and Azure DB.

Charts

SQLDM-31870 SQL Diagnostic Manager correctly shows the Total Deadlock data in the Overview and Sessions charts after an upgrade.

History Browser

SQLDM-32019 SQL Diagnostic Manager successfully collects historical data in the History Browser for all the monitored servers.

SQLDM-31951 SQL Diagnostic Manager correctly displays historical data for TempDB summary in the history browser and across multiple time ranges.

12.2 New Features

• SQL Diagnostic Manager offers a brand-new browser interface framework, called SQLDM Web Console, offering:
  • 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. 

12.2 Fixed Issues

Reports

SQLDM-31830 The Top Servers by Percent Usage report correctly displays CPU SQL Usage (Percent) values.

SQLDM-31668  SQL Diagnostic Manager now successfully exports the Plan XML (Estimated) report from the Event Occurrences detail view.

SQLDM-31663  The Server Uptime report pops up a "Select SQL Server" message when you do not select a server, otherwise, it works as expected.

SQLDM-31639  SQL Diagnostic Manager correctly gathers, stores, and reports Database Statistics.

SQLDM-31543 SQL Diagnostic Manager 12.2 correctly generates the Enterprise Summary reports including the SQL Server version of your instances.

SQLDM-31452  The Database Growth Forecast report is correctly generated.

SQLDM-30663  The Disk Space History report correctly lists the disk available on the monitored instances.

SQLDM-30657  The Disk Space History report is correctly generated for seven, 15, and 30 days.

SQLDM-30497  The Transaction Log statistics successfully return historical data.

Alerts

SQLDM-31924 SQL Diagnostic Manager 12.2 correctly triggers email notifications for Database Full (Percent) and Filegroup Full Space (Percent) alerts.

SQLDM-31848  SQL Diagnostic Manager 12.2 successfully triggers email notifications for Log Full (Percent) alerts.

SQLDM-31791  The Blocked Sessions alert is successfully triggered in the configured response alert time.

SQLDM-31721  SQL Diagnostic Manager successfully triggers the Unsubscribed Transactions (Seconds) alert once is configured and enabled.

SQLDM-31676 The CPU Statistics report correctly shows trends for CPU usage, displaying the correct values for the CPUActivityPercentange alert. 

SQLDM-31654 SQL Diagnostic Manager allows you to clear the recommendation alerts from the Alert Recommendation window until it raises again.

SQLDM-31501 SQL Diagnostic Manager allows you to snooze operational alerts but not clear them from recommendations.

SQLDM-31251  The Alert Configuration timeout value has been changed to get better performance.

SQLDM-31147  SQL Diagnostic Manager now correctly generates Blocking alerts and reports.

SQLDM-31045  SQL Diagnostic Manager correctly excludes databases from the Days Since Last Backup metric when exclusions are defined.

SQLDM-31004  SQL Diagnostic Manager correctly monitors the status of the DTC service.

SQLDM-29420  SQL Diagnostic Manager dismisses Availability Group Role Change alerts correctly.

General

SQLDM-31601 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.

DM Console

SQLDM-32041  Users can now successfully add an existing user from one cluster to another while maintaining the original security settings.

SQLDM-32029  SQL Diagnostic Manager allows you to correctly check the licensed SQL Server instances in the Manage Servers window.

SQLDM-32015  SQL Diagnostic Manager console works as expected with more than 100 servers registered.

SQLDM-31967  SQL Diagnostic Manager can now successfully enable/disable Maintenance modes using Tags.

SQLDM-31950  The Tags view displays data with more than 100 created tags.

SQLDM-31833  The Add Server Wizard now saves the Query Monitor settings when the SQL Server instance is added.

SQLDM-31819  SQL Diagnostic Manager 12.2 successfully connects to monitored SQL servers after the KB5004442 Microsoft patch has been applied.

SQLDM-31709  The SQL Diagnostic Manager Management Service no longer crashes when there are more than one SNMP action provider configured.

SQLDM-31469  SQL Diagnostic Manager 12.2 response time has been improved.

SQLDM-31257  SQL Diagnostic Manager's recommendation engine has been updated to include additional recommendations found in SQL Doctor.

SQLDM-31012  The SQL Diagnostic Manager repository database now supports 2012 and higher compatibility levels.

SQLDM-28750  SQL Diagnostic Manager correctly displays the session status of ROLLBACK after a session is killed.

Disks

SQLDM-30895  SQL Diagnostic Manager now successfully displays Disk Activity information for cluster shared volume drives (CSVFS) databases.

Table

SQLDM-31457 SQL Diagnostic Manager correctly populates the list of mount points on the monitored instances.

Analysis

SQLDM-31554  You can now successfully perform the Analysis Status of Azure instances.

Services

SQLDM-31588  SQL Diagnostic Manager services perform successfully, making it possible that the Aggregation and Grooming jobs to work as expected.

High Availability Groups

SQLDM-31972 The Long Send Rate (KB/s) metric now works as expected in High Availability Groups.

SQLDM-30194 The Availability Group History browser successfully displays the replica role status on particular instances.

Upgrade

SQLDM-31623 The user can successfully add a new user after upgrading SQL Diagnostic Manager. 

DBaaS

SQLDM-32052  SQL Diagnostic Manager no longer generates sys.availability_group_listeners  errors when monitoring Azure SQL Databases.

SQLDM-31474  Forecast alerts are successfully generated for Azure Manage Instance and Azure SQL Databases.

Metrics

SQLDM-31946  SQL Diagnostic Manager correctly reports the correct values for the SQL Server Usage (Percent) metric.

SQLDM-31556  SQL Memory Usage metric correctly calculates the percentage of the total memory used by Azure SQL servers.

SQLDM-31298  SQL Server Agent Long Running Job (Percent) metric now provides the correct value.

Queries

SQLDM-31965  SQL Diagnostic Manager correctly associates query data to the correct monitored instance.

SQLDM-31846  SQL Diagnostic Manager successfully gathers query data through Query Monitor on instances containing databases that have a trailing space in the database name.

SQLDM-31552  SQL Diagnostic Manager allows you to successfully refresh your data in any Query View.

SQLDM-31365  Users can now successfully configure the Query monitoring on any environment.

SQLDM-30967  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

SQLDM-30840.  History Browser successfully changes the custom settings when moved to other servers.

This build includes many fixed issues, including the following updates from previous releases.

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, SQL Diagnostic Manager sends the email with the correct data.

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-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.

Alerts

SQLDM-30461 Database Full (Percent) alert is woking as expected, it is not displaying false data.

SQLDM-30461 SQL Diagnostic Manager now successfully saves the Where metric severity has changed condition when it is checked or unchecked.

SQLDM-30768 SQL Diagnostic Manager correctly monitors the servers and SQLDM Management service memory consumption is as expected.

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 when the database is set to 'no autogrowth' and the alerts configuration is set to 'Yes, alert con the currently used size divided by the maximum possible size'.

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-31390 The All Servers Thumbnail view works as expected when a server alert triggers a status change.

SQLDM-31341 SQL Diagnostic Manager 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-31439 When a job exceeds the time limit, the SQL Server Agent Long Running Job (Percent) alert raises. If the job is stopped, completed, or canceled the alert is deactivated.

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 (AlwaysOn) 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-31785 SQL Diagnostic Manager now correctly triggers the Days since last backup alert for secondary replicas.

General

SQLDM-28362 SQL Diagnostic Manager now correctly detects the drives with WMI and OLE automation for added local instances.

SQLDM-30364 Desktop Console view keeps custom views changes after adding servers.

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-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 warnings 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 alert works as expected on secondary replica (always on) instances.

SQLDM-31473 Monitored AlwaysOn servers are successfully contacted, making the AlwaysOn Listener - DB accessible.

SQLDM-31646 Availability Group snapshots displays without any error message.

Upgrade

SQLDM-30360 The Aggregate Data SQLdmRepository works as expected after upgrading SQLDM to 10.4.2.20.

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-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-30332The correct value of the OS memory usage metric now displays in the dashboard graph and in the alert configuration.

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 with suppression value.

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 Days since last backup metric 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.

Queries

SQLDM-31435 Query Details are displayed by clicking the globe icon on Statement Mode and Signature Mode.

SQLDM-31540 SQL Diagnostic Manager now includes two options to collect session data for SQL Server: Collect extended data from session details and Collect extended data from locks and blocks.

SQLDM-31566 The Queries tab gets data loaded faster than before.

SQLDM-31642 The Queries view loads faster and work as expected.

Query Waits

SQLDM-29645 SQL Diagnostic Manager is loading correctly when Query Waits uses Extended Events.

Replication

SQLDM-31462 SQLDM allows monitoring Services from the Replication tab.

SQLDM-31300 SQL Diagnostic Manager now displays the correct Replication Topology 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.

History Browser

SQLDM-31199 The History Browser Range is properly populated according to the selected time range.

11.1 New Features

• SQL Diagnostic Manager includes full support for Amazon RDS.
• This release includes the completion of Amazon RDS alerts that were added in previous releases. These alerts include:
  • New alerts notify if the allocated resources are more than needed.
  • Added display for newly collected metrics.
• New Interface User features include UI Scaling (support for 4K monitors and scaled fonts) and a new dark mode theme.
• This version includes a new Heatmap view and Grid view improvements for monitored servers in the desktop console.
• Amazon RDS SQL Alerts and Alert Templates improvements.
• Prescriptive Analitycs improvements for Amazon RDS monitored servers.

11.1 Fixed Issues

History Browser

SQLDM-29103 The History Browser returns query results within a 60-seconds time frame

Metrics

SQLDM-29161 The SQL Server Agent Job (Percent) metric correctly calculates the percentage value.

SQLDM-30761 The 'Database Full (Percent) metric is working as expected when the Alert Suppression is configured.

SQLDM-30764 The default configuration of the "SQL Server Error Log" metric correctly applies the 10MB file size limit.

SQLDM-30770 The SQL Server Browser metric is no longer raising alerts when only a default instance exists on the monitored server.

SQLDM-30986 The "Days since last backup" metric is no longer raising alerts for read-only databases that have been excluded from the metric.

SQLDM-31110 The SQL Server Agent Job Failure metric correctly raises alerts as expected.

SQLDM-31237 The "Days since last backup" metric now correctly works in Availability Groups environments.

SQLDM-31239 The SQL Server Agent Status metric correctly returns to an OK state when the service is detected to have been started.

Alerts

SQLDM-29189 The "The deadlock victim was spid 0 with application name 'unknown' by user 'unknown' on host 'unknown" alerts are no longer displaying.

SQLDM-29208 Alert Response rules are now correctly starting Query-wait statistic collection as it was configured.

SQLDM-30465 Corrected various issues with the Deadlock graphs and Alerts view within the SQLDM Web Console.

SQLDM-30502 Fragmentation alerts are triggering successfully after performing an upgrade.

SQLDM-30782 SQL Diagnostic Manager now raises alerts for Database Full (percent) metric in console when filtering by percentage.

SQLDM-30963 The alert for the "Page Life Expectancy" metric now takes the correct thresholds showing the right alerts.

SQLDM-30973 The advanced "filter by percentage" option correctly raises alerts as expected.

SQLDM-31061 The advanced alert filter for the 'Data File Autogrowth' alert is now correctly excluding databases.

SQLDM-31297 SQL Diagnostic Manager automatically applies certain alert templates based on the server type of the monitored instance.

General

SQLDM-30069 The Database widget under the Overview screen is now displaying data for the historical mode.

SQLDM-30083 Monitored instances are now correctly removed from SQL Diagnostic Manager.

SQLDM-30977 SQL Diagnostic Manager is no longer encountering an overflow error when a monitored SQL Server Agent Job is running longer than usual.

SQLDM-31036 SQL Diagnostic Manager is correctly sending OK status notifications and email notifications.

SQLDM-31080 SQL Diagnostic Manager desktop console is no longer showing slow performance when monitoring a large number of instances.

SQLDM-31094 SQL Diagnostic Manager correctly applies baseline settings to other monitored instances.

SQLDM-31198 Customized Dashboards in the SQLDM Desktop Client are now correctly saved in the repository database.

SQLDM-31202 SQLDM successfully applies new baselines' configuration to monitored instances.

SQLDM-31420 Now SQL Diagnostic Manager successfully shows paging graphics in the Memory Screen of the Resources tab.

Services

SQLDM-30435 Improved the stability of the SQLDM Management Service.

Availability Groups

SQLDM-30512 SQL Diagnostic Manager now correctly monitors Availability Group servers with reading/write permissions.

Reports

SQLDM-31001 The Disk Statistic report is now correctly showing the total number of drives of a monitored server.

SQLDM-31106 When the user runs the report for CPU or Memory statistics selecting Show Baseline, it returns Actual and Baseline Stats.

SQLDM-31117 The "Top Query" report now works successfully for all production servers.

SQLDM-31152 The Database Growth Forecast report correctly categorizes system databases when using the database selector.

11.0 New Features

• SQL Diagnostic Manager includes full support for Azure SQL. This feature includes the following resources for the Azure SQL database:
  • The compatibility for Azure SQL Managed Instance with on-premises.
  • Elastic pools allow you to manage and scale multiple databases.
  • Single databases typically are used for development and small apps.
• This release includes the completion of Azure SQL alerts that were added in previous releases. Among other features, these alerts include:
  • New alerts notify if the allocated resources are more than needed.
  • New displays for newly collected metrics.
• New alert templates with revised thresholds and priority/rank specifically for DBaaS (Azure SQL and Amazon RDS)
• This version includes a new server wizard that uses Azure profile credentials, allowing you to discover other Azure DB assets.
• Azure profile credentials collect metrics from Azure monitor to extend SQL Diagnostic Manager.
• Prescriptive Analytics improvements, including new recommendations for Azure SQL DBaaS and Amazon RDS.

11.0 Fixed Issues

Alerts

SQLDM-29184 SQL Diagnostic Manager now correctly alerts table fragmentation based on the table size configuration.

SQLDM-30421 The advanced Alert Filter for the "Longest Running version Store Transaction (Minutes)" alert is working as configured.

SQLDM-30487 The 'Clear Alert" option in the 'Availability Group Role Change' alert has been restored.

SQLDM-30528 SQLDM shows "Recommendations are available" operational alert in the Active Alert list.

SQLDM-30788 SQLDM Disk space alerts are now correctly triggering after an upgrade.

SQLDM-30825 The Disk Full alerts are no longer triggered for excluded disks in the alerts configuration.

SQLDM-30963 SQL Diagnostic Manager now correctly shows the correct alerts and thresholds for page life expectancy metric when using the Critical-Only Template.

SQLDM-31039 The "Show Historical View" button in the Alerts Tab is now working as expected.

Alert Response

SQLDM-29208 The 'Enable the Query Wait' Alert Action will properly execute when an Alert Response is triggered.

Availability Groups

SQLDM-30083 SQL Diagnostic Manager no longer encounters an error when removing an instance that happens to be a replica within an availability group. 

SQLDM-30197 SQLDM now discovers preferred replica information from Availability Group settings.

Cloud Monitoring

SQLDM-30344 The notifications for blocked sessions and SQL Agent Job Failures when monitoring RDS instances are now working correctly.

Custom Counters

SQLDM-30385 The newly created custom counters are added to the existing templates and can be applied to new servers.

SQLDM-30524 The Custom Counter alerts when using T-SQL script are raising correctly.

Database

SQLDM-30575 The Database status is now displaying accurate status.

Extended Events

SQLDM-29005 SQLDM now correctly add new servers and allows to select 'Extended Events' as the collection method for the Activity Monitor.

SQLDM-29033 The performance of the query that collects Replication Statistics has been improved.

General

SQLDM-29384 SQL Diagnostic Manager now correctly monitors its own repository.

SQLDM-29408 SQLDM installation is now completing successfully when the service account credentials contain special characters.

SQLDM-30114 SQL Diagnostic Manager now correctly reports the Publisher Names for SQL Server 2016 SP2 or later.

SQLDM-30364 Desktop Console Views now correctly keeps the custom views.

SQLDM-30453 IDERA Newsfeed is correctly configured after installing SQL Diagnostic Manager.

SQLDM-30480 SQL Diagnostic Manager now correctly displays baselines.

SQLDM-30493 SQLDM Desktop console now correctly shows the critical SQL Server Service status.

SQLDM-30770 SQL Diagnostic Manager successfully checks SQL Browser Service Alert status when the Remote Administrative connection is disabled and there is only a default SQL Server instance installed.

SQLDM-30936 SQL Diagnostic Manager displays the correct information when you select a secondary tab.

SQLDM-31025 The pause button now correctly works and it is integrated with the refresh button.

SQLDM-31042 SQL Diagnostic Manager now correctly displays the "Session Details" grid.

SQLDM-31068 The Query History view under the Queries tab is working as expected.

SQLDM-31070 The "View Session Details" option is now correctly working.

SQLDM-31071 The "View Locks" option is now correctly working.

Graphs

SQLDM-29069 The 'Disk busy per disk' metric graph now correctly loads under the Disk option from the Resources tab.

SQLDM-30037 The blocking displayed in the reports and in the graphs are synced correctly.

SQLDM-30137 The Alert Configuration window is no longer displaying inaccurate threshold graphs.

Hyper-V

SQLDM-28327 SQL DM successfully connects to Hyper-V Host Configuration.

IDERA Dashboard

SQLDM-30032 SQLDM web console is no longer reporting FIPS compliant environment errors.

SQLDM-30260 The IDERA Dashboard login information is now correctly encrypted.

SQLDM-30350 The SQLDM Web Console no longer encounters exceptions when IDERA Dashboard and the monitored instances are in different time zones.

SQLDM-30526 The Overview tab in the web console is no longer displaying an exception when clicking the summary under the Active Alerts widget.

Maintenance Mode

SQLDM-30686 SQL Diagnostic Manager no longer erroneously reporting "Maintenance mode started" when maintenance mode has been disabled.

Notifications

SQLDM-30859 The Databases category metrics now correctly raise alerts and send email notifications.

Query Monitor

SQLDM-30397 SQLDM now correctly creates historical snapshots when Query Monitor is enabled and configured to use Query Store.

SQLDM-30664 Powerscript now successfully enables Query Monitor.

Reports

SQLDM-21051 SQLDM successfully runs SSRS reports when more than 126 instances are selected.

Services

SQLDM-28648 SQLDM successfully collects information for disk drives volume formatted in ReFS.

Upgrade

SQLDM-30170 After upgrading SQLDM from 10.3 to 10.4 version, the Queries tab now correctly loads information.

SQLDM-30312 SQLDM now correctly triggers and notifies alerts for the Session CPU Time after performing an upgrade.

10.5.1 New Features

• SQL Diagnostic Manager now includes a new Server Uptime report.
• This release includes three new default values for the History Browser range.
• The "Days since last backup" alert configuration includes the option to include or exclude Read-Only databases.
  

10.5.1 Fixed Issues

Alerts

SQLDM-28938 The SQLDM Desktop Console now displays the correct alerts when hovering the mouse over an object on the Server pane.

SQLDM-29434 Alert timeline view is now displaying the time based on the Operating System settings.

SQLDM-29594 SQL Diagnostic Manager now correctly checks and alerts High Fragmentation on the databases.

SQLDM-29840 Alert Suppression for the SQL Server Service metric is now working as expected.

SQLDM-30434 Alert Responses no longer requires the 'Where Alert Rank' option to be enabled in order to be triggered as expected.

Upgrade

SQLDM-30381 Upgrade attempts of SQL Diagnostic Manager should no longer encounter an error regarding a constraint on the CloudProviders table.

SQLDM-30370 An issue preventing upgrades from versions 10.4.2 and 10.4.3 has been resolved.

SQLDM-30369 The custom Dashboards are no longer being deleted when upgrading from SQLDM 10.4.

Azure

SQLDM-29523 The snapshot data collection is no longer failing for Azure SQL PaaS instances.

SQLDM-30299 SQL Diagnostic Manager now correctly monitors Azure DBaaS and is no longer displaying errors.

SQLDM-30188 SQL Diagnostic Manager now correctly displays Session details on Azure SQL Database.

SQLDM-30013 SQLDM now correctly displays databases hosted in Azure SQL PaaS.

Desktop Console

SQLDM-29782 Powered off instances are no longer shown as active in the SQLDM console.

SQLDM-30244 The SQLDM Desktop Console will now properly convert the timestamps to local time when viewing the backup/restore history of a database.

SQLDM-30136 SQL Diagnostic Manager will now generate a warning when the SQLDM Desktop Console is launched if it determines that the license key will be expiring soon.

Custom Counters

SQLDM-30100 The Custom Counter reports now correctly displays data.

Query Waits

SQLDM-29671 SQLDM now correctly shows the Query Wait collector status.

SQLDM-30098 The timeline on the Query Waits view will now be displayed in the correct order.

SQLDM-30012 SQL Diagnostic Manager now correctly detects all the specific disk drives for each SQL Server registered.

Services

SQLDM-29997 SQLDM desktop console now correctly connects to the SQLdmManagement Service and is no longer throwing exception errors.

IDERA Dashboard

SQLDM-20002 The SQLDM Web Console now displays timestamps using local time.

SQLDM-28516 The SQLDM Web Console now correctly displays the Last Backup Date of a database.

SQLDM-29921 SQL Diagnostic Manager can now be manually registered in the IDERA Dashboard.

vCenter

SQLDM-29900 vCenter servers for monitored SQL servers in SQLDM can be added without problems.

Metrics

SQLDM-29802 *The 'Days since last backup' metric has been updated to include additional advanced options specific for availability groups.

SQLDM-29785 SQLDM now properly monitors the status of DTC and SQL Server Agent when collecting operating system statistics using OLE Automation.

Reports

SQLDM-28878 The Disk Space Usage report in the SQL Server Reporting Services portal is no longer asking the value for the Disk parameter.

SQLDM-29020 SQL Diagnostic Manager now collects deadlocks in Session > Blocking View and in Reports when using Extended Events or SQL Trace.

SQLDM-29685 Database Growth Forecast report now correctly shows sufficient data.

Availability Groups

SQLDM-19304 The "Aggregate Data SQLdmRepository" and "Groom SQLdm Repository" SQL Agent jobs now correctly run when the SQLDM Repository Database is hosted in an availability group.

SQLDM-28366 SQL Diagnostic Manager is now showing correct mount points for monitored secondary replicas.

SQLDM-20369 The databases in an SQLDM Availability Group now correctly capture growth statistics.

SQLDM-28629 SQLDM Desktop Console no longer crashes when accessing the Availability Group view under Databases.

SQLDM-28907 Improve the load time on the Availability Group databases view.

SQLDM-29229 SQL Diagnostic Manager is no longer displaying errors and is successfully connected to servers holding repositories in an availability group without a listener.

SQLDM-29547 SQLDM is no longer having problems collecting Database size data when monitoring Availability Groups instances.

Wait Statistics

SQLDM-29463 The Wait statistics are no longer displaying inconsistent values.

Deadlock

SQLDM-29006 The SQL Queries from the deadlock drop down output are no longer truncated.

Other issues

SQLDM-28694 SQLDM now correctly shows the closest historical snapshot when switching servers.

SQLDM-28606 SQLDM no longer generates login failures for 'SQLDiagMgr' in the SQL Server Error Log.

SQLDM-28603 SQL Diagnostic Manager now correctly shows the table sizes.

SQLDM-28327 SQLDM now correctly collects the CPU virtualization information on Hyper-V virtual environment.

10.5 New Features

• SQL Diagnostic Manager now includes Prescriptive Analysis improvements (embedded SQL Doctor), updated user interface that matches SQL Doctor workflows, and updated recommendations (specifically for Azure SQL and Amazon RDS).
• This release includes Cloud DBaaS user interface improvements that ease the management of Azure SQL and Amazon RDS management supported metrics.
• SQL Diagnostic Manager now includes Alerting improvements:
  • New alert templates with revised thresholds and ranks.
  • New conditions for Alert Responses.
  • New Alert filter to avoid false positives from spikes, filter by percentage of time over a period exceeding threshold.
  • PowerShell command to Apply Alert template.
  • New Alerts and metrics for Azure SQL and Amazon RDS specifically.
  • All alert priority levels were updated for existing alerts and for user customization. 
  • New alert template reports.

10.5 Fixed Issues

Alerts

SQLDM-19380 The Alert Suppression settings for the Availability Group Synchronization Health metric now functions as expected.

SQLDM-28167 Alert Summary for the Blocking Session Wait Time (Seconds) metric is not displaying time using the local time zone.

SQLDM-29019 The alerts "SQL Server Agent unable to monitor" and "WMI service is unavailable" are no longer triggered when the monitored servers are successfully connected to the WMI service.

Analysis

SQLDM-26371 SQL Diagnostic Manager is no longer prompting an error when performing an Analysis, which was caused by the Prescriptive Service not installing "TracerX.Logger.dlll" file.

SQLDM-28684 History Browser is no longer used for Prescriptive Analytics with the revised interface.

SQLDM-29891 SQL Diagnostic Manager now successfully completes analysis and the results are displayed as expected.

Web Console

SQLDM-28317 The SQL Diagnostic Manager Web Console correctly displays the statuses of monitored instance.

SQLDM-29215 The SQL Diagnostic Manager Web Console now correctly honors the Application Security settings that is configured in the SQL Diagnostic Manager Desktop Console.

SQLDM-30087 The IDERA Dashboard now correctly displays the federation drop down menu.

Metrics

SQLDM-28570 The 'Days since last backup' metric no longer generates alerts for databases that have never been backed up

SQLDM-29192 The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds).

SQLDM-29425 When configuring the "Oldest Open Transaction" metric, SQL Diagnostic Manager now correctly saves the exclusion filter value when wildcards are used.

Desktop Console

SQLDM-28912 Improved the performance of the SQL Diagnostic Manager Desktop Client when updating properties of a monitored SQL Server instance.

SQLDM-29467 Index rebuilding operation in SQLDM desktop console now correctly works and is no longer displaying errors.

Reports

SQLDM-28960 The Deadlock Report now correctly displays all the information about the deadlocks occurred in the monitored instances.

SQLDM-29427 The error "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" is no longer displaying when running the "Detailed Session Report".

SQLDM-29689 The Deadlock Report now correctly shows the total number of deadlocks.

SQLDM-29767 The Database Statistics report no longer encounters a timeout error when generating the report.

SQLDM-29917 The Detailed Session Report now successfully deploys to SSRS.

Services

SQLDM-29432 When monitoring a SQL Server instance using a privilege minimized user, Query Monitor and Wait Statistics collection will now resume upon a restart of the SQL Diagnostic Manager services.

SQLDM-29521 The SQLDM Management Service no longer crashes when a server has been registered as a Linux instance.

SQL Server supported versions

SQLDM-29447 SQL Diagnostic Manager now correctly monitors SQL Server 2000 instances.

SQLDM-29545 SQLDM now correctly monitors SQL Server 2005 instances.

SQLDM-29658 The error "SQL Agent unable to monitor" is no longer prompting when monitoring instances running specific SQL Server versions.

Memory

SQLDM-29492 SQLDM now correctly shows the OS memory usage on the newly added servers.

Upgrade

SQLDM-29529 The "Error interpreting File Activity Collector: Invalid column name 'unused_size'" error is no longer displaying after upgrading to SQLDM 10.3.

SQLDM-29715 The SQLDM desktop console now correctly works after an upgrade to 10.3.1 version.

Sysadmin Permissions

SQLDM-29931 SQL Diagnostic Manager no longer generates an error message indicating that sysadmin rights are required in order to collect OS Metrics.

Mirroring

SQLDM-29985 SQLDM now correctly refreshes the Mirroring history of a database.

Query Waits

SQLDM-30183 The refresh error when navigating in the Query Waits screen is no longer displaying.

Azure

SQLDM-30189 SQL Diagnostic Manager is no longer generating an error related to Procedure Cache when monitoring Azure SQL Database.

10.4 New features

• Visual Query Plans is now available for launch in the Windows Client context from any query.
• SQL Diagnostic Manager includes an improved collection of Extended Event query plans.
• This release includes new options to exploit Query Store collections for query waits, query plans, and query performance.
• Improved IDERA Dashboard with new alerts grid and instance lists.

10.4 Fixed Issues

Maintenance Mode

SQLDM-27123 Enabling maintenance mode on an ad-hoc basis no longer purges the scheduled maintenance mode settings. This allows users to easily restore schedule maintenance mode settings as needed.

Azure Databases

SQLDM-27933 The SQL Diagnostic Manager Desktop Client is no longer returning error messages when viewing data on monitored Azure Databases.

Metrics

SQLDM-28314 The metric "SQL Server Log size" is triggering alerts as expected.

Web Console

SQLDM-28317 The SQL Diagnostic Manager Web Console is correctly reporting the statuses of the monitored SQL Server instances.

SQLDM-29173 Improved performance of the SQL Diagnostic Manager Web Console.

SQLDM-29205 The SQL Diagnostic Manager Web console correctly recognizes users configured in Application Security.

Deadlocks

SQLDM-28568 SQL Diagnostic Manager is no longer reporting persistent deadlocks from the [p_InsertDatabaseSize] procedure.

Desktop Console

SQLDM-28572 The SQL Diagnostic Manager Desktop Client now correctly displays dates based on the Operating System settings.

SQLDM-28602 The SQLDM Graphical User Interface now correctly responds and no longer hangs.

SQLDM-28912 Improved performance when updating Monitored SQL Server Properties within the SQL Diagnostic Manager Desktop Client.

SQLDM-29220 The Desktop console is no longer displaying random exceptions.

Alerts

SQLDM-28666 SQL Diagnostic Manager now correctly sends alerts in a timely manner via email.

SQLDM-28824 SQLDM now correctly imports Alert templates.

SQLDM-28938 When hovering over a monitored instance on the Servers panes view, the displayed tooltip now correctly displays the current active alerts.

SQLDM-28940 The Alert suppression threshold now correctly works and triggers alerts as expected.

Powershell

SQLDM-29192 The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds).

Table Statistics

SQLDM-29404 Table Statistics collection is now properly excluding specified databases that are hosted on a case sensitive collation.

Reports

SQLDM-29429 The Enterprise Summary report now correctly lists the SQL Server version of the monitored instances.

Services

SQLDM-29437 Improved memory consumption by the SQLdm Management Service.

SQLDM-29505 The SQLdm Management Service remains in a running state if the SQL Server instance hosting the SQLdm Repository database is unavailable.

SQLDM-29512 SQL Diagnostic Manager will correctly report the status of the SQL Server Agent Service on SQL Server 2008 R2 instances.

10.3.1 New features

No new features for this release.

10.3.1 Fixed Issues

Desktop console

SQLDM-29486 The SQL Diagnostic Manager Desktop Client is no longer encountering latency issues when navigating between monitored instances.

Upgrade

SQLDM-29459 SQLdm Collection services is no longer causing high CPU and network usage after performing an upgrade.

SQLDM-29448 After performing an upgrade to SQL Diagnostic Manager 10.3, the job "Aggregate Data SQLdmRepository" is no longer reporting timeouts.

SQLDM-29505 The SQLdm Management service starts automatically after the upgrade.

10.3 New features

• SQL Diagnostic Manager is able to monitor SQL Server 2017 instances running on Windows or Linux operating systems.
• SQL Diagnostic Manager now includes a new operator security role.
• This release include new grooming and aggregation options for long term forecasting metrics for disks, databases, and tables.

10.3 Fixed Issues

Alerts

SQLDM-28824 SQL Diagnostic Manager now correctly imports alert templates.

SQLDM-28940 The alert suppression threshold now correctly works in SQL Diagnostic Manager.

SQLDM Desktop Client

SQLDM-28844 An unhandled exception is no longer being encountered when accessing the Queries tab in the SQL Diagnostic Manager Desktop Client.

Amazon RDS

SQLDM-28932 When monitoring an Amazon RDS SQL Server instance, SQL Diagnostic Manager is no longer encountering the ‘The EXECUTE permission was denied on the object 'xp_fixeddrives', database 'mssqlsystemresource', schema 'sys'’ exception.

Services

SQLDM-28957 The SQLdm Management Service is no longer encountering issues when reading metric threshold settings from the repository database.

Custom Counters

SQLDM-29015 SQL Diagnostic Manager is no longer reporting the error: "Unable to connect to SQL Instance - Custom counters file view is out of memory"

10.2.3 New Features

No new features for this version.

10.2.3 Fixed Issues

Installation and Upgrade                                                                               

• The reported issues when re-installing SQL Diagnostic Manager with a pre-existing repository, have been solved.
• The ongoing SSL errors when attempting to install SQL Diagnostic Manager have been solved for this version.
• The Unable to monitor error "Error interpreting Job Alerts Collector: Invalid column name 'job_last_run_duration'."  is no longer displaying when running an upgrade.
• SQL Diagnostic Manager now correctly displays historical snapshots after upgrading.

Analysis

• SQL Diagnostic Manager now correctly displays accurate results when running an Analysis.       

Availability Groups

• SQL Diagnostic Manager now correctly connects to Availability Group listeners, and monitoring AlwaysOn instances.

Graphs

• The Session Statistics graph is no longer having issues showing the Y-axis values of the Transactions per Minute graph.

WMI

• The reported problem of WMI not being available on some servers has been fixed.

Dashboard

• IDERA Dashboard is no longer reporting maintenance mode status in actively monitored instances.
• The IDERA Dashboard is displaying data in the Queries view screen, the message "No Data Available. Please try after some time" is no longer showing.
• The IDERA Dashboard is now allowing access to the web console through domain groups and individual accounts.
• Users are no longer having issues when they manually register SQL Diagnostic Manager in the Dashboard.

Services

• The error displayed in the desktop console, when users were trying to connect to the SQLdm Management service, has been fixed.
• SQL Diagnostic Manager is now correctly firing alert emails when the SQLdm Collection service is down.

Metrics                    

• The changes that users applied to the metrics in the default templates are no longer causing errors.

Grooming

• SQL Diagnostic Manager is no longer displaying erroneous time-range data in the ChangeLog and is complying the user grooming configuration.
• The DatabaseFileStatistics grooming is running as expected and it has stopped timing out.

SQLDM Mobile

• The reported problem when running queries in SQLDM Mobile is no longer an issue in Chrome and other browsers.

Alert Rules and Alert Responses

• SQL Diagnostic Manager now correctly generating emails for all the configured Alert Rules that has the "Where metric severity has changed" option enabled.
• SQLDM is now sending alerts to SCOM for the metrics and severities specified in the rule, without disruption.
• The Alert Response "Send all Alerts to Scom as Alerts" is no longer having issues when the default configuration is changed.
• When the default configuration is changed in the Alert Response "Send all Alerts to SCOM as Alerts", these changes are correctly applied and work as expected.

Alerts

• SQL Diagnostic Manager is notifying the user by email when the alert "Blocking Session Wait Time" has a critical status.

Other issues

• The Sessions, Queries, and Query Waits screens in the desktop console are displaying data normally.             
• The errors in the details of a Deadlock occurrence caused by an "intra-query parallelism deadlock" have been fixed.
• SQLDM now correctly displays query data statements. All queries are matching up with their associated databases.                   
• The error: "Key already exists, Parameter name key (Infragistics2.Shared.v10.3)" is no longer displaying when removing the Details column in the Signature Mode screen located in the Query Monitor.             
• The problem that users had when creating custom dashboard in the SQL Diagnostic Manager web console, has been solved.
• The friendly names are no longer being removed by SQL Diagnostic Manager.

10.2.2 New features

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.

10.2.1 New features

No new features for this version.

10.2.1 Fixed issues

SQLDM Desktop console

The exception displayed when accessing Sessions > Locks is no longer shown.

The Sessions Details view and the Locks view are displaying normally. The “Sysadmin privileges to obtain data for this view” message is no longer showing in these views.

Grooming

SQL Diagnostic Manager is no longer displaying false grooming alerts.

10.2 New features

SQL Diagnostic Manager

SQL Diagnostic Manager has performance improvements, focus on an extensive scalability and user productivity improvements which involve faster startup time and faster connectivity between SQL Diagnostic Manager and SQL Workload Analysis.

SQL Workload Analysis integration

SQL Diagnostic Manager allows you to launch SQL Workload Analysis in context of your monitored server from the desktop console and the IDERA Dashboard. For more information, see Launch SQL Workload Analysis.

Time-based drilldown any graph in the desktop console and in the web console to select any time range to zoom in for more detail.

SQL Workload Analysis launch points in different components of SQL Diagnostic Manager desktop and web console.

History browser

SQL Diagnostic Manager has a new History Range Control in the desktop console and web console that allows you to choose the time range you need, specifying the start time and end date; as well as current snapshot.

10.2 Fixed issues

Always On availability groups

An issue that caused CPU spikes on the primary node of a monitored Always On availability group has been fixed.

Alerts

SQL Diagnostic Manager is no longer reporting problems when displaying alerts and snapshots.

The active Alerts are displayed normally in the SQLDM web console.

The "Unable to monitor" alert related to the following description: "[Server Name]Error interpreting Job Alerts Collector: Column name or number of supplied values does not match table definition. [Server Name] Error executing Job Alerts collector: Column name or number of supplied values does not match table definition" is no longer displaying after an upgrade.

Services

The high memory consumption and the constant crashing of the SQLdm Collection service and the SQLdm Management service are no longer occurring.

An issue that would stop the SQLDM Collection Service from monitoring one or more SQL instances has been fixed.

The SQLDM Management Service no longer crashes when it encounters a malformed Alert Rule.

Cloud instances

While monitoring RDS SQL Server instances, SQLDM is no longer receiving errors while navigating through the panes in the desktop console.

SQL Diagnostic Manager provides the following new features and fixed issues.

IDERA |  Products | Purchase | Support | Community | Resources | About Us | Legal