SQL Diagnostic Manager provides the following new features and fixed issues.
...
12.
...
- 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
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....
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.
...
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-2793332393 |
|---|
|
The SQL Diagnostic Manager
Desktop Client is no longer returning error messages when viewing data on monitored Azure Databases....
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.28314 The metric "SQL Server Log size" is triggering alerts as expected.
...
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.
28317 The SQL Diagnostic Manager Web Console is correctly reporting the statuses of the monitored SQL Server instancesprovides 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.
29173 You can successfully generate "Alert Forecasts" for Active Alerts in Improved performance of the SQL Diagnostic Manager Web Console12.3.
29205 The SQL Diagnostic Manager Web console correctly recognizes users configured in Application Security.
...
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-2856832215 |
|---|
|
SQL Diagnostic Manager is no longer reporting persistent deadlocks from the [p_InsertDatabaseSize] procedure....
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.
28572 The With SQL Diagnostic Manager Desktop Client now correctly displays dates based on the Operating System settingsyou 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.
28602 The SQLDM Graphical User Interface now correctly responds and no longer hangs. 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-2891231974 |
|---|
|
Improved performance when updating Monitored SQL Server Properties within the SQL Diagnostic Manager Desktop Client 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.
29220 The Desktop console is no longer displaying random exceptions.
...
SQL Diagnostic Manager improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2866632339 |
|---|
|
SQL Diagnostic Manager now correctly sends alerts in a timely manner via emailallows 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.
28824 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 SQLDM now correctly imports Alert templates.28938 When hovering over a monitored instance on the Servers panes view, the displayed tooltip now correctly displays the current active alerts. 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-2894031859 |
|---|
|
The Alert suppression threshold now correctly works and triggers alerts Permissions Script for User Creation was successfully improved and now works as expected....
IDERA Web Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29192 |
|---|
|
The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds)....
SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade.29404 Table Statistics collection is now properly excluding specified databases that are hosted on a case sensitive collation.
...
Dates are now displayed in the proper format on SQLDM Web Console.
29429 The Enterprise Summary report now correctly lists the SQL Server version of the monitored instances.
...
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.
29437 The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.
High Availability Groups
Improved memory consumption by the SQLdm Management Service.29505 The SQLdm Management Service remains in a running state if the SQL Server instance hosting the SQLdm Repository database is unavailable"Days since the last backup" alert functions as intended according to the backup preference settings for High Availability Groups.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2951231875 |
|---|
|
SQL Diagnostic Manager will correctly report the status of the SQL Server Agent Service on SQL Server 2008 R2 instances....
successfully monitors listener status in a High Availability environment while monitoring replicas.
Upgrade
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-32421 |
|---|
|
SQL Diagnostic Manager
...
| Newtabfooter |
|---|
| alias | IDERA |
|---|
| url | http://www.idera.com |
|---|
|
| | Newtabfooter |
|---|
| alias | Products |
|---|
| url | https://www.idera.com/productssolutions/sqlserver |
|---|
|
| | Newtabfooter |
|---|
| alias | Purchase |
|---|
| url | https://www.idera.com/buynow/onlinestore |
|---|
|
| | Newtabfooter |
|---|
| alias | Support |
|---|
| url | https://idera.secure.force.com/ |
|---|
|
| | Newtabfooter |
|---|
| alias | Community |
|---|
| url | http://community.idera.com |
|---|
|
| | Newtabfooter |
|---|
| alias | Resources |
|---|
| url | http://www.idera.com/resourcecentral |
|---|
|
| | Newtabfooter |
|---|
| alias | About Us |
|---|
| url | http://www.idera.com/about/aboutus |
|---|
|
| | Newtabfooter |
|---|
| alias | Legal |
|---|
| url | https://www.idera.com/legal/termsofuse |
|---|
|
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.
...