SQL Monitor 11

SQL Monitor 11.2 Release Notes

 

When should I upgrade?

  • We aim to release a build every week that includes the latest incremental features and bug fixes. These builds are identified by a three-part version number, such as v11.0.0. So if you’ve identified a particular feature from the release notes that you need, you can download the relevant build.
  • If you want to wait until all aspects of a feature have been fully completed, it’s best to use a quarterly minor version release, identified by a two-part version number such as v11.2.
  • Annual major releases (such as v11) combine multiple feature releases and undergo additional QA.

Breaking changes

Starting with SQL Monitor v10.2, SQL Monitor Base Monitors can only be installed on Windows Server 2012 and newer. For the time being, this only affects the Base Monitor. Support for running the SQL Monitor website on versions earlier than Windows Server 2012 will be removed in SQL Monitor v12.0.

We've moved to .NET 5; Microsoft does not support versions earlier than Windows Server 2012 as deployment targets for .NET 5. This also means that SQL Monitor Base Monitors cannot be installed on unsupported desktop operating systems. Refer to Microsoft's installation guidance for specific versions.

You can monitor the same versions of Windows and SQL Server that you've always monitored. However, base monitors need to be installed on Windows Server 2012 or newer.

Version 11.2.21 - February 01, 2023

Security fixes

  • Fixed a high severity (CVSS 7.6) security issue where, when using Active Directory (LDAP) authentication, low-privileged users could elevate their permissions to a SQL Monitor administrator role (CVE-2022-47542).

Version 11.2.20 - October 20, 2021

Improvements

  • It is now possible to drag and drop a permit file when activating a license in offline mode.

Fixes

  • Limit alert email notification sizes to 400KB to prevent rejection.

Version 11.2.19 - October 14, 2021

Fixes

  • A bug that prevented the selection of specific instances when adding a custom metric has been fixed.
  • An issue that could cause an error on the custom metric page has been fixed.

Version 11.2.18 - October 13, 2021

Fixes

  • DLLs used by the installer are also signed
  • Fix OpenID Connect issue when configuration can't be obtained due to invalid handling of slashes in the address.
  • An issue that caused the y-axis of analysis graphs on reports to use incorrect formatting has been fixed

Version 11.2.17 - October 7, 2021

Improvements

  • Display query search folder size on data settings page
  • Show full query text on deadlock report

Fixes

  • Fixed top queries search for Azure SQL Database for databases that have special or mixed case characters in their names

Version 11.2.16 - September 30, 2021

Features

  • The estate - SQL Server configuration options page has been improved: it shows a log of changes, presents a richer selection of configuration options, and a table allowing comparison of values.

Fixes

  • Fixed Severity 21 issue when sampling configuration options for databases that are offline or closed.
  • Fix possible issue with Active Directory authentication

Changes

  • Add thumbs up/down feedback mechanism to top queries search feature.

Version 11.2.15 - September 22, 2021

Features

  • Top queries search is now available on Amazon RDS SQL Server, Azure SQL Managed Instance and Azure SQL Database

Fixes

  • Fixed an issue when indexing top queries to be searched.

Version 11.2.14 - September 20, 2021

Improvements

  • Subscription licenses can now be activated offline, where the SQL Monitor web service doesn't have direct access to Redgate's licensing servers.

Version 11.2.13 - September 16, 2021

Features

  • New alert on SQL Server log entry added which can be raised by matching a regex pattern.

Improvements

  • The folder used to store the index files for the top query search feature is now configurable.
  • Added an option to set Server waits data retention settings separately on the Data settings page.

Fixes

  • Standard users can access the about page and retry connections on monitored servers page.
  • The job failing alert now only ends when the job successfully runs. Before, an alert was raised each time the job failed.
  • Alerts are loaded correctly after clearing them on the Alerts page.

Version 11.2.12 - September 1, 2021

Improvements

  • Added validation against incorrectly formatted custom e-mail addresses on alert configuration

Fixes

  • Fixed the missing details in the Integrity Check Overdue alert details page for Azure SQL Managed Instances.

Version 11.2.11 - August 23, 2021

Improvements

  • The deadlock report tile now has an option to choose how many deadlocks to display.

Fixes

  • Improved performance of a query that could cause high CPU usage

Changes

  • Query plan changes are now identified by using query plan hashes on SQL Server 2008 and above.

Version 11.2.10 - August 12, 2021

Fixes

  • Fix empty fields in notification settings causing failure on save
  • Fix issue with schema that prevented top queries search

Version 11.2.9 - August 11, 2021

Features

  • Top queries now has a text search you can use.

Fixes

  • Fix rare deadlock reported where SQL Monitor intersects with the restoration of a shipped log
  • Fix non-recurring alert suppression windows in PowerShell 5

Changes

Version 11.2.8 - August 4, 2021

Changes

  • Drop support for an authentication token stored in WebApi.config file. Use authentication tokens configured through the UI in Configuration -> Authentication tokens instead.

Version 11.2.7 - July 28, 2021

Fixes

  • An issue that could cause samplers encountering SQL error message 988 to incorrectly raise alerts has been fixed

Version 11.2.6 - July 23, 2021

Fixes

SRP-13861 Fixes a regression that caused a crash when displaying alert details

Version 11.2.5 - July 22, 2021

Fixes

  • Resolved an issue where renaming a group could crash the groups configuration page.
  • Fixed the duplicate alert issue for Custom Metric.
  • Fixed a regression that resulted in an error loading Query Wait Stats on the Server Overview page.
  • Fixed an issue that caused incorrect blocking process to be shown on blocking process alert.
  • Fixed issue on instance discovery when discovering large number of servers.

Version 11.2.4 - July 14, 2021

Improvements

  • Time column in the error log section of the server overview page contains seconds.
  • Improved display of Key Lookups in query plans

Fixes

  • Fixed an issue that caused incorrect blocking process to be shown on blocking process alert.

Version 11.2.3 - July 8, 2021

Features

  • Added support for licensing SQL Monitor via logging in to your RedGate account.

Improvements

  • Add visibility of additional server configuration options for industry-standard benchmarks
  • Server configuration options are sorted alphabetically

Version 11.2.2 - June 30, 2021

Features

  • Added new ability on server overview databases section to display and allow comparison of database specific properties.
  • Added the ability to edit Amazon RDS Api Credentials after Amazon RDS SQL Server has been added.

Improvements

  • Authentication settings page redesigned.

Fixes

  • Fixed an issue that could cause the index sampler to fail in case-sensitive collations.

Version 11.2.1 - June 24, 2021

Improvements

  • Reduces the CPU usage for SQL Server monitor

Fixes

  • Code analysis now supports parameterized queries.
  • The SQL Server Error Log entry alert now shows details of the error when viewed from the Server Overview page.

Version 11.2.0 - June 17, 2021

Features

  • OpenID Connect (OIDC) as a new authentication type (in addition to Basic and Active Directory).
  • Preview: SQL Server instance discovery. Automatically discover SQL Server instances on your estate and start monitoring them.

Fixes

  • Fixed escaping of logged in user name.
  • Fix Error Severity 21 when sampling for DatabaseConfigurationOptions (No use of Snapshot Databases)
  • Links from custom metric alerts to the analysis page correctly select the appropriate custom metric


Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?