SQL Monitor 12

SQL Monitor 12.0 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 v12.1.2. 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 v12.3.
  • Annual major releases (such as v12.0) combine multiple feature releases and undergo additional QA.

Breaking changes

Starting with SQL Monitor v10.2, Base Monitors of SQL Monitor can only be installed on Windows Server 2012 and newer. Support for running the SQL Monitor website on versions earlier than Windows Server 2012 was 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 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, SQL Monitor itself needs to be installed on Windows Server 2012 or newer.

Version 12.0.9 - December 1, 2021

Improvements

  • You can now use deadlock report tiles for Azure Managed Instances.
  • Security improvements relating to HTTPS, including the following: adding a Strict-Transport-Security HTTP header in all web requests; displaying a warning message when HTTPS is not in use; strengthened security on cookies; automatic redirection from HTTP to HTTPS.

Fixes

  • Fixed highlighting of metrics/entities on Analysis page when selected.
  • Fixed a regression on creating an external custom metric.
  • Fixed an issue which could lead to plan cache bloat on monitored entities.
  • Avoid throwing an error for Trace file's deletion on the first attempt.

Version 12.0.8 - November 26, 2021

Fixes

  • Fix internal SQL Monitor error caused by access to the SQL Monitor repository using monitoring credentials

Version 12.0.7 - November 24, 2021

Improvements

  • Improved usability of metrics on Analysis page. You can now filter the metrics and entities using a text box.

Fixes

  • Fix error downloading report pdf for e-mail after upgrading to v. 12 when the "Fully qualified website URL" configured in Notification Settings has a trailing slash.

Version 12.0.6 - November 18, 2021

Features

  • You can now view Current activity for queries from the Server overview page for on-prem instances.
  • Permit-based licensing support for multi-webserver installations.
  • You can now tag SQL Server instances, Azure SQL Databases, Azure Managed Instances and Amazon RDS instances on the Monitored Servers page and use these tags to filter the global dashboard.

Fixes

  • A bug that prevented configuration of 2-8 alert types has been fixed.
  • A bug that prevented configuring alerts if no default e-mail address had been specified has been fixed.
  • Fixed aliases on the Global Dashboard when multiple base monitors are present.
  • Fixed a bug that prevented displaying of aliases in the Alert Inbox server tree when using multiple base monitor.

Changes

  • Enabled error reporting by default. If you wish to disable sending information about exceptions to Redgate, it can be done from the Diagnostics section of the Configuration page.

Version 12.0.5 - November 15, 2021

Fixes

  • Fix memory leak in base monitor when clusters are monitored.
  • Fix invalid link to Transaction Locking and Row Versioning Guide in MSDN
  • Correct end of support date for SQL Server 2014.
  • Fix broken analysis graph links in availability group overview page.

Version 12.0.4 - November 10, 2021

Features

  • Prevent update notifications for 7 days after installing or upgrading.
  • Added in product licensing permit expiry notifications.
  • You can now alias Azure SQL Managed Instances, Amazon RDS Servers and Azure SQL Databases

Fixes

  • Fix issue where the Machine Unreachable alert is not raised for machines that are part of a cluster.
  • Fix issue where Amazon RDS API Credentials could not be updated.
  • Fix issue preventing the Deadlock alert configuration from being changed.

Version 12.0.3 - November 3, 2021

Fixes

  • Allow Azure SQL database to be used as a repository for SQL Monitor in the installer when the user is not an administrator.
  • Fix regression where links are not rendered correctly on the Edit Alert page.

Changes

  • Security: Delay and rate limit login attempts in case of too many invalid attempts.

Version 12.0.2 - October 29, 2021

Fixes

  • Fix issue where offline activation of a permit fails.

Version 12.0.1 - October 28, 2021

Fixes

  • Fix issue where SQL Monitor stops monitoring Azure Managed Instances after an authorization error related to AG failover.
  • Fixed issue with export button in the Estate Configuration and Discovery pages for Amazon RDS and Azure Managed Instances.
  • Display more information for Azure Managed Instances and Amazon RDS on their version and edition on the Estate Configuration page.

Version 12.0.0 - October 26, 2021

Major changes

  • Introduced a new permit-based licensing system, fully supporting the new SQL Monitor subscription offering.
  • The search bar for Top Queries is now out of preview.
  • The SQL Server Configuration Options Estate page is now out of preview.
  • Migrated the SQL Monitor website to ASP.NET Core 5. From v. 12.0, the default SQL Monitor web server is the recommended option. It is a self-contained server that uses Kestrel under the hood which is a Microsoft-supported production-ready web server that supports HTTPS.
  • Monitoring of SQL Server 2005 is no longer supported.

Fixes

  • Do not apply UTC recalculations for dates in graphs.
  • A bug that prevented indexing for top queries search on Azure SQL Managed Instances and Amazon RDS SQL Server instances has been fixed.
  • Fix the email title with the correct group.
  • Handle errors when Registry Provider is not found.
  • Changed the samplers deadlock priority, which should stop the other processes from becoming victims.
  • Fix failover cluster instance display name.


Didn't find what you were looking for?