SQL Diagnostic Manager provides the following new features and fixed issues:.
...
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.
| 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.1 Fixed Issues
...
28938 The SQLDM Desktop Console now displays the correct alerts when hovering the mouse over an object on the Server pane"Server Uptime" report records the correct values for the uptime and downtime of a specific instance.29434The Database Statistics report is now generating data correctly for a custom range of time Alert timeline view is now displaying the time based on the Operating System settings.
29594 The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager now correctly checks and alerts High Fragmentation on the databases.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2984031683 |
|---|
|
Alert Suppression for the SQL Server Service metric is now working as expected SQL Diagnostic Manager correctly identifies query records where query plans have been successfully collected.
30434 Alert Responses no longer requires the 'Where Alert Rank' option to be enabled in order to be triggered as expected.
...
SQL Diagnostic Manager successfully generates the "Template Comparison" report.
Alerts
30381 Upgrade attempts of SQL Diagnostic Manager should no longer encounter an error regarding a constraint on the CloudProviders tableaccurately displays alert data in the Historical Snapshots tooltip for a specific instance.30370 An issue preventing upgrades from versions 10.4.2 and 10.4.3 has been resolved SQL Diagnostic Manager correctly applies the "Where metric severity has changed is in place" alert rule.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-30369 |
|---|
|
The custom Dashboards are no longer being deleted when upgrading from SQLDM 10.4.
Azure
The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.
29523 The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds The snapshot data collection is no longer failing for Azure SQL PaaS instances.
30299 The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully SQL Diagnostic Manager now correctly monitors Azure DBaaS and is no longer displaying errors.
30188 SQL Diagnostic Manager now correctly displays Session details on Azure SQL Databaseprovides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+).
-30013 SQLDM now correctly displays databases hosted in Azure SQL PaaS.
...
You can successfully configure e-mail notifications, including "and" conditions.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31737 |
|---|
|
You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31256 |
|---|
|
The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details.
29782 Powered off instances are no longer shown as active in the SQLDM console. SQL Diagnostic Manager only displays the active alerts on the environment views.
Alerts Response
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3024432215 |
|---|
|
SQL Diagnostic Manager improved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a ruleThe SQLDM Desktop Console will now properly convert the timestamps to local time when viewing the backup/restore history of a database.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3013632030 |
|---|
|
After upgrading to SQLDM 12, 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
maintains the "Email (SMTP) Provider" alert response configuration.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-30100 |
|---|
|
The Custom Counter reports now correctly displays data.
...
With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider.
29671 SQLDM now correctly shows the Query Wait collector status. You can successfully export and import SMTP alert responses using SQL Diagnostic Manager 12.3.
Custom Counters
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-30098 |
|---|
|
The timeline on the Query Waits view will now be displayed in the correct order SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3001230385 |
|---|
|
SQL Diagnostic Manager now correctly detects all the specific disk drives for each SQL Server registered.
...
successfully applies Custom Counter in new Servers when using templates.
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-29997 |
|---|
|
SQLDM desktop console now correctly connects to the SQLdmManagement Service and is no longer throwing exception errors.
...
SQL Diagnostic Manager allows selecting and applying custom counters to all servers when creating metric alert responses for cluster environments.
20002 The SQLDM Web Console now displays timestamps using local time. When using the SQL Diagnostic Manager manual Maintenance Mode, the instances remain linked to Custom Counters.
General
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31974 |
|---|
|
SQL Diagnostic Manager supports Extended Event Options for the Activity Monitor and the Query Monitor properties28516 The SQLDM Web Console now correctly displays the Last Backup Date of a database.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2992131303 |
|---|
|
SQL Diagnostic Manager can now be manually registered in the IDERA Dashboard.
...
allows user accounts to apply alert templates to a monitor instance.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2990030861 |
|---|
|
vCenter servers for monitored SQL servers in SQLDM can be added without problems.
...
SQL Diagnostic Manager improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32339 |
|---|
|
SQL Diagnostic Manager allows you to successfully add a new user through the Application Security tab29802 *The 'Days since last backup' metric has been updated to include additional advanced options specific for availability groups.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-29785 |
|---|
|
SQLDM now properly monitors the status of DTC and SQL Server Agent when collecting operating system statistics using OLE Automation.
...
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
28878 With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display The Disk Space Usage report in the SQL Server Reporting Services portal is no longer asking the value for the Disk parameter.
29020 SQL Diagnostic Manager now collects deadlocks in Session > Blocking View and in Reports when using Extended Events or SQL Traceallows you to grant users access to specific instances through the Application Security window.29685 Database Growth Forecast report now correctly shows sufficient data.
Availability Groups
You can successfully export the Analyze report of a monitored instance.
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 SQL Diagnostic Manager successfully displays the history browser for SQL Server Azure-managed instances.
28366 SQL Diagnostic Manager is now showing correct mount points for monitored secondary replicas.successfully monitors and displays information for scale-out installations, showing the correct version.
On-Premises
20369 The databases in an The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
SQLDM Availability Group now correctly capture growth statistics.
28629 SQLDM Desktop Console no longer crashes when accessing the Availability Group view under DatabasesWeb Console successfully displays all the alerts of the monitored instances after an upgrade.28907 Dates are now displayed in the proper format on SQLDM Web Console Improve the load time on the Availability Group databases view.
29229 SQL Diagnostic Manager is no longer displaying errors and is successfully connected to servers holding repositories in an availability group without a listenercorrectly displays graphics in the Web Console, since the graphics order has been fixed.
29547 SQLDM is no longer having problems collecting Database size data when monitoring Availability Groups instances.
...
SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
29463 The Wait statistics are no longer displaying inconsistent values.
...
The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.
High Availability Groups
29006 The SQL Queries from the deadlock drop down output are no longer truncated.
Other issues
"Days since the last backup" alert functions as intended according to the backup preference settings for High Availability Groups.
28694 SQLDM now correctly shows the closest historical snapshot when switching servers. SQL Diagnostic Manager successfully monitors listener status in a High Availability environment while monitoring replicas.Upgrade
28606 SQLDM no longer generates login failures for 'SQLDiagMgr' in the SQL Server Error Log. SQL Diagnostic Manager displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4
28603 After upgrading, SQL Diagnostic Manager now correctly shows the table sizesdoes not raise any unhandled exception related to missing files.
28327 SQLDM now correctly collects the CPU virtualization information on Hyper-V virtual environment....
| 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 |
|---|
|
...
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.
...
| Newtabfooter |
|---|
| alias | About Us |
|---|
| url | http://www.idera.com/about/aboutus |
|---|
|
...