SQL Diagnostic Manager provides the following new features and fixed issues.
...
12.
...
3 New Features
SQL Diagnostic Manager
...
- New alerts notify if the allocated resources are more than needed.
- Added display for newly collected metrics.
...
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
11.1 Fixed Issues
...
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29103 |
|---|
|
The History Browser returns query results within a 60-seconds time frame...
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.
29161 The "Top Tables by Fragmentation" report now correctly identifies fragmented tables in the latest version of SQL Diagnostic Manager The SQL Server Agent Job (Percent) metric correctly calculates the percentage value.
30761 SQL Diagnostic Manager correctly identifies query records where query plans have been successfully collected The 'Database Full (Percent) metric is working as expected when the Alert Suppression is configured.
30764 The default configuration of the "SQL Server Error Log" metric correctly applies the 10MB file size limit. SQL Diagnostic Manager successfully generates the "Template Comparison" report.
Alerts
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-3077032393 |
|---|
|
The SQL Server Browser metric is no longer raising alerts when only a default instance exists on the monitored server SQL Diagnostic Manager accurately displays alert data in the Historical Snapshots tooltip for a specific instance.
| Status |
|---|
| |
|---|
| colour | Green |
|---|
| title | SQLDM-30986 |
|---|
|
The "Days since last backup" metric is no longer raising alerts for read-only databases that have been excluded from the metric SQL Diagnostic Manager 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.
31110 The Page Life Expectancy (Baseline) now works as expected, raising alerts according to the baseline thresholds The SQL Server Agent Job Failure metric correctly raises alerts as expected.
31237 The Resuming Alerts window displays all available alerts that can be snoozed or resumed successfully The "Days since last backup" metric now correctly works in Availability Groups environments.
31239 The SQL Server Agent Status metric correctly returns to an OK state when the service is detected to have been started.
...
SQL Diagnostic Manager provides all the information of the Blocking Session Wait Time (Seconds) alert when enabling Capture Blocking (SQL 2005+).
29189 You can successfully configure e-mail notifications, including "and" conditions The "The deadlock victim was spid 0 with application name 'unknown' by user 'unknown' on host 'unknown" alerts are no longer displaying.
29208 Alert Response rules are now correctly starting Query-wait statistic collection as it was configured You can successfully generate "Alert Forecasts" for Active Alerts in SQL Diagnostic Manager 12.3.
30465 The "Deadlock" alert is generated as expected and sends alert emails with correct and complete details Corrected various issues with the Deadlock graphs and Alerts view within the SQLDM Web Console.
30502 Fragmentation alerts are triggering successfully after performing an upgrade. SQL Diagnostic Manager only displays the active alerts on the environment views.
Alerts Response
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3078232215 |
|---|
|
SQL Diagnostic Manager now raises alerts for Database Full (percent) metric in console when filtering by percentageimproved the Alert Response Rules performance. Now you can successfully receive e-mails when creating or updating a rule.30963 After upgrading to SQLDM 12, SQL Diagnostic Manager maintains the "Email (SMTP) Provider" alert response configuration The alert for the "Page Life Expectancy" metric now takes the correct thresholds showing the right alerts.
30973 With SQL Diagnostic Manager you can correctly import a delete alert response containing an SMTP action provider The advanced "filter by percentage" option correctly raises alerts as expected.
31061 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 The advanced alert filter for the 'Data File Autogrowth' alert is now correctly excluding databases.
31297 SQL Diagnostic Manager automatically applies certain alert templates based on the server type of the monitored instancesuccessfully 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-30069 |
|---|
|
The Database widget under the Overview screen is now displaying data for the historical mode 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.
30083 Monitored instances are now correctly removed from SQL Diagnostic Manager improved the analyzer's performance, providing more accurate analysis recommendations.
DM Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3097732339 |
|---|
|
SQL Diagnostic Manager is no longer encountering an overflow error when a monitored SQL Server Agent Job is running longer than usualallows you to successfully add a new user through the Application Security tab.31036 SQL Diagnostic Manager is correctly sending OK status notifications and email notifications SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
31080 With SQL Diagnostic Manager desktop console is no longer showing slow performance when monitoring a large number of instances, you can personalize the dashboard view by choosing a specific dashboard to display.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3109432232 |
|---|
|
SQL Diagnostic Manager correctly applies baseline settings to other monitored now allows you to grant users access to specific instances through the Application Security window.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32227 |
|---|
|
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.
31198 Customized Dashboards in the SQLDM Desktop Client are now correctly saved in the repository database. SQL Diagnostic Manager successfully monitors and displays information for scale-out installations, showing the correct version.
On-Premises
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31859 |
|---|
|
The Permissions Script for User Creation was successfully improved and now works as expected.IDERA Web Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-3120232333 |
|---|
|
SQLDM successfully applies new baselines' configuration to monitored instancesWeb Console successfully displays all the alerts of the monitored instances after an upgrade.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32291 |
|---|
|
Dates are now displayed in the proper format on SQLDM Web Console.
31420 Now SQL Diagnostic Manager successfully shows paging correctly displays graphics in the Memory Screen of the Resources tab.
...
Web Console, since the graphics order has been fixed.
30435 Improved the stability of the SQLDM Management Service. SQL Diagnostic Manager fixed the performance of the Analyze view, generating recommendations properly.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32228 |
|---|
|
The Alerts view of SQLDM Web Console allows users to set up Advanced Filters effectively.
High Availability Groups
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-32147 |
|---|
|
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-3187530512 |
|---|
|
SQL Diagnostic Manager now correctly monitors Availability Group servers with reading/write permissions....
successfully monitors listener status in a High Availability environment while monitoring replicas.
Upgrade
31001 The Disk Statistic report is now correctly showing the total number of drives of a monitored server. SQL Diagnostic Manager displays consistent values for CPU usage metrics and graphics after upgrading to 12.2.4
31106 After upgrading, SQL Diagnostic Manager does not raise any unhandled exception related to missing files When the user runs the report for CPU or Memory statistics selecting Show Baseline, it returns Actual and Baseline Stats.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-31117 |
|---|
|
The "Top Query" report now works successfully for all production servers You can successfully upgrade SQL Diagnostic Manager to 12.0.x keeping your Alert Templates and Responses as well as your configured Tags.31152 The Database Growth Forecast report correctly categorizes system databases when using the database selector.
...
| 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 |
|---|
|
...
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.