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.5.1 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)a new Server Uptime report.
This release includes Cloud DBaaS user interface improvements that ease the management of Azure SQL and Amazon RDS management supported metrics.
SQL Diagnostic Manager 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

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.5.1 Fixed Issues

Alerts

Status

colour	Green
title	SQLDM-28938

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

Alert timeline view is now displaying the time based on the Operating System settings.

Status

colour	Green
title	SQLDM-29594

SQL Diagnostic Manager now correctly checks and alerts High Fragmentation on the databases.

Status

colour	Green
title	SQLDM-

19380

29840

The Alert Suppression settings for the Availability Group Synchronization Health metric now functions SQL Server Service metric is now working as expected.

Status

colour	Green
title	SQLDM-2816730434

Alert Summary for the Blocking Session Wait Time (Seconds) metric is not displaying time using the local time zone.Responses no longer requires the 'Where Alert Rank' option to be enabled in order to be triggered as expected.

Upgrade

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

29408

Install/Upgrade of SQL Diagnostic Manager will no longer fail when the service account's password contains a special character.

Status

colour	Green
title	SQLDM-

26371

30381

Upgrade attempts of SQL Diagnostic Manager is should no longer prompting encounter an error when performing an Analysis, which was caused by the Prescriptive Service not installing "TracerX.Logger.dlll" file.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.

Status

colour	Green
title	SQLDM-30369

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

Azure

Status

colour	Green
title	SQLDM-

28684

29523

The snapshot data collection History Browser is no longer used for Prescriptive Analytics with the revised interfacefailing for Azure SQL PaaS instances.

Status

colour	Green
title	SQLDM-

29891

30299

SQL Diagnostic Manager now successfully completes analysis and the results are displayed as expected.

...

correctly monitors Azure DBaaS and is no longer displaying errors.

Status

colour	Green
title	SQLDM-

28317

30188

The SQL Diagnostic Manager Web Console now correctly displays the statuses of monitored instanceSession details on Azure SQL Database.

Status

colour	Green
title	SQLDM-

29215The SQL Diagnostic Manager Web Console now correctly honors the Application Security settings that is configured in the SQL Diagnostic Manager Desktop Console

30013

SQLDM now correctly displays databases hosted in Azure SQL PaaS.

Desktop Console

Status

colour	Green
title	SQLDM-29782

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

Status

colour	Green
title	SQLDM-30087

The IDERA Dashboard now correctly displays the federation drop down menu.

...

30244

The SQLDM Desktop Console will now properly convert the timestamps to local time when viewing the backup/restore history of a database.

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.

Custom Counters

Status

colour	Green
title	SQLDM-

28570 The 'Days since last backup' metric no longer generates alerts for databases that have never been backed up

30100

The Custom Counter reports now correctly displays data.

Query Waits

Status

colour	Green
title	SQLDM-

29192

29671

The PowerShell SQLDM now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds)shows the Query Wait collector status.

Status

colour	Green
title	SQLDM-

29425 When configuring the "Oldest Open Transaction" metric, SQL Diagnostic Manager now correctly saves the exclusion filter value when wildcards are used.

...

30098

The timeline on the Query Waits view will now be displayed in the correct order.

Status

colour	Green
title	SQLDM-

28912

30012

Improved the performance of the SQL Diagnostic Manager Desktop Client when updating properties of a monitored SQL Server instancenow correctly detects all the specific disk drives for each SQL Server registered.

Services

Status

colour	Green
title	SQLDM-

29467

29997

Index rebuilding operation in SQLDM desktop console now correctly works connects to the SQLdmManagement Service and is no longer displaying throwing exception errors.

...

IDERA Dashboard

Status

colour	Green
title	SQLDM-20002

The SQLDM Web Console now displays timestamps using local time.

Status

colour	Green
title	SQLDM-

28960

28516

The Deadlock Report SQLDM Web Console now correctly displays all the information about the deadlocks occurred in the monitored instances.the Last Backup Date of a database.

Status

colour	Green
title	SQLDM-29921

SQL Diagnostic Manager can now be manually registered in the IDERA Dashboard.

vCenter

Status

colour	Green
title	SQLDM-29900

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

Metrics

Status

colour	Green
title	SQLDM-

29427

29802

The error "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" is no longer displaying when running the "Detailed Session Report". *The 'Days since last backup' metric has been updated to include additional advanced options specific for availability groups.

Status

colour	Green
title	SQLDM-

29689

29785

The Deadlock Report now correctly shows the total number of deadlocks. SQLDM now properly monitors the status of DTC and SQL Server Agent when collecting operating system statistics using OLE Automation.

Reports

Status

colour	Green
title	SQLDM-

29767

28878

The Database Statistics report no longer encounters a timeout error when generating the reportDisk Space Usage report in the SQL Server Reporting Services portal is no longer asking the value for the Disk parameter.

Status

colour	Green
title	SQLDM-

29917 The Detailed Session Report now successfully deploys to SSRS.

Services

29020

SQL Diagnostic Manager now collects deadlocks in Session > Blocking View and in Reports when using Extended Events or SQL Trace.

Status

colour	Green
title	SQLDM-

29432 When monitoring a SQL 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.

29685

Database Growth Forecast report now correctly shows sufficient data.

Availability Groups

Status

colour	Green
title	SQLDM-

29521

19304

The SQLDM Management Service no longer crashes when a server has been registered as a Linux instance.

...

"Aggregate Data SQLdmRepository" and "Groom SQLdm Repository" SQL Agent jobs now correctly run when the SQLDM Repository Database is hosted in an availability group.

Status

colour	Green
title	SQLDM-

29447

28366

SQL Diagnostic Manager now correctly monitors SQL Server 2000 instancesis now showing correct mount points for monitored secondary replicas.

Status

colour	Green
title	SQLDM-

29545

20369

The databases in an SQLDM Availability Group now correctly monitors SQL Server 2005 instancescapture growth statistics.

Status

colour	Green
title	SQLDM-

29658 The error "SQL Agent unable to monitor" is no longer prompting when monitoring instances running specific SQL Server versions.

...

28629

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

Status

colour	Green
title	SQLDM-

29492 SQLDM now correctly shows the OS memory usage on the newly added servers.

Upgrade

28907

Improve the load time on the Availability Group databases view.

Status

colour	Green
title	SQLDM-

29529

29229

SQL Diagnostic Manager The "Error interpreting File Activity Collector: Invalid column name 'unused_size'" error is no longer displaying after upgrading to SQLDM 10.3.errors and is successfully connected to servers holding repositories in an availability group without a listener.

Status

colour	Green
title	SQLDM-29547

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

Wait Statistics

Status

colour	Green
title	SQLDM-

29715 The SQLDM desktop console now correctly works after an upgrade to 10.3.1 version.

...

29463

The Wait statistics are no longer displaying inconsistent values.

Deadlock

Status

colour	Green
title	SQLDM-

29931

29006

SQL Diagnostic Manager no longer generates an error message indicating that sysadmin rights are required in order to collect OS Metrics.

...

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

Other issues

Status

colour	Green
title	SQLDM-

29985

28694

SQLDM now correctly refreshes the Mirroring history of a database.

...

shows the closest historical snapshot when switching servers.

Status

colour	Green
title	SQLDM-

30183 The refresh error when navigating in the Query Waits screen is no longer displaying.

...

28606

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

Status

colour	Green
title	SQLDM-

30189

28603

SQL Diagnostic Manager is no longer generating an error related to Procedure Cache when monitoring Azure SQL Databasenow correctly shows the table sizes.

Status

colour	Green
title	SQLDM-28327

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 26

New Version 27

Key

10.5.1 New Features

10.5 Fixed Issues

Alerts

10.5.1 Fixed Issues

Alerts

Upgrade

Analysis

Azure

Desktop Console

Custom Counters

Query Waits

Services

IDERA Dashboard

vCenter

Metrics

Reports

Services

Availability Groups

Upgrade

Wait Statistics

Deadlock

Other issues