Version 14.0.24 - September 12, 2024

Fixes

• Fixed an issue that caused high resource usage on instances with a large number of Availability Groups.
• Fixed an issue where the comments tooltip on the Alerts page shows the most recently edited comment instead of the most recently added.
• Fixed an issue where the comments tooltip on the Alerts page still shows deleted comments if the deleted comment was the most recently edited.
• Fixed an issue which could cause the repository upgrade step to fail due to potential data truncation.
• Fixed an issue where recurring alert suppression windows created via PowerShell API had a null start date, causing errors when changing the alert suppression window to non-recurring.
• Fixed an issue where Azure SQL Managed Instance instances were not reporting authentication errors correctly.
• Fixed an issue where SQL connections may have remained open longer than required.

Version 14.0.23 - September 4, 2024

Features

• Added survey for MongoDB, Oracle and MySQL support for EAP.

Improvements

• Redgate Monitor repository database hosted on Amazon RDS is now supported. See documentation for more information.
• Redesign of the 'Alert History' and 'Occurrences' tab in the alert details page, that combines them into one tab and allows for easier access to previous comments.
• Re-implemented a change for alert summaries on the Availability Group overview page such that they are now aligned with the Global Dashboard (now retrieves alerts from the last 15 minutes).
• Admins can now grant users access to specific cluster nodes using the PowerShell API.
• Authority URLs will now be validated when creating an OIDC configuration.
• Last selected time range on Activity Graph is now persisted for improved experience.
• Fixed filtering and exporting of Security > Permissions > Database > Database users page.
• Licensing new monitored entities is now more responsive
• Active Directory integration now makes fewer calls to Active Directory while calculating authorized entities for a user

Fixes

• Fixed an issue where selecting all alerts across pages did not respect the filtered server hierarchy
• Fixed an issue where top queries for postgres connections could error if the connection was closed.

Version 14.0.22 - August 28, 2024

Features

• Alias for monitored servers can now be set also from the Configuration > Monitored Servers page.

Improvements

• previous-alert-severity}}` is now available as a custom webhook message parameter.

Fixes

• The analysis page no longer fails to load entities for users with access to no entities on any single Base Monitor.
• Fixed an issue where the Alert Severity is misreported in the Script and Webhook Notification Channels. If the earlier behaviour is preferred, the 'previousSeverity' field in the script payload or webhook templates can be used in place of 'severity'. Slack is unchanged.
• REST API Alerts endpoint now returns cleared alerts.
• An old extended events session named sqlmonitor_session will be dropped.

Version 14.0.21 - August 20, 2024

Major changes

• Performance improvements to the handling of text data in the Redgate Monitor data repository. Please note that the data migration that occurs when the Base Monitor restarts after upgrading will take longer than usual while the changes are automatically applied.

Features

• Add uptime summary tile to reports page which shows all the servers in the estate sorted by uptime in ascending order.

Improvements

• Added an error log message with details on how to resolve Entra OIDC tokens hitting the group claim limit
• The global dashboard now requests and caches data on a per-Base Monitor basis, improving performance for large estates.

Fixes

• Added new exception for SSH message 'This account is currently not available.' to show better exception message.
• Fixed various bugs when working with access rights via the PowerShell API.

Version 14.0.20 - August 13, 2024

Fixes

• Added new exception for SSH message 'This account is currently not available.' to show better exception message.
• Permissions sampler will no longer throw exceptions on read-only databases.

Changes

• Updated the alert summaries on the availability group overview page to be aligned with the global dashboard (now retrieves alerts from the last 15 minutes).
• Autocomplete is now disabled for LDAP login username field.

Version 14.0.19 - August 12, 2024

Fixes

• The global dashboard correctly refreshes automatically. Regression was introduced in Redgate Monitor 14.0.17.

Changes

• Autocomplete is now disabled for LDAP login username field.

Version 14.0.18 - August 7, 2024

Improvements

• PostgreSQL instance alias may now be updated via PowerShell using the Update-RedgateMonitorMonitoredObject cmdlet.
• Linux machine hosts, Amazon RDS hosts, and Amazon Aurora clusters' groups may now be updated via PowerShell using the Update-RedgateMonitorMonitoredObject cmdlet.

Fixes

• Fixed a medium severity (CVSS 4.1) security issue whereby report graph titles could have links injected into them by an authenticated report author.
• Fixed an issue around estimating and reporting data compression in the Redgate Monitor repository.

Version 14.0.17 - August 6, 2024

Fixes

• Process name having comma was breaking ssh process sampler that fixed with forward slash split approach.
• Fixed an issue where the Security > Permissions > Database page crashes after selecting a specific database.

Version 14.0.16 - August 2, 2024

Improvements

• Prevent excessive Redgate Monitor log entries being recorded for "SQL deadlock deprecated"
• Renamed empty failed jobs table message in Estate > SQL Agent jobs page for improved clarity.
• Fixes
• Fixed an issue on Analysis page where metrics were not being displayed correctly for multi Base Monitor environments.
• Fixed an issue that could cause high memory usage under high load
• Fixes a performance issue on installations using the tagging feature

Version 14.0.15 - July 31, 2024

Fixes

• Fixed an issue caused by a gap in the SQL process sampler, that resulted in long-running query alert to end and raise again.
• Fixed an issue where the alert inbox could be in an inconsistent state when servers were suspended.
• User permissions details export now exports tags as correctly.
• Show on server overview timeline" button on the Estate Backups page now works correctly.
• Fixed host data, such as CPU, from RDS instances stopping being sampled after a number of days.
• Rolled back a recent optimization to the collection of custom metrics as it has caused some compatibility problems for some users.

Changes

• Updated the alert summaries on the cluster overview page to be aligned with the global dashboard (now retrieves alerts from the last 15 minutes). Removed the "Last 24 Hours" metric column.
• Perpetual license activation within Redgate Monitor has been removed. All licenses need to be allocated through the Redgate portal.

Version 14.0.14 - July 24, 2024

Improvements

• Admins can now grant users access to specific cluster nodes. Previously, access could only be granted to the entire cluster.
• Added interactive help text for PostgreSQL current activity columns.
• Improved the collection performance of custom metrics for servers with a large number of databases.

Fixes

• Server properties" section on Azure SQL Databases is now renamed to "Database properties".
• Fixed an issue where a failure case around obtaining a PostgreSQL log file path on Amazon RDS Aurora wasn't handled as expected, resulting in spurious errors.
• Rounded Fragmentation Index alert to 2 decimal places

Version 14.0.13 - July 19, 2024

Improvements

• Global Dashboard can handle a far larger number of entities without hitting browser limits.
• Data purge frequency is now configurable.
• Improved the performance of the Get-RedgateMonitorInstance cmdlet when querying all servers.

Fixes

• Removing uninstalled instances via Remove-RedgateMonitorMonitoredObject cmdlet no longer throws exception.
• The Versions page under Estate will no longer recommend users to update instances of SQL Server 2016 to the latest Azure Connect Feature Pack GDR unless that instance is already using an earlier version of it.

Changes

• Global Dashboard will no longer filter databases during the initial loading.

Version 14.0.12 - July 16, 2024

Improvements

• Improved performance in the security permissions page on the user details tab.

Fixes

• The Top queries history graph will not discard the first sample for the date range.
• Corrupted search indexes now return a more user-friendly error message.
• Deleting a custom metric no longer fails
• Fixed an issue whereby Azure Cloud Cost credentials do not migrate properly when the Credential Encrypting Key is rotated. This resulted in the client secret being lost, requiring the user to re-enter it.

Version 14.0.11 - July 9, 2024

Improvements

• PostgreSQL: Login database can now be set when adding an instance via the PowerShell cmdlet.
• Tagging for PostgreSQL instances is now available on the monitored servers page.
• Current Activity information for SQL Server now includes a percent complete value for certain commands.
• Added the back-end start column to the PostgreSQL current activity table.

Fixes

• Fixed an issue with PostgreSQL query plan changes that incorrectly reported a change near the start of the window range.

Version 14.0.10 - July 2, 2024

Features

• The Current Activity feature now has preview support for PostgreSQL instances

Fixes

• Speculative fix for an issue where Disk usage export was failing.

• Fixed a bug in the Update-Principal cmdlet in the PowerShell API. This bug was first present in version 13.0.46.

Changes

• Table columns in the current activity view can now be sorted in both ascending and descending directions.

Version 14.0.9 - June 25, 2024

Improvements

• PostgreSQL instances with IAM authentication can now also be added via the PowerShell API.

Fixes

• Comparison percentages for alert counts by type on alert summary report tiles now calculated correctly for clusters.
• Fixed an issue preventing clearing stagnant alerts in the global dashboard from working as intended.
• Fixed an issue where a URI having more than 255 characters would crash the Redgate Monitor Web Application
• Fixed an issue preventing users from assigning access rights to a group with the character ] in its name.
• Sampling permissions will no longer crash the Base Monitor when there are circular Active Directory memberships.
• Local Active Directory users are now shown on Security permissions page server details tab.

Changes

• In the "Monitored servers" view, selecting "All host machines" now also selects RDS hosts

Version 14.0.8 - June 14, 2024

Security fixes

• CVE-2024-35255 Updated the Azure.Identity package to 1.11.4 and the Microsoft.Identity.Client package to 4.61.3 to address a reported vulnerability. The vulnerability has a CVSS base score of 5.5 (Medium), and requires local access to a machine where the Redgate Monitor Website or Base Monitor is installed to be exploited. See https://msrc.microsoft.com/update-guide/vulnerability/CVE-2024-35255 for more details.

Fixes

• Speculative fix for an uncommon deadlock that can occur when sampling stored procedure stats.
• Fixed an issue where the Processor (CPU) utilization alert details page would sometimes incorrectly claim the data had been purged.
• Fixed an issue where some access control checks were incorrectly blocking access to resources for some authorized users.

Version 14.0.7 - June 11, 2024

Features

• Added an alert for Network Utilization on Windows and Linux machines. Disabled by default.

Improvements

• Improved performance and reduced RAM usage in Permission sampling for SQL Server.

Fixes

• Linux machine processes with high memory usage are now displayed even when their CPU usage is insignificant.

Version 14.0.6 - June 5, 2024

Improvements

• Usability improvements to the index sampling configuration page including notifying the user of the success or failure of monitoring status updates.
• Added "Next Run Date" column to the exported Excel spreadsheet for SQL Agent jobs.
• Improved the sampling of processor activity for Linux hosts by sampling /proc/stat.
• Added "Last request start" and "Last request end" columns to the SQL Processes table.
• Improved performance on Security Permissions Server and Database tabs.

Fixes

• Comparison of encryption state in database configuration templates are now valid.
• Fixed a rare issue where a deadlocks report would fail unexpectedly.
• Fixed an issue where memory usage was incorrectly calculated for top processes on Linux hosts.

Version 14.0.5 - May 28, 2024

Features

• Amazon RDS and Aurora PostgreSQL instances now support database login via IAM credentials
• AWS based instances that support enhanced monitoring can now authenticate via an IAM role in addition to IAM user credentials

Version 14.0.4 - May 21, 2024

Features

• Significant PostgreSQL query plan changes are now visible in the top queries history view.

Improvements

• Monitoring of SQL Server index usage can now be enabled or disabled on a per-instance basis. If you have previously enabled this feature via the Indexes feature flag, please examine the Index usage settings configuration page after upgrading to ensure that the settings are suitable for your installation.

Version 14.0.3 - May 14, 2024

Security fixes

• CVE-2024-32655 Updated the NpgSql package to 8.0.3 to address a reported vulnerability. The vulnerability has a CVSS base score of 8.1 (High), but Redgate Monitor's use of this library has an environmental score of 6.4 (Medium). See https://github.com/npgsql/npgsql/security/advisories/GHSA-x9vc-6hfv-hg8c for more details.

Features

• Replica Not Healthy alerts are now available for PostgreSQL

Fixes

• Linux Machine logical disks mount points now update correctly when changed.
• Annotations showed correctly regardless of case-sensitivity of the instance/database name
• Fixed an issue where newer/older alert navigation links are greyed out.
• View actual plan button for Azure SQL Databases now appears correctly if the database has LAST_QUERY_PLAN_STATS option enabled.

Changes

• Rename the redundant folder of "SQL Monitor" from the ProgramData folder left after upgrade from v. 13 to avoid future confusion.

Version 14.0.2 - May 7, 2024

Fixes

• Disk usage export should handle exceptions in individual base monitors and show them in a separate sheet.
• Monitor Security auditing permissions page no longer fails to load when there are more than one custom SQL server roles.

Version 14.0.1 - April 30, 2024

Improvements

• Metrics added to the analysis page in the same unit will now show on the same scale. This behavior can be disabled by checking "Independently scale metrics using the same unit".

Fixes

• Fixed an issue applying edit credentials to SQL Server instances when use Base Monitor service account was checked.
• Viewing all configuration options on server overview pages no longer fails to load.
• Fixed broken documentation links in the PowerShell module.

API changes

• The PowerShell API now supports adding Azure SQL Databases and Azure SQL Managed Instances with Microsoft Entra ID Managed Identities.

Version 14.0.0 - April 18, 2024

Major changes

• SQL Monitor has been rebranded to Redgate Monitor. There are a number of breaking changes which means some manual changes may be needed when upgrading. We strongly recommend that you read the migration guide before upgrading. Redgate is committed to making the upgrade process as seamless as reasonably possible.
• Introducing Redgate Monitor Enterprise edition, a new product edition giving access to additional functionalities: Security - Permissions, Security - Configuration compliance and a REST API. See our webinar for more details.
• Past and current user permissions for SQL Server servers and databases are now visible in a new tab. Available only in the Enterprise edition.
• Configuration of monitored SQL Server servers and databases can be checked against custom templates. Available only in the Enterprise edition.
• Redgate Monitor can be queried directly using Monitor's REST API. Available only in the Enterprise edition.

Security fixes

• CVE-2024-32036 Updated the SixLabors.ImageSharp package to 3.1.4 to address a reported vulnerability. The vulnerability has a CVSS base score of 7.1 (High), but Redgate Monitor's use of this library was not enabled. See https://github.com/advisories/GHSA-5x7m-6737-26cr for more details.

Improvements

• Improved "Spill Occurred" recommendation text and logic behind showing it.

Fixes

• Fixed an issue where the configuration page for an alert would not load when accessed via the server overview page.
• Fixed issue of some values appearing as '0KB' in Spill Occurred recommendation.
• Fixed an issue where a recurring alert suppression window that was created using the PowerShell module could not be edited in the UI.

API changes

• There are several breaking changes to the PowerShell API. Please consult the migration guide for more details.