Features

• Added the ability 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.

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.

Fixes

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

Features

• Added the ability to display query search folder size on data settings page.
• Added the ability to show full query text on the deadlock report.

Fixes

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

Features

• The Microsoft SQL Server configuration options page has been improved: it now shows a log of changes, presents a richer selection of configuration options and a table allowing comparison of values.
• Added thumbs up/down feedback mechanism to top queries search feature.

Fixes

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

Features

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

Fixes

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

Features

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

Features

• New alert on SQL Server log entry added which can be raised by matching a regex pattern.
• 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.

Features

• Added validation against incorrectly formatted custom email addresses on alert configuration.

Fixes

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

Features

• The deadlock report tile now has an option to choose how many deadlocks to display.
• Improved performance of queries that cause high CPU usage.
• Query plan changes are now identified by using query plan hashes on Microsoft SQL Server 2008 and above.

Fixes

• Fixed empty fields in notification settings causing failure when saving.
• Fixed issue with schema that prevented top queries search.

Features

• Top queries now has a text search you can use.
• You can now explore the SQL Monitor success center.

Fixes

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

Features

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

Fixes

• Fixed an issue that could cause samplers encountering SQL error message 988 to incorrectly raise alerts.

Fixes

• Fixed a regression that caused a crash when displaying alert details.

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.

Features

• The time column in the error log section of the server overview page now 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.

Features

• Added visibility of additional server configuration options for industry-standard benchmarks.
• Server configuration options are now sorted alphabetically.
• Added support for licensing SQL Monitor via logging in to your RedGate account.

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.
• Redesigned authentication settings page.

Fixes

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

Features

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

Features

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

Fixes

• Fixed escaping of logged in user name.
• Fixed 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.