Page History
SQL Diagnostic Manager provides the following new features and fixed issues.
...
11.
...
0 New Features
- SQL Diagnostic Manager 10.6 has a new and improved user interface:
- 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.
- SQL Diagnostic Manager allows you to access Azure Monitor Counters for Custom collection
10.6 Fixed Issues
Alerts
SQL Diagnostic Manager now correctly alerts about DB data files sizing.Status colour Green title SQLDM-20300
Alert Filters
The Longest Running Version Store Transaction (minutes) alert filter is working as expected and the email notification includes the stored comment in the alert.Status colour Green title SQLDM-28237
The % wildcard for 'users' is now allowed by the Exclusion filter for the Session Tempdb Space Usage (MB).Status colour Green title SQLDM-28711
The Alert Suppression configuration is no longer causing an incorrect status of the monitored instance.Status colour Green title SQLDM-30139
The Databases Exclusion configuration in the Advanced Alert filter is working as expected.Status colour Green title SQLDM-30392
Custom Counters
When maintenance mode is enabled, custom counters are no longer collected as expected. Status colour Green title SQLDM-29410
Custom Counters are now correctly shown in the "Alert Configuration" window after the instance is linked to it.Status colour Green title SQLDM-29697
Custom Counters can be remove/unlinked from a monitored instance from the Monitored SQL Server Properties window.Status colour Green title SQLDM-29907
Databases
The installation script for the Model database sizing is now working correctlyStatus colour Green title SQLDM-23252
The Database Analysis is now reporting the correct schema.Status colour Green title SQLDM-28800
Desktop Client
The new added panels to SQLDM Desktop Client are displaying correct values when loading data from the repository.Status colour Green title SQLDM-29209
Disk Drives
The Disks Drives on a newly registered server are now correctly discoverable using OLE automation or WMI.Status colour Green title SQLDM-29109
Extended Events
SQLDM now correctly collects query data through Extended Events.Status colour Green title SQLDM-30011
General
| Status | ||||
|---|---|---|---|---|
|
SQL Diagnostic Manager correctly generates alerts for the SQL Server Error Log metric when the Advanced Alert Filters are defined.Status colour Green title SQLDM-29182
SQL Diagnostic Manager now correctly reports the correct Cumulative Updates for the monitored instances.Status colour Green title SQLDM-29403
IDERA Dashboard
The widgets in the IDERA Dashboard are rendering properly after selecting an identifier for a custom dashboard.Status colour Green title SQLDM-29130
The Instance Status widget in the IDERA Dashboard is now correctly filtering non-active instances.Status colour Green title SQLDM-29212
The properties of a monitored instance is now displaying as expected in both the SQLDM Desktop Console and the SQLDM Web Console.Status colour Green title SQLDM-30243
Maintenance Mode
The Servers now correctly follow the Maintenance Mode schedule.Status colour Green title SQLDM-28446
Metrics
The "Mirroring Unsent Log" metric now triggers the Critical alert at a higher threshold value.Status colour Green title SQLDM-5463
Query Monitor
SQLDM is now correctly configuring the options for capturing query plans when enabling the options for Query Monitor when using the Add Servers Wizard.Status colour Green title SQLDM-28829
The TempDB contention which caused blocking sessions when the Query Monitor is enabled, has been resolved.Status colour Green title SQLDM-30464
Reports
The 'Disk Space Usage Forecast' report now correctly exports to PDF.Status colour Green title SQLDM-28219
The Alert History report is now displaying all the historical alerts of the specified period of time.Status colour Green title SQLDM-29155
The Detailed Session Report is now displaying all the expected data based on its configuration.Status colour Green title SQLDM-29401
Resources
The Free Disk column under the Disk Size option of the Resources tab now correctly sorts numerically.Status colour Green title SQLDM-28108
SCOM
The SCOM integration after upgrading SQL Diagnostic Manager now works as expected.Status colour Green title SQLDM-29458
Services
The reported crashes of the SQLdm Management Service caused by configurations in certain Alert Response conditions, are no longer occurring.Status colour Green title SQLDM-29428
The SQLdm Management service is no longer crashing when importing an alert action response rule.Status colour Green title SQLDM-30393
Sessions
The Session monitor now correctly displays the Job name along with the Job ID.Status colour Green title SQLDM-23196
SQL Server Agent
When the SQL Server Agent Job Failure alert raises, the Details description no longer exposes sensitive information.Status colour Green title SQLDM-28607
- includes full support for Azure SQL. This feature includes the following resources for the Azure SQL database:
- The compatibility for Azure SQL Managed Instance with on-premises.
- Elastic pools that allow you to manage and scale multiple databases.
- Single databases typically are used for development and small apps.
- This release includes the completion of Azure SQL alerts that were added in previous releases. Among other features, these alerts include:
- New alerts notify if the allocated resources are more than needed.
- New displays for newly collected metrics.
- New alert templates with revised thresholds and priority/rank specifically for DBaaS (Azure SQL and Amazon RDS)
- This version includes a new server wizard that uses Azure profile credentials, allowing you to discover other Azure DB assets.
- Azure profile credentials collect metrics from Azure monitor to extend SQL Diagnostic Manager.
- Prescriptive Analytics improvements, including new recommendations for Azure SQL DBaaS and Amazon RDS.
11.0 Fixed Issues
Alerts
SQLDM-29184 SQL Diagnostic Manager now correctly alerts table fragmentation based on the table size configuration.
SQLDM-30421 The advanced Alert Filter for the "Longest Running version Store Transaction (Minutes)" alert is working as configured.
SQLDM-30487 The 'Clear Alert" option in the 'Availability Group Role Change' alert has been restored.
SQLDM-30528 SQLDM shows "Recommendations are available" operational alert in the Active Alert list.
SQLDM-30788 SQLDM Disk space alerts are now correctly triggering after an upgrade.
SQLDM-30825 The Disk Full alerts are no longer triggered for excluded disks in the alerts configuration.
SQLDM-30963 SQL Diagnostic Manager now correctly shows the correct alerts and thresholds for page life expectancy metric when using the Critical-Only Template.
SQLDM-31039 The "Show Historical View" button in the Alerts Tab is now working as expected.
Alert Response
SQLDM-29208 The 'Enable the Query Wait' Alert Action will properly execute when an Alert Response is triggered.
Availability Groups
SQLDM-30083 SQL Diagnostic Manager no longer encounters an error when removing an instance that happens to be a replica within an availability group.
SQLDM-30197 SQLDM now discovers preferred replica information from Availability Group settings.
Cloud Monitoring
SQLDM-30344 The notifications for blocked sessions and SQL Agent Job Failures when monitoring RDS instances are now working correctly.
Custom Counters
SQLDM-30385 The newly created custom counters are added to the existing templates and can be applied to new servers.
SQLDM-30524 The Custom Counter alerts when using T-SQL script are raising correctly.
Database
SQLDM-30575 The Database status is now displaying accurate status.
Extended Events
SQLDM-29005 SQLDM now correctly add new servers and allows to select 'Extended Events' as the collection method for the Activity Monitor.
SQLDM-29033 The performance of the query that collects Replication Statistics has been improved.
General
SQLDM-29384 SQL Diagnostic Manager now correctly monitors its own repository.
SQLDM-29408 SQLDM installation is now completing successfully when the service account credentials contain special characters.
SQLDM-30114 SQL Diagnostic Manager now correctly reports the Publisher Names for SQL Server 2016 SP2 or later.
SQLDM-30364 Desktop Console Views now correctly keeps the custom views.
SQLDM-30453 IDERA Newsfeed is correctly configured after installing SQL Diagnostic Manager.
SQLDM-30480 SQL Diagnostic Manager now correctly displays baselines.
SQLDM-30493 SQLDM Desktop console now correctly shows the critical SQL Server Service status.
SQLDM-30770 SQL Diagnostic Manager successfully checks SQL Browser Service Alert status when the Remote Administrative connection is disabled and there is only a default SQL Server instance installed.
SQLDM-30936 SQL Diagnostic Manager displays the correct information when you select a secondary tab.
SQLDM-31025 The pause button now correctly works and it is integrated with the refresh button.
SQLDM-31042 SQL Diagnostic Manager now correctly displays the "Session Details" grid.
SQLDM-31068 The Query History view under the Queries tab is working as expected.
SQLDM-31070 The "View Session Details" option is now correctly working.
SQLDM-31071 The "View Locks" option is now correctly working.
Graphs
SQLDM-29069 The 'Disk busy per disk' metric graph now correctly loads under the Disk option from the Resources tab.
SQLDM-30037 The blocking displayed in the reports and in the graphs are synced correctly.
SQLDM-30137 The Alert Configuration window is no longer displaying inaccurate threshold graphs.
Hyper-V
SQLDM-28327 SQL DM successfully connects to Hyper-V Host Configuration.
IDERA Dashboard
SQLDM-30032 SQLDM web console is no longer reporting FIPS compliant environment errors.
SQLDM-30260 The IDERA Dashboard login information is now correctly encrypted.
SQLDM-30350 The SQLDM Web Console no longer encounters exceptions when IDERA Dashboard and the monitored instances are in different time zones.
SQLDM-30526 The Overview tab in the web console is no longer displaying an exception when clicking the summary under the Active Alerts widget.
Maintenance Mode
SQLDM-30686 SQL Diagnostic Manager no longer erroneously reporting "Maintenance mode started" when maintenance mode has been disabled.
Notifications
SQLDM-30859 The Databases category metrics now correctly raise alerts and send email notifications.
Query Monitor
SQLDM-30397 SQLDM now correctly creates historical snapshots when Query Monitor is enabled and configured to use Query Store.
SQLDM-30664 Powerscript now successfully enables Query Monitor.
Reports
SQLDM-21051 SQLDM successfully runs SSRS reports when more than 126 instances are selected.
Services
SQLDM-28648 SQLDM successfully collects information for disk drives volume formatted in ReFS.
Upgrade
SQLDM-30170 After upgrading SQLDM from 10.3 to 10.4 version, the Queries tab now correctly loads information.
SQLDM-30312 SQLDM now correctly triggers and notifies alerts for the Session CPU Time after performing an upgrade
| Status | ||||
|---|---|---|---|---|
|