SQL Diagnostic Manager provides the following new features and fixed issues.
10.
...
5 New
...
Features
- SQL Diagnostic Manager now includes Prescriptive Analysis improvements (embedded SQL Doctor), updated user interface that matches SQL Doctor workflows, and updated recommendations (specifically for Azure SQL and Amazon RDS).
- This release includes Cloud DBaaS user interface improvements that ease the management of Azure SQL and Amazon RDS management supported metricsVisual 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
...
- now includes Alerting improvements:
- 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.
10.5 Fixed Issues
Alerts
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-19380 |
|---|
|
The Alert Suppression settings for the Availability Group Synchronization Health metric now functions as expected.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-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....
Alert Summary for the Blocking Session Wait Time (Seconds) metric is not displaying time using the local time zone.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-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.Analysis
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2793326371 |
|---|
|
The SQL Diagnostic Manager
Desktop Client is no longer
returning prompting an error
messages when viewing data on monitored Azure Databases....
when performing an Analysis, which was caused by the Prescriptive Service not installing "TracerX.Logger.dlll" file.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28684 |
|---|
|
History Browser is no longer used for Prescriptive Analytics with the revised interface.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2831429891 |
|---|
|
The metric "SQL Server Log size" is triggering alerts SQL Diagnostic Manager now successfully completes analysis and the results are displayed as expected.
Web Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28317 |
|---|
|
The SQL Diagnostic Manager Web Console is correctly reporting displays the statuses of the monitored SQL Server instancesinstance.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29173 |
|---|
|
Improved performance of The SQL Diagnostic Manager Web Console now correctly honors the Application Security settings that is configured in the SQL Diagnostic Manager Web Desktop Console.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2920530087 |
|---|
|
The
SQL Diagnostic Manager Web console correctly recognizes users configured in Application Security....
IDERA Dashboard now correctly displays the federation drop down menu.
Metrics
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28570 |
|---|
|
The 'Days since last backup' metric no longer generates alerts for databases that have never been backed up| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29192 |
|---|
|
The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds).| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2856829425 |
|---|
|
When configuring the "Oldest Open Transaction" metric, SQL Diagnostic Manager is no longer reporting persistent deadlocks from the [p_InsertDatabaseSize] procedurenow correctly saves the exclusion filter value when wildcards are used.Desktop Console
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28572 |
|---|
|
The Improved the performance of the SQL Diagnostic Manager Desktop Client now correctly displays dates based on the Operating System settingswhen updating properties of a monitored SQL Server instance.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28602 |
|---|
|
The SQLDM Graphical User Interface now correctly responds and no longer hangs. Index rebuilding operation in SQLDM desktop console now correctly works and is no longer displaying errors.Reports
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28912 |
|---|
|
Improved performance when updating Monitored SQL Server Properties within the SQL Diagnostic Manager Desktop Client The Deadlock Report now correctly displays all the information about the deadlocks occurred in the monitored instances.
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29220 |
|---|
|
The Desktop console The error "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" is no longer displaying
random exceptionswhen running the "Detailed Session Report".
Alerts
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28666 |
|---|
|
SQL Diagnostic Manager now correctly sends alerts in a timely manner via email The Deadlock Report now correctly shows the total number of deadlocks.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29767 |
|---|
|
The Database Statistics report no longer encounters a timeout error when generating the report.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28824 |
|---|
|
SQLDM now correctly imports Alert templates. The Detailed Session Report now successfully deploys to SSRS.Services
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2893829432 |
|---|
|
When hovering over monitoring a monitored instance on the Servers panes view, the displayed tooltip now correctly displays the current active alertsSQL 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.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-28940 |
|---|
|
The Alert suppression threshold now correctly works and triggers alerts as expected....
The SQLDM Management Service no longer crashes when a server has been registered as a Linux instance.SQL Server supported versions
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29447 |
|---|
|
SQL Diagnostic Manager now correctly monitors SQL Server 2000 instances.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29545 |
|---|
|
SQLDM now correctly monitors SQL Server 2005 instances.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29192 |
|---|
|
The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds)....
The error "SQL Agent unable to monitor" is no longer prompting when monitoring instances running specific SQL Server versions.Memory
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29492 |
|---|
|
SQLDM now correctly shows the OS memory usage on the newly added servers.Upgrade
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29404 |
|---|
|
Table Statistics collection is now properly excluding specified databases that are hosted on a case sensitive collation.Reports
The "Error interpreting File Activity Collector: Invalid column name 'unused_size'" error is no longer displaying after upgrading to SQLDM 10.3.| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2942929715 |
|---|
|
The
Enterprise Summary report now correctly lists the SQL Server version of the monitored instances....
SQLDM desktop console now correctly works after an upgrade to 10.3.1 version.
Sysadmin Permissions
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29931 |
|---|
|
SQL Diagnostic Manager no longer generates an error message indicating that sysadmin rights are required in order to collect OS Metrics.Mirroring
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-29437 |
|---|
|
Improved memory consumption by the SQLdm Management Service. SQLDM now correctly refreshes the Mirroring history of a database.Query Waits
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2950530183 |
|---|
|
The
SQLdm Management Service remains in a running state if the SQL Server instance hosting the SQLdm Repository database is unavailable.refresh error when navigating in the Query Waits screen is no longer displaying.Azure
| Status |
|---|
| colour | Green |
|---|
| title | SQLDM-2951230189 |
|---|
|
SQL Diagnostic Manager will correctly report the status of the SQL Server Agent Service on SQL Server 2008 R2 instancesis 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 |
|---|
|
|
...