Features

• SRP-12621 Machines without SQL Servers that are not being monitored correctly will be indicated by a banner on the global overview if Force errored instances is enabled.

Fixes

• SRP-12250 Azure custom metrics now respect the include database field.
• SRP-12733 Redgate annotations no longer display text twice.
• SRP-12753 Disallow empty or whitespace names in Alert Suppression Window names.
• Addressed a threading issue that had the potential to cause thread deadlocks when reporting telemetry.
• SRP-12752 Alert Suppression Windows honour permissions with regards to displaying Monitored Entities.
• SRP-12748 Alert inbox filters should now work with case sensitive instances.
• SRP-12773 Fixed SQL Injection vulnerability (CVSS 6.8) in the alert notification settings page that could be exploited by users with Administrative privileges.

Features

• SRP-12257 New help menu on page header.
• SRP-12481 Powershell API for annotating the top graph for SQL Server instances.

Fixes

• SRP-12691 Fixes the issue of displaying empty content under the New Features section.
• SRP-12250 Enables custom metrics in the Analysis and Reports sections to be displayed from multiple base monitors.

Features

• SRP-12613 Maintenance windows have been improved and are now more flexible. They've also been renamed to alert suppression windows.
• SRP-12494 The waits graph in Server Overview page has togglable legends.

Fixes

• SRP-12580 A new alert for SSRS 2017+ status has been added. The existing alert is now only for SSRS 2016 and earlier.
• SRP-12692 Fixes issue with the global dashboard failing to render correctly in some situations.

Features

• SRP-12591 The graph on the estate disk usage page now takes into account cluster shared volumes.
• SRP-12639 Introduces a new alert for disk write time.
• SRP-12552 The alert report tile can now use the report time range or the alert filter time range.
• SRP-12269 Option to ignore SSL certificate errors when sending emails.

Fixes

• SRP-12659 Fixed an issue where repeated entries in elastic pool resource DMVs caused gaps in data.
• SRP-12666 Reclassify Internal SQL Monitor Error in some situations when sampling processor data.
• SRP-12669 Allowed instances with Internal SQL Monitor Error on the machine to show as red on the dashboard.

Features

• SRP-12616 Introduces a new alert for disk read time.

Fixes

• SRP-12403 Improved handling of FCI alias and fastest filling disks report uses machine name where possible.
• SRP-12426 Fix database name truncation causing an issue with managed instance waits and queries sampling.
• SRP-12469 An issue that could lead to active job failing alert groups showing as ended in the alert inbox has been fixed.
• SRP-12635 A monitored entity with "Monitoring error" status on the global dashboard now links to the server configuration page.

Features

• The Top Waits graph displays the data for selected metric in the Top Waits table.

Fixes

• SRP-12588 Fixed fragmented index alert display issues.
• SRP-12500 Some minor formatting issues affecting alert report tiles in PDF form have been fixed.
• SRP-12581 Fixed a issue with powershell API function Add-MonitoredEntity and default sql server connection properties.
• SRP-12541 Allows users from trusted active directory domains to be added to SQL Monitor.
• SRP-12598 Fix legacy api authentication used by other Redgate products.

Features

• SRP-12495 Optionally highlight servers encountering an error on global dashboard.
• SRP-12517 Installer supports using GMSA as base monitor service account.

Fixes

• SRP-12504 Upgrading a website on a multi-base monitor setup remembers the base monitor connection information.
• SRP-12557 Fixed creation of monthly maintenance window with default day of week (Monday) being persisted without a day of week being set.
• SRP-12490 Fixed vmware memory latency scaling issue.
• SRP-12559 The server downtime report now uses the local time zone.

Fixes

• Fixed an issue with the top waits graph not loading for Azure SQL Databases.
• An issue that caused top queries not to display for Azure SQL Servers has been fixed.

Fixes

• SRP-12542 Internal SQL Monitor error alerts are disabled by default.
• An issue that could cause duplicate performance counters to raise an internal SQL monitor error has been fixed.

Features

• SRP-12521 The powershell API function Get-MonitoredObjectStatus provides status information on a specified monitored entity.
• SRP-12521 The powershell API function Update-MonitoredObjectSuspendedStatus allows a specified monitored entity to be suspended or unsuspended.
• SRP-12482 Preview release of webhooks for alerts.
• SRP-12462 Displaying stored procedure, function or trigger name in top queries.

Fixes

• SRP-12492 Fixed PowerShell API support for the LowCvsSpace, SqlServerInternalSqlMonitorError and MachineInternalSqlMonitorError alert types.
• SRP-12534 Fix blank alert sidebar on global dashboard when multiple custom metric alerts present.
• SRP-12485 Using Groups in the API exposes internal data storage. API method Add-MonitoredEntity now supports -Group as a Group object. -Group as a string is to be deprecated by Version 10.0.0.
• SRP-12516 Fixed issue where newly added clusters could fail to correctly store specified WMI connection method.

Features

• SRP-12461 Displaying operating system last booted time in machine unreachable alert.
• SRP-12457 Waits graph tooltip enhanced to show all close points for overlapping lines.
• SRP-12455 Internal SQL Monitor errors now raise an alert.
• SRP-12437 Accept CSV files for server import.

Fixes

• SRP-12493 Resolved low severity (CVSS 3.4) security issue where users with Administrative privileges could retrieve configured SMTP server password for email notifications.
• SRP-12487 Fixed non-application of select all/none buttons in alert type filter.
• SRP-12476 Fixed intermittent empty dashboard when Active Directory authentication is enabled.
• SRP-12510 Fixed set maintenance window and edit maintenance window options in the monitored servers page.

Features

• SRP-12403 Server aliases are displayed in reports.
• SRP-12429 Servers with monitoring errors now show on global overview as critical regardless of alert state.
• SRP-12460 Added feedback link on maintenance window.
• SRP-12445 Added support for non-recurring maintenance windows.

Fixes

• SRP-12463 Redirects to global dashboard if returnUrl is an external domain when user already logged in.
• SRP-12466 Emailed reports show no data to display when Active Directory authentication enabled.

Features

• SRP-12436 New tile type for reports showing alert inbox filters.
• SRP-12408 Added graph for top waits in server overview page.
• SRP-12357 Introduces a new alert for cluster shared volumes space.
• SRP-12439 Added monthly scheduling support for maintenance windows.

Fixes

• SRP-12432 Prevent SQL Server instance unreachable alerts for unlicensed servers.
• SRP-12424 The hostname field (field 10) is now filled in for standalone machines on SNMP notifications.
• SRP-12447 Allow the API to specify SQL Server port when adding servers.
• SRP-12318 Monitor will no longer show query plans for queries run on a different database from that reported.
• SRP-12427 Unreachable and unauthorized status classification when WinRM is used (beta).

Features

• SRP-12393 Cluster shared volumes are now available in the analysis graphs.
• SRP-12418 All alerts can now be suppressed during a maintenance window, rather than just performance-related alerts.

Fixes

• SRP-12400 Apply blocking process regular expression exclusion to last executing SQL fragment for sleeping sessions.

Features

• SRP-12416 Added display option to allow suspended instances to either be on the global dashboard permanently or removed immediately on suspension.
• SRP-12292 Global dashboard now has a base monitor filter.

Fixes

• SRP-12361 Fixed intermittent log-out issue.
• SRP-12430 Fixed WMI issue with cluster shared volume sampling on Windows 2008R2 clusters.
• SRP-12405 Server overview alerts feed no longer fails on large request urls.

Features

• Cluster shared volumes display on server overview.

Fixes

• The elastic pools page now displays correctly.
• In the alert inbox, total blocking time for all descendants on the blocking process alert now takes into account blocking time after the alert was raised.
• Fix script error problem on Add-MonitoredEntity Powershell API Cmdlet.

Note: SQL Monitor now requires .NET Framework 4.7.2 or later.