SQL Monitor v12.0.x

Released: Oct 26, 2021

Updates in v12.0.x

v12.0.18

Updated Feb 14, 2022

Fixes

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

v12.0.17

Updated Feb 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.

v12.0.16

Updated Feb 2, 2022

Features

  • Added version store usage alert.

Fixes

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

v12.0.15

Updated Jan 26, 2022

Features

  • Added the ability to view query plans on the Current Activity page.

Fixes

  • Fixed an issue with admin users seeing "*** Redacted ***" in query plan parameters.

v12.0.14

Updated Jan 20, 2022

Features

  • Added the option to remove requirement of db_owner permission on tempdb.
  • Added a horizontal scroll bar to the left sidebar on the Alert settings page.
  • You can now display blocking processes tree on the Current Activity page.

Fixes

  • Fixed an issue that could cause SQL Monitor to fail to reconnect to monitored servers after they are restarted.

v12.0.13

Updated Jan 13, 2022

Features

  • Added the option to remove requirement of db_owner permission on tempdb.

Fixes

  • Fixed a regression introduced in v.12.0.10 that causes Active Directory (AD) authentication to fail.
  • Prevent access to offline databases when sampling.
  • Fixed 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.

v12.0.12

Updated Dec 22, 2021

Features

  • Added advanced base monitor logging controls to the Diagnostics section.

Fixes

  • Fixed 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.
  • Fixed issue when removing cluster node with standalone instance orphans the SQL instance.

v12.0.11

Updated Dec 15, 2021

Features

  • 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).

v12.0.10

Updated Dec 8, 2021

Features

  • Reduced the time to verify an unreachable monitored entity on the Current activity page.
  • You can now see Microsoft 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 has been added to the Server Overview page.
  • Tag information has been added to the Alert Detail page.
  • Changed classification of errors caused by Azure SQL Database's firewall refusing connection to Unreachable.

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.
  • Fixed increased Azure SQL Database DTU consumption introduced in 11.2.13 by removing OPTIONS(RECOMPILE) in topquerywaitstats.

v12.0.9

Updated Dec 1, 2021

Features

  • You can now use deadlock report tiles for Microsoft 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.

v12.0.8

Updated Nov 26, 2021

Fixes

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

v12.0.7

Updated Nov 24, 2021

Features

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

Fixes

  • Fixed 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.

v12.0.6

Updated Nov 18, 2021

Features

  • You can now view current activity for queries from the Server overview page for on-prem instances.
  • Added permit-based licensing support for multi-webserver installations.
  • You can now tag Microsoft SQL Server instances, Microsoft Azure SQL Databases, Azure Managed Instances and Amazon RDS instances on the Monitored Servers page and use these tags to filter the global dashboard.
  • 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.

Fixes

  • Fixed a bug that prevented configuration of 2-8 alert types.
  • Fixed a bug that prevented configuring alerts if no default e-mail address had been specified.
  • 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.

v12.0.5

Updated Nov 15, 2021

Fixes

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

v12.0.4

Updated Nov 10, 2021

Features

  • Added the ability to prevent update notifications for 7 days after installing or upgrading.
  • Added in product licensing permit expiry notifications.
  • Added the ability to alias Microsoft Azure SQL Managed Instances, Amazon RDS Servers and Azure SQL Databases.

Fixes

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

v12.0.3

Updated Nov 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.
  • Fixed regression where links are not rendered correctly on the Edit Alert page.
  • Security: Delay and rate limit login attempts in case of too many invalid attempts.

v12.0.2

Updated Oct 29, 2021

Fixes

  • Fixed issue where offline activation of a permit fails.

v12.0.1

Updated Oct 28, 2021

Fixes

  • Fixed 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.
  • SQL Monitor now displays more information for Azure Managed Instances and Amazon RDS on their version and edition on the Estate Configuration page.

v12.0.0

Updated Oct 26, 2021

Features

  • Added 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 Microsoft SQL Server Configuration Options Estate page is now out of preview.
  • Migrated the SQL Monitor website to Microsoft ASP.NET Core 5. The default SQL Monitor web server is now 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

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