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 (e.g. v12.1.2). See below for details of improvements and fixes for each release.
  • If you want to wait until all aspects of a feature have been fully completed it’s best to use a minor version release, identified by a two-part version number (e.g. v12.3).
  • Major releases (e.g. v12) combine multiple feature releases and undergo additional QA. Bug fixes are prioritised following a major release.

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.18 - February 14, 2022

Fixes

  • Fixes an issue with the alert action menu in the alert inbox

Version 12.0.17 - February 10, 2022

Features

  • Redesigned alert inbox with a fresh new look and support for tags.
  • The Current Activity page now supports Azure Managed Instances, Amazon RDS Sql Servers and Azure Sql Databases.
  • You can now apply a filter to the list of servers displayed on Configuration > Monitored servers.

Fixes

  • Fixed an issue where some timestamps were not correctly honouring the browser's local timezone offset, such as the occurrences in the alert details page.
  • Tags in Server Overview page can now successfully be removed from a server.

Version 12.0.16 - February 2, 2022

Features

  • Add version store usage alert.

Fixes

  • Fixed an issue that caused wrong database name to show on deadlock alerts.
  • Fixes issues querying availability group replicas that disallow read-only connections when SQL Monitor has AvoidHadrDmvs is enabled.

Version 12.0.15 - January 26, 2022

Improvements

  • View query plans on the Current Activity page.
  • Fixes an issue with admin users seeing "*** Redacted ***" in query plan parameters.

Version 12.0.14 - January 20, 2022

Improvements

  • Provide option to remove requirement of db_owner permission on tempdb. See documentation here.
  • Adds a horizontal scroll bar to the left sidebar on the Alert settings page.
  • Display blocking processes tree on the Current Activity page.

Fixes

  • An issue that could cause SQL Monitor to fail to reconnect to monitored servers after they are restarted has been fixed.

Version 12.0.13 - January 13, 2022

Improvements

  • Provide option to remove requirement of db_owner permission on tempdb see docs here.

Fixes

  • Fix a regression introduced in v.12.0.10 that causes Active Directory (AD) authentication to fail.
  • Prevent access to offline databases when sampling
  • Fix an issue where baseDn would be updated for all Active Directory domains
  • Fixed wrapping of SQL commands without spaces in deadlock visualizer
  • Fixed download of SNMP MIB file
  • Fixed PDF reports generation when data arrives slowly.
  • Fixed an issue where the Current Activity page would crash for a SQL Server instance without a display name
  • The plan cache size metric has been fixed to use the correct Perfmon counter
  • Fixed an issue where saving an empty channel in the Slack notification configuration would fail
  • Fixed a gradual memory leak in the Base Monitor's internal job scheduler.

Changes

  • Alert emails now show source tags
  • Alert webhook notifications now include tags
  • Alert SNMP notifications now include tags

Version 12.0.12 - December 22, 2021

Improvements

  • Added advanced base monitor logging controls in the Diagnostics section

Fixes

  • Fixes Edition filter on Server Licensing page resetting on refresh
  • Fixed a bug where some job failure alerts showed no jobs in "Details" > "Job runs during alert"
  • Fixed an issue where setting a preset time for a Analysis baseline would display time in the future
  • Fixed an issue with alerts not ending
  • Fixed an issue where standard or read-only users logging in using down-level format usernames are unable to see servers
  • Fixed an issue with the jobs estate pages sometimes showing data for previously used filters
  • Fixed an issue where Top waits graph was not being rendered

  • Fixes issue when removing cluster node with standalone instance orphans the SQL instance.

Version 12.0.11 - December 15, 2021

Improvements

  • The Estate disk usage, backups and SQL Agent jobs pages can now be filtered by tag

Fixes

  • Fixed issue when disabling or inheriting configuration for multiple alert types when the alerts have different existing email configuration.
  • Fixed issue where newly added SQL Servers would not be correctly monitored until either the base monitor is restarted or "Retry connection" run from the monitored servers page.
  • Fixed issue when disabling or inheriting configuration for multiple alert types when the alerts have different existing email configuration.
  • Fixed issue when renaming report causes new report to be created.
  • Fixed issue on versions of IIS prior to IIS 10 (Server response header was re-added).

Version 12.0.10 - December 8, 2021

Improvements

  • Reduce the time to verify an unreachable monitored entity on the Current activity page.
  • You can now see Azure Managed Instances on summary report tiles.
  • Added an option to disable insecure TLS versions 1.0 and 1.1 via the appsettings.json config file.
  • Removed Server and X-Powered-By from response headers.
  • You can now configure alerts for specific Jobs on Amazon RDS Sql Servers and Azure Managed Instances.
  • You can now configure alerts for specific Databases on Amazon RDS Sql Servers and Azure Managed Instances.
  • Tag information added to the Server Overview page
  • Tag information added to the Alert Detail page

Fixes

  • Fixed an issue where untagged/duplicate instances were shown randomly while filtering the global dashboard.
  • Fixed an issue where query history and top queries not showing data when a different base monitor is selected.
  • Fix increased Azure SQL Database DTU consumption introduced in 11.2.13 by removing OPTIONS(RECOMPILE) in topquerywaitstats.

Changes

  • Changed classification of errors caused by Azure Sql Database's firewall refusing connection to Unreachable.

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?