SQL Diagnostic Manager provides the following new features and fixed issues.
...
12.
...
3 New Features
SQL Diagnostic Manager
...
presents the following features and enhancements:
- Improved workflow, easing navigation in the desktop Client console.
- Expandable Servers sidebar, allowing users to have a larger screen space.
- Dock and undock user interface components to optimize usage in multi-monitor environments .
- Search bar eases the search of monitored instances in large scale deployments.
- Searchable drop-down instance name navigation without changing drill-down.
- History Range control is now available for historical or real-time analysis.
- Advanced sessions filter by application adds to powerful analysis options including drag-and drop “Group By” options.
...
- An Improved User Interface with the following changes:
- A new organization Grid View which allows a better glance at your instance metrics and properties.
- An updated Windows Console Grid View similar to SQL Diagnostic Web Console.
- A renovated Card View style, providing you with the same reliable information with a better-summarized look.
- An improved administration dialog to change the scale Health Index Factor for SQL Diagnostic Manager Console.
- A new Search feature for handling long lists across your servers, filters, alerts, and more.
A Step Forward or Backward with the drill-down option.
| Info |
|---|
Administrative actions are not included, only the actions associated with drill-downs are maintained. |
- A new Automated Responses for ServiceNow action providers. To configure it, you must provide the Service Now information such as URL, Username, Password, and Alert Source.
12.3 Fixed Issues
Reports
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32143 |
|---|
|
The "Server Uptime" report records the correct values for the uptime and downtime of a specific instance.| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-31873 |
|---|
|
The Database Statistics report is now generating data correctly for a custom range of time.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31680 |
|---|
|
The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31683 |
|---|
|
SQL Diagnostic Manager correctly identifies query records where query plans have been successfully collected.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-30535 |
|---|
|
SQL Diagnostic Manager successfully generates the "Template Comparison" report.
Alerts
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-32393 |
|---|
|
SQL Diagnostic Manager accurately displays alert data in the Historical Snapshots tooltip for a specific instance.10.6 Fixed Issues
...
20300 SQL Diagnostic Manager now correctly alerts about DB data files sizing....
correctly applies the "Where metric severity has changed is in place" alert rule.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32194 |
|---|
|
The default value for the user field under the "Alternative Windows Authorization" feature is Blank now.
28237 The Longest Running Version Store Transaction (minutes) alert filter is working as expected and the email notification includes the stored comment in the alertPage Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds.
28711 The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32021 |
|---|
|
SQL Diagnostic Manager provides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+ The % wildcard for 'users' is now allowed by the Exclusion filter for the Session Tempdb Space Usage (MB).
-30139 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 The Alert Suppression configuration is no longer causing an incorrect status of the monitored instance.
30392 The Databases Exclusion configuration in the Advanced Alert filter is working as expected.
...
"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
29410When maintenance mode is enabled, custom counters are no longer collected as expected SQL Diagnostic Manager improved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule.29697 Custom Counters are now correctly shown in the "Alert Configuration" window after the instance is linked to it After upgrading to SQLDM 12, SQL Diagnostic Manager maintains the "Email (SMTP) Provider" alert response configuration.
29907 Custom Counters can be remove/unlinked from a monitored instance from the Monitored SQL Server Properties window.
...
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
23252 The installation script for the Model database sizing is now working correctly SQL Diagnostic Manager keeps a Server's Custom Counter configuration after changing its tags configurations.
28800 The Database Analysis is now reporting the correct schema.
...
SQL Diagnostic Manager successfully applies Custom Counter in new Servers when using templates.
29209 The new added panels to SQLDM Desktop Client are displaying correct values when loading data from the repository.
...
SQL Diagnostic Manager allows selecting and applying custom counters to all servers when creating metric alert responses for cluster environments.
29109 The Disks Drives on a newly registered server are now correctly discoverable using OLE automation or WMI.
...
When using the SQL Diagnostic Manager manual Maintenance Mode, the instances remain linked to Custom Counters.
General
30011 SQLDM now correctly collects query data through Extended Events....
SQL Diagnostic Manager supports Extended Event Options for the Activity Monitor and the Query Monitor properties.19742 SQLDM has been updated to include the latest SQL Server service packs and/or cumulative updates when viewing version details SQL Diagnostic Manager allows user accounts to apply alert templates to a monitor instance.
29182 SQL Diagnostic Manager correctly generates alerts for the SQL Server Error Log metric when the Advanced Alert Filters are definedimproved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32339 |
|---|
|
SQL Diagnostic Manager allows you to successfully add a new user through the Application Security tab.29403 SQL Diagnostic Manager now correctly reports the correct Cumulative Updates for the monitored instances.
...
fixed the performance of the Analyze view, generating recommendations properly.
29130The widgets in the IDERA Dashboard are rendering properly after selecting an identifier for a custom dashboard With SQL Diagnostic Manager, you can personalize the dashboard view by choosing a specific dashboard to display.
29212SQL Diagnostic Manager now allows you to grant users access to specific instances through the Application Security window The Instance Status widget in the IDERA Dashboard is now correctly filtering non-active instances.30243 You can successfully export the Analyze report The properties of a monitored instance is now displaying as expected in both the SQLDM Desktop Console and the SQLDM Web Console.
Maintenance Mode
.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32178 |
|---|
|
SQL Diagnostic Manager successfully displays the history browser for SQL Server Azure-managed instances.
28446 The Servers now correctly follow the Maintenance Mode schedule.
...
SQL Diagnostic Manager successfully monitors and displays information for scale-out installations, showing the correct version.
On-Premises
5463 The "Mirroring Unsent Log" metric now triggers the Critical alert at a higher threshold value....
The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
28829 SQLDM is now correctly configuring the options for capturing query plans when enabling the options for Query Monitor when using the Add Servers Wizard SQLDM Web Console successfully displays all the alerts of the monitored instances after an upgrade.30464 The TempDB contention which caused blocking sessions when the Query Monitor is enabled, has been resolved.
...
Dates are now displayed in the proper format on SQLDM Web Console.
28219 SQL Diagnostic Manager correctly displays graphics in the Web Console, since the graphics order has been fixed The 'Disk Space Usage Forecast' report now correctly exports to PDF.
29155 SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly The Alert History report is now displaying all the historical alerts of the specified period of time.
29401 The Detailed Session Report is now displaying all the expected data based on its configuration.
...
The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.
High Availability Groups
28108 The Free Disk column under the Disk Size option of the Resources tab now correctly sorts numerically.
...
"Days since the last backup" alert functions as intended according to the backup preference settings for High Availability Groups.
29458The SCOM integration after upgrading SQL Diagnostic Manager now works as expected....
successfully monitors listener status in a High Availability environment while monitoring replicas.
Upgrade
29428 The reported crashes of the SQLdm Management Service caused by configurations in certain Alert Response conditions, are no longer occurring. SQL Diagnostic Manager displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4
30393 The SQLdm Management service is no longer crashing when importing an alert action response rule.
...
After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files.
23196 The Session monitor now correctly displays the Job name along with the Job ID....
You can successfully upgrade SQL Diagnostic Manager to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags.28607When the SQL Server Agent Job Failure alert raises, the Details description no longer exposes sensitive information SQL Diagnostic Manager successfully updates snapshots and refreshes alerts after an upgrade.
29211 SQL Diagnostic Manager successfully triggers notifications for " The Advanced Filters for the SQL Server Agent Job Completion metric are no longer case sensitive.
...
| 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 |
|---|
|
...
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.