SQL Diagnostic Manager provides the following new features and fixed issues.
...
12.
...
3 New Features
SQL Diagnostic Manager
...
- 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.
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
10.5 Fixed Issues
...
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-1938032143 |
|---|
|
The Alert Suppression settings for the Availability Group Synchronization Health metric now functions as expected"Server Uptime" report records the correct values for the uptime and downtime of a specific instance.28167The Database Statistics report is now generating data correctly for a custom range of time Alert Summary for the Blocking Session Wait Time (Seconds) metric is not displaying time using the local time zone.
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.
...
"Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager.
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" filecorrectly identifies query records where query plans have been successfully collected.
28684 History Browser is no longer used for Prescriptive Analytics with the revised interface. SQL Diagnostic Manager successfully generates the "Template Comparison" report.
Alerts
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-2989132393 |
|---|
|
SQL Diagnostic Manager now successfully completes analysis and the results are displayed as expected....
accurately displays alert data in the Historical Snapshots tooltip for a specific instance.
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-2831732347 |
|---|
|
The SQL Diagnostic Manager Web Console correctly displays the statuses of monitored instanceapplies the "Where metric severity has changed is in place" alert rule.29215The SQL Diagnostic Manager Web Console now correctly honors the Application Security settings that is configured in the SQL Diagnostic Manager Desktop Console The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.
30087 The IDERA Dashboard now correctly displays the federation drop down menu.
...
Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds.
28570 The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully. The 'Days since last backup' metric no longer generates alerts for databases that have never been backed up
29192 SQL Diagnostic Manager provides all the information of the Blocking Session The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions 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.
29425 When configuring the "Oldest Open Transaction" metric, SQL Diagnostic Manager now correctly saves the exclusion filter value when wildcards are used.
...
You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31256 |
|---|
|
The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details.
28912 SQL Diagnostic Manager only displays the active alerts on the environment views.
Alerts Response
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32215 |
|---|
|
SQL Diagnostic Manager improved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32030 |
|---|
|
After upgrading to SQLDM 12, SQL Diagnostic Manager maintains the "Email (SMTP) Provider" alert response configuration Improved the performance of the SQL Diagnostic Manager Desktop Client when updating properties of a monitored SQL Server instance.
29467 Index rebuilding operation in SQLDM desktop console now correctly works and is no longer displaying errors.
...
With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-30889 |
|---|
|
You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.
Custom Counters
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32148 |
|---|
|
SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations.
28960 SQL Diagnostic Manager successfully applies Custom Counter in new Servers when using templates The Deadlock Report now correctly displays all the information about the deadlocks occurred in the monitored instances.
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". 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-29689 |
|---|
|
The Deadlock Report now correctly shows the total number of deadlocks SQL Diagnostic Manager supports Extended Event Options for the Activity Monitor and the Query Monitor properties.29767The Database Statistics report no longer encounters a timeout error when generating the report SQL Diagnostic Manager allows user accounts to apply alert templates to a monitor instance.
29917 The Detailed Session Report now successfully deploys to SSRS.
...
SQL Diagnostic Manager improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29432 32339 |
|---|
|
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 SQL Diagnostic Manager allows you to successfully add a new user through the Application Security tab.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-32267 |
|---|
|
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
29521 The SQLDM Management Service no longer crashes when a server has been registered as a Linux instance.
...
With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2944732232 |
|---|
|
SQL Diagnostic Manager now correctly monitors SQL Server 2000 instancesallows you to grant users access to specific instances through the Application Security window.29545 You can successfully export the Analyze report of a monitored instance SQLDM now correctly monitors SQL Server 2005 instances.
29658 The error "SQL Agent unable to monitor" is no longer prompting when monitoring instances running specific SQL Server versions.
...
SQL Diagnostic Manager successfully displays the history browser for SQL Server Azure-managed instances.
29492 SQLDM now correctly shows the OS memory usage on the newly added servers.
...
SQL Diagnostic Manager successfully monitors and displays information for scale-out installations, showing the correct version.
On-Premises
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29529 |
|---|
|
The "Error interpreting File Activity Collector: Invalid column name 'unused_size'" error is no longer displaying after upgrading to SQLDM 10.3. The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29715 32333 |
|---|
|
The SQLDM desktop console now correctly works SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade to 10.3.1 version....
.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32291 |
|---|
|
Dates are now displayed in the proper format on SQLDM Web Console.
29931 SQL Diagnostic Manager no longer generates an error message indicating that sysadmin rights are required in order to collect OS Metrics.
...
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.
29985 SQLDM now correctly refreshes the Mirroring history of a database.
...
The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.
High Availability Groups
30183 The refresh error when navigating in the Query Waits screen is no longer displaying.
...
The "Days since the last backup" alert functions as intended according to the backup preference settings for High Availability Groups.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3018931875 |
|---|
|
SQL Diagnostic Manager is no longer generating an error related to Procedure Cache when monitoring Azure SQL Database.| Scroll pdf ignore |
|---|
| 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 |
|---|
|
|
successfully monitors listener status in a High Availability environment while monitoring replicas.
Upgrade
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-32421 |
|---|
|
SQL Diagnostic Manager displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32299 |
|---|
|
After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32181 |
|---|
|
You can successfully upgrade SQL Diagnostic Manager to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32150 |
|---|
|
SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32026 |
|---|
|
SQL Diagnostic Manager successfully triggers notifications for "SQL Server Agent Job Failure" alerts after an upgrade.
DBaaS
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32221 |
|---|
|
SQL Diagnostic Manager keeps the last Sever selection and Time Period for using them when configuring a new report. Metrics
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32130 |
|---|
|
SQL Diagnostic Manager increased the maximum critical threshold value for the "Version Store Size (MB)" metric.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32109 |
|---|
|
SQL diagnostic Manager successfully displays the "SQL Server CPU Usage" metric after upgrading to SQLDM 12.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31812 |
|---|
|
The "Procedure Cache Hit Ratio" metric has been improved on Azure SQL Managed Instance and Azure DB.
Charts
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31870 |
|---|
|
SQL Diagnostic Manager correctly shows the Total Deadlock data in the Overview and Sessions charts after an upgrade.History Browser
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32019 |
|---|
|
SQL Diagnostic Manager successfully collects historical data in the History Browser for all the monitored servers.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-31951 |
|---|
|
SQL Diagnostic Manager correctly displays historical data for TempDB summary in the history browser and across multiple time ranges.
...