Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

SQL Diagnostic Manager provides the following new features and fixed issues:.

10.

...

6 New Features

SQL Diagnostic Manager now includes a new Server Uptime report.
This release includes three new default values for the History Browser range.
The "Days since last backup" alert configuration includes the option to include or exclude Read-Only databases.

...

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

Status


colour	Green
title	SQLDM-

28938

20300

SQL Diagnostic Manager now correctly alerts about DB data files sizing The SQLDM Desktop Console now displays the correct alerts when hovering the mouse over an object on the Server pane.

Status


colour	Green
title	SQLDM-

29434

30312

SQLDM now correctly triggers and notifies alerts for the Session CPU Time alert Alert timeline view is now displaying the time based on the Operating System settings.

Status


colour	Green
title	SQLDM-

29594

30859

The Databases category metrics SQL Diagnostic Manager now correctly checks and alerts High Fragmentation on the databases.raise alerts and send email notifications.

Alert Filters

Status


colour	Green
title	SQLDM-

29840

28237

The Longest Running Version Store Transaction (minutes) alert filter is working as expected and the email notification includes the stored comment in the alert Alert Suppression for the SQL Server Service metric is now working as expected.

Status


colour	Green
title	SQLDM-

30434 Alert Responses no longer requires the 'Where Alert Rank' option to be enabled in order to be triggered as expected.

Upgrade

28711

The % wildcard for 'users' is now allowed by the Exclusion filter for the Session Tempdb Space Usage (MB).

Status


colour	Green
title	SQLDM-

30381

30139

The Alert Suppression configuration is no longer causing an incorrect status of the monitored instance Upgrade attempts of SQL Diagnostic Manager should no longer encounter an error regarding a constraint on the CloudProviders table.

Status


colour	Green
title	SQLDM-

30370 An issue preventing upgrades from versions 10.4.2 and 10.4.3 has been resolved.

30392

The Databases Exclusion configuration in the Advanced Alert filter is working as expected.

Availability Groups

Status


colour	Green
title	SQLDM-

30369 The custom Dashboards are no longer being deleted when upgrading from SQLDM 10.4.

...

30197

SQLDM now discovers preferred replica information from Availability Group settings.

Custom Counters

Status


colour	Green
title	SQLDM-

29523

29410

The snapshot data collection is no longer failing for Azure SQL PaaS instancesissue with Customer Counter collection when a monitored instance is in maintenance mode has been resolved.

Status


colour	Green
title	SQLDM-

30299

29697

Custom Counters are now correctly shown in the "Alert Configuration" window after the instance is linked to it SQL Diagnostic Manager now correctly monitors Azure DBaaS and is no longer displaying errors.

Status


colour	Green
title	SQLDM-

30188

29907

The Custom Counters from a monitored instance can now be removed all in one using Server Properties.

Databases

SQL Diagnostic Manager now correctly displays Session details on Azure SQL Database.

Status


colour	Green
title	SQLDM-30013

SQLDM now correctly displays databases hosted in Azure SQL PaaS.

Desktop Console

23252

The installation script for the Model database sizing is now working correctly

Status


colour	Green
title	SQLDM-

29782 Powered off instances are no longer shown as active in the SQLDM console.

28800

The Database Analysis is now reporting the correct schema.

Desktop Client

Status


colour	Green
title	SQLDM-

30244

29209

The SQLDM Desktop Console will now properly convert the timestamps to local time when viewing the backup/restore history of a database.new added panels to SQLDM Desktop Client are displaying correct values when loading data from the repository.

Disk Drives

Status


colour	Green
title	SQLDM-

30136 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.

...

29109

The Disks Drives on a newly registered server are now correctly discoverable using OLE automation or WMI.

Extended Events

Status


colour	Green
title	SQLDM-

30100

30011

SQLDM The Custom Counter reports now correctly displays collects query data through Extended Events.

...

General

Status

colour	Green
title	SQLDM-

29671

19742

SQLDM now correctly shows the Query Wait collector statusis displaying the SQL Server service pack information correctly.

Status


colour	Green
title	SQLDM-

30098

29182

SQL Diagnostic Manager now correctly notifies by email, the login failures The timeline on the Query Waits view will now be displayed in the correct order.

Status


colour	Green
title	SQLDM-

30012

29403

SQL Diagnostic Manager now correctly detects all the specific disk drives for each SQL Server registered.

...

reports the correct Cumulative Updates for the monitored instances.

Status


colour	Green
title	SQLDM-

29997

29408

SQLDM desktop console now correctly connects to the SQLdmManagement Service and is no longer throwing exception errors.

...

installation is now completing successfully when the service account credentials contains special characters.

Status


colour	Green
title	SQLDM-

20002

30628

The SQLDM Web Console now displays timestamps using local time.now correctly identifies the SQL Server version of the monitored instances.

Graphs

Status


colour	Green
title	SQLDM-

28516

30480

SQL Diagnostic Manager The SQLDM Web Console now correctly displays the Last Backup Date of a database.baselines in the graphs.

IDERA Dashboard

Status


colour	Green
title	SQLDM-

29921

29130

The widgets SQL Diagnostic Manager can now be manually registered in the IDERA Dashboard are rendering properly after selecting an identifier for a custom dashboard.

vCenter

Status


colour	Green
title	SQLDM-

29900 vCenter servers for monitored SQL servers in SQLDM can be added without problems.

Metrics

29212

The Instance Status widget in the IDERA Dashboard is now correctly filtering non-active instances.

Status


colour	Green
title	SQLDM-

29802
30260
*The 'Days since last backup' metric has been updated to include additional advanced options specific for availability groups The IDERA Dashboard login information is now correctly encrypted.

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.

Reports

30350

The IDERA Dashboard is no longer displaying any exceptions when checking monitored instances in DM.

Status


colour	Green
title	SQLDM-

28878

30243

The Disk Space Usage report in the SQL Server Reporting Services portal is no longer asking the value for the Disk parameterServer Properties now correctly displays the server data in the IDERA Dashboard interface.

Status


colour	Green
title	SQLDM-

29020 SQL Diagnostic Manager now collects deadlocks in Session > Blocking View and in Reports when using Extended

30499

The Overview tab in the web console is no longer displaying an exception when clicking the summary under the Active Alerts widget.

Maintenance Mode

Events or SQL Trace.

Status


colour	Green
title	SQLDM-

29685 Database Growth Forecast report now correctly shows sufficient data.

...

28446

The Servers now correctly follow the Maintenance Mode schedule.

Metrics

Status


colour	Green
title	SQLDM-

19304

5463

The "Aggregate Data SQLdmRepository" and "Groom SQLdm Repository" SQL Agent jobs now correctly run when the SQLDM Repository Database is hosted in an availability groupMirroring Unsent Log" metric now triggers the Critical alert at a higher threshold value.

Status


colour	Green
title	SQLDM-

28366 SQL Diagnostic Manager is now showing correct mount points for monitored secondary replicas.

29069

The metric graph Disk busy per disk located under the Disk option in the Resources tab is now correctly loading.

Query Monitor

Status


colour	Green
title	SQLDM-

20369

28829

"QueryMonitorCollectQueryPlan" and "QueryMonitorCollectEstimatedQueryPlan" flags in dba.MonitoredSQL Server are no longer setting to 1 when adding instances with the Query Monitor enabled.

Status


colour	Green
title	SQLDM-30397

SQLDM now correctly creates historical snapshots when Query Monitor is enabled and configured to use Query Store The databases in an SQLDM Availability Group now correctly capture growth statistics.

Status


colour	Green
title	SQLDM-

28629 SQLDM Desktop Console no longer crashes when accessing the Availability Group view under Databases.

30464

The TempDB contention which caused blocking sessions when the Query Monitor is enabled, has been resolved.

Reports

Status


colour	Green
title	SQLDM-

28907

28219

The 'Disk Space Usage Forecast' report now correctly exports to PDF Improve the load time on the Availability Group databases view.

Status


colour	Green
title	SQLDM-

29229 SQL Diagnostic Manager is no longer displaying errors and is successfully connected to servers holding repositories in an availability group without a listener

29155

The Alert History report is now displaying all the historical alerts of the specified period of time.

Status


colour	Green
title	SQLDM-

29547 SQLDM is no longer having problems collecting Database size data when monitoring Availability Groups instances.

Wait Statistics

29401

The Detailed Session Report is now displaying all the expected data based on its configuration.

Status


colour	Green
title	SQLDM-

29463

30037

The Wait statistics are no longer displaying inconsistent values.

...

displayed blockings in the reports and in the graphs are now correctly synced.

Resources

Status


colour	Green
title	SQLDM-2900628108

The SQL Queries from the deadlock drop down output are no longer truncated.

...

Free Disk column under the Disk Size option of the Resources tab now correctly sorts numerically.

SCOM

Status


colour	Green
title	SQLDM-

28694 SQLDM now correctly shows the closest historical

29458

The SCOM integration after upgrading SQL Diagnostic Manager now works as expected.

Services

snapshot when switching servers.

Status


colour	Green
title	SQLDM-

28606 SQLDM no longer generates login failures for 'SQLDiagMgr' in the SQL Server Error Log.

29428

The reported crashes of the SQLdm Management Service caused by configurations in certain Alert Response conditions, are no longer occurring.

Sessions

Status

colour	Green
title	SQLDM-

28603 SQL Diagnostic Manager now correctly shows the table sizes.

23196

The Session monitor now correctly displays the Job name along with the Job ID.

SQL Server Agent

Status


colour	Green
title	SQLDM-

28327

28607

When the SQL Server Agent Job Failure alert raises, the Details description no longer exposes sensitive information.

Status


colour	Green
title	SQLDM-29211

The Advanced Filters for the SQL Server Agent Job Completion metric are no longer case sensitive SQLDM now correctly collects the CPU virtualization information on Hyper-V virtual environment.

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

Content

Space Tools

Versions Compared

Old Version 28

New Version 29

Key

10.

6 New Features

10.6 Fixed Issues

Alerts

Alert Filters

Upgrade

Availability Groups

Custom Counters

Databases

Desktop Console

Desktop Client

Disk Drives

Extended Events

General

Graphs

IDERA Dashboard

vCenter

Metrics

Reports

Maintenance Mode

Metrics

Query Monitor

Reports

Wait Statistics

Resources

SCOM

Services

Sessions

SQL Server Agent