Version 14.0.34 - November 19, 2024

Features

• Preview support introduced for monitoring PostgreSQL instances running on Azure Flexible Server.

Improvements

• Added placeholders to input fields when configuring OpenID Connect, so it's clearer what type of value is expected.
• Replica identifiers are now displayed for PostgreSQL replication lag within the analysis page.
• Replication slot size for PostgreSQL is now available in the analysis page.
• Added Description field to PowerShell Module Manifest.
• Host machine credential and data collection failure alerts are now available for RDS hosts.

Fixes

• State information for SQL Server services on standalone instances on cluster nodes can now be sampled
  correctly.
• Made the active alert in the server overview page clickable to take the user to that alert.
• SQL Servers with SQLBackup versions earlier than 10.1.10.1722 are now supported.
• Azure SQL DB sampling will now include Differential and Log backups.
• Fixed an issue that prevented PostgreSQL servers on RDS hosts in private clouds from being added to the monitored servers list.

Version 14.0.33 - November 12, 2024

Improvements

• Allow moving machines between groups using PowerShell API.
• The UI for configuring index monitoring has been updated.

Fixes

• The monitored server hierarchy in the alerts and alerts configuration pages should now not show an extra child at the database level for RDS and Linux Postgres instances.
• When adding a Linux machine the test button should now correctly show errors when the SSH connection fails.
• Incorrect SSH passwords will now be reported correctly on Monitored Entity page.
• Fixed issue with current activity blocking filter where the filter wouldn't pick up the correct statuses. Also fixed an issue where it would sometimes report Blocked as Head blocker and vice versa.

Version 14.0.32 - November 5, 2024

Improvements

• An option has been added to allow users to choose whether copy-only backups are considered when calculating if a backup overdue alert should be raised.
• NFS mount point disk statistics are now monitored and available under disk usage for Linux hosts.
• The Configuration Compliance page now includes a pre-set template to represent the Center for Internet Security Benchmark covering SQL Server 2022.
• The Security Templates page now includes new duplicate and view actions.

Fixes

• Resolved an issue on the server overview page where a monitored entity had been removed. The page will now return a NotFound status in such cases.

Changes

• The monitoringStatus returned by the monitored entities endpoint of the REST API can now take one of the following values: Unknown, Suspended, Unlicensed, Healthy, Info, Warning, Critical. These reflect what is seen on the global dashboard.

Version 14.0.31 - October 29, 2024

Fixes

• Resolved a regression that caused the active alert count to show as zero on the Global Dashboard.
• Fixed an issue on the server overview page where the alias would show twice, instead of the alias and the fully qualified name.

Version 14.0.30 - October 22, 2024

Features

• A new query parameter has been added to the monitored entities endpoint of the REST API to allow filtering by fully qualified name or display name.
• Support monitoring PostgreSQL 17

Improvements

• Increased the spacing between rows in the in-line table used when displaying information about some alerts; such as SQL Job failure alerts.
• The Estate Backups page now includes a toggle to filter Copy-Only backups out of the Recovery point objective graph.

Fixes

• Fixed the issue of gaps in the CPU graph caused by high usage spikes on the server overview page.

• Search in the Index usage settings page now works.
• Fixed the issue of gaps in the CPU graph caused by high usage spikes on the server overview page.
• Fixed an issue where tags were not correctly cleared after clicking the "Clear" button on the Estate Backups page.
• Host machine credentials are now mandatory while adding a new SQL Server on Linux instance to the estate.
• RDS instances with advanced monitoring enabled which have been recently added or updated should no longer briefly show an incorrect AWS error.

• Fixed an issue in the group alert inbox that disabled the newer and older alert buttons due to a regression from the previous release.

Changes

• In the monitored entities endpoint of the REST API, the Name field has been changed to DisplayName and will contain the alias if one has been set. FullyQualifiedName now always returns the fully qualified name regardless of the alias.

Version 14.0.29 - October 15, 2024

Improvements

• Alert suppression windows page was modernized: it's now possible to sort, filter and export data.
• Improved the structure of the security templates page in order to make it easier to navigate.
• An option has been added to disable database unavailable alerts for databases in restoring state.

Fixes

• The back button in the dialog for creating and editing security templates no longer requires multiple clicks to close the dialog.
• Fixed an installer crash where the server or database selectors would get accessed after being disposed.
• Fixed certain values along the y-axis in the reports graphs not displaying enough decimal points.

Changes

• Be more strict when grouping instances for batch queries to the AWS description API, and add logging for the groupings.

Version 14.0.28 - October 8, 2024

Fixes

• Fixed an issue where the email server settings forgets the password after first test email is sent.
• Fixed a low severity (CVSSv3.1 2.9) SMTP password vulnerability. In regular operation, only admin users will be able to exploit the vulnerability so chances of exploiting are minimal.
• The region and database identifier can now be changed via edit credential page for RDS hosted instances. Note that the database identifier can not be updated in a batch edit as these are unique per instance.
• Monitor should now always use a region that is available to the service when querying the AWS token service.

Version 14.0.27 - October 2, 2024

Features

• Low cache hit ratio alerts are now available for PostgreSQL.

Improvements

• Added a loading indicator on the permissions page to indicate loading state from multiple base monitors.
• The "Retry connection" option in the Monitored servers configuration page has been added for PostgreSQL instances.

Fixes

• Fixed the scenario where alerts were not showing on the overview page sidebar and top graph.
• RDS IAM role assumption will now correctly use the regional endpoint for the AWS Security Token Service rather than the global endpoint.

Version 14.0.26 - September 24, 2024

Improvements

• WinRM connections now support having the option of port encoding in service principal name for Windows hosts.

• A visual indicator has been added to all the metric graphs on the server overview page to improve usability.

Fixes

• Fixed an issue where Security > Permissions > Users > Database roles page crashes when the selected user has no database roles.
• Temporary AWS credentials for RDS host metric querying should now regenerate correctly on expiry when AWS returns a local timezone rather than UTC for the expiry time.
• Fixed an issue that would result in RDS hosts using IAM Role authentication being grouped together incorrectly when querying the AWS API.

Version 14.0.25 - September 17, 2024

Fixes

• Fixed an issue for SQL Server where adding a child server role to a fixed server role would prevent permissions information from being displayed.
• Fixed an issue for SQL Server where backup alerter causes monitoring error in rare occasions.

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.