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.

...

4 New features

  • Visual 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

Maintenance Mode

Status
colourGreen
titleSQLDM-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.

Azure Databases

No new features for this release.

10.3.1 Fixed Issues

...

Status
colourGreen
titleSQLDM-2948627933
The SQL Diagnostic Manager Desktop Client is no longer encountering latency issues when navigating between monitored instances.

...

returning error messages when viewing data on monitored Azure Databases.

Metrics

Status
colourGreen
titleSQLDM-28314
The metric "SQL Server Log size" is triggering alerts as expected.

Web Console

Status
colourGreen
titleSQLDM-28317
The SQL Diagnostic Manager Web Console is correctly reporting the statuses of the monitored SQL Server instances.

Status
colourGreen
titleSQLDM-29173
Improved performance of the SQL Diagnostic Manager Web Console.

Status
colourGreen
titleSQLDM-29205
The SQL Diagnostic Manager Web console correctly recognizes users configured in Application Security.

Deadlocks

Status
colourGreen
titleSQLDM-29459
SQLdm Collection services is no longer causing high CPU and network usage after performing an upgrade.
28568
SQL Diagnostic Manager is no longer reporting persistent deadlocks from the [p_InsertDatabaseSize] procedure.

Desktop Console

Status
colourGreen
titleSQLDM-28572
The SQL Diagnostic Manager Desktop Client now correctly displays dates based on the Operating System settings.

Status
colourGreen
titleSQLDM-28602
The SQLDM Graphical User Interface now correctly responds and no longer hangs.

Status
colourGreen
titleSQLDM-28912
Improved performance when updating Monitored SQL Server Properties within the SQL Diagnostic Manager Desktop Client.

Status
colourGreen
titleSQLDM-29220
The Desktop console is no longer displaying random exceptions.

Alerts

Status
colourGreen
titleSQLDM-2944828666
After performing an upgrade to SQL Diagnostic Manager 10.3, the job "Aggregate Data SQLdmRepository" is no longer reporting timeoutsnow correctly sends alerts in a timely manner via email.

Status
colourGreen
titleSQLDM-28824
SQLDM now correctly imports Alert templates.

Status
colourGreen
titleSQLDM-28938
When hovering over a monitored instance on the Servers panes view, the displayed tooltip now correctly displays the current active alerts.

Status
colourGreen
titleSQLDM-28940
The Alert suppression threshold now correctly works and triggers alerts as expected.

Powershell

Status
colourGreen
titleSQLDM-29192
The PowerShell now correctly works when the $AlertText is used for the Blocked Sessions Wait Time (Seconds).

Table Statistics

Status
colourGreen
titleSQLDM-29404
Table Statistics collection is now properly excluding specified databases that are hosted on a case sensitive collation.

Reports

Status
colourGreen
titleSQLDM-29429
The Enterprise Summary report now correctly lists the SQL Server version of the monitored instances.

Services

Status
colourGreen
titleSQLDM-29437
Improved memory consumption by the SQLdm Management Service.

Status
colourGreen
titleSQLDM-29505
The SQLdm Management service starts automatically after the upgradeService remains in a running state if the SQL Server instance hosting the SQLdm Repository database is unavailable.

Status
colourGreen
titleSQLDM-29512
SQL Diagnostic Manager will correctly report the status of the SQL Server Agent Service on SQL Server 2008 R2 instances.



Scroll pdf ignore
SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...