SQL Diagnostic Manager for SQL Server Releases

Released: Mar 15, 2023

Updates in SQL Workload Analysis v1.7.2

Features

  • Improved web access experience.
  • Security improvements.
  • Support improvements.

Fixes

  • Data randomly stops processing and is not available in SWA 1.7.0.
  • Broken Wiki Links to be fixed.
  • Installation fails using the special character instance.
  • Able to monitor 2 servers while SWA is licensed for 1 server only.
  • SQLWA Repository DB credentials - including password, logged as plain text in the logs.
  • SQLWA 1.7.2 should be packaged with CWF 4.7.
  • Run as administrator on exe file for the 1.7.1#16 the...

Released: Oct 4, 2022

Updates in SQL Diagnostic Manager for SQL Server v12.0

Features

  • SQL Diagnostic Manager now performs 'Scale-out Architecture', including the following features:
    • Multiple DM Installations in a single DM Console.
    • Targeting +2000 instances over four DM Installations.
    • Full Administrative support for DMSO Cluster Environments.
  • Added connectivity and work-ability across untrusted domains using an alternative Microsoft Windows collection account.
  • Added support for upgrades from existing installations.

Fixes

  • Reports
    • When the Deadlock report is generated, SQL...

Released: Mar 9, 2021

Updates in v11.x

v11.1

Updated Jun 2, 2021

Features

  • Added a scalable Microsoft Windows User Interface to support UHD monitors and scalable Windows fonts.
  • Added new Dark Mode for users who prefer dark background interfaces.
  • Added a Heatmap Overview in Windows Console to better triage the relative health of a large number of Microsoft SQL Server environments.
  • Improved Grid Overview with Alert Status by Category. The highly configurable grid overview displays user selected key instance metrics in order of...

Released: Jul 9, 2020

Updates in v10.6.x

v10.6.0

Updated Jul 9, 2020

Features

  • Improved user interface with intuitive range control for historical or real-time analysis, and new advanced session filters.
  • Multiple instance navigation options to optimize use in environments with a large number of instances.
  • Access Azure Monitor counters for custom collections in Microsoft Azure DB environments.

Released: Nov 23, 2019

Updates in v10.5

v10.5.1

Updated Feb 13, 2020

Fixes

  • Bug Fixes

v10.5

Updated Nov 23, 2019

Features

  • Updated prescriptive analytics by adding latest recommendations from SQL Doctor including recommendations for DBaaS.
  • Updated user interface for monitoring DBaaS by hiding invalid windows.
  • Updated alerting by adding support for DBaaS, reducing false positives, and addressing customer requests.
  • Support for Microsoft SQL Server 2019.

Released: Feb 28, 2019

Updates in v10.4

Features

  • Visual query plan in desktop console.
  • Improved extended event estimated plan collection.
  • Exploit SQL Server's Query Store for query and plan collection.
  • Improved web console.
  • Support SQL Server 2019 CTP (experimental) for monitoring and repository.

Released: Aug 2, 2018

Updates in v10.3

Features

  • Reduced privilege requirements for monitoring.
  • New Operator security role in between Read Only and Instance Admin roles.
  • Added grooming and aggregation options.
  • Support SQL Server 2017 for Windows & Linux.

Released: May 1, 2018

Updates in v10.2.2

Features

  • New Session Details report.
  • Improved IDERA Dashboard performance and install experience.

Released: Sep 7, 2017

Updates in 10.2.1

Features

This release adds the capability previously added in SQL Diagnostic Manager (SDM) 10.2 to the browser interface in IDERA Dashboard.

  • Time-based drilldown in SQL Diagnostic Manager.  Select any time range on any graph to zoom in for more detail and isolate that time range as you navigate to other graphs.
  • History Range Control.  Choose the range being displayed with a common control to specify start date and time and end date and time or select the most recent history.
  • Performance...

Released: Jul 6, 2017

Updates in V10.2

Features

  • Improved time-based drill-down.
  • Refined history range control.
  • Optimized performance for scalability and user productivity.

Fixes

  • Various bug fixes.