Features

• Actual query plans can now be viewed in addition to estimated query plans for Microsoft SQL Server 2019 and later.
• Processor utilization (%) can now be viewed for SQL Server services running on Linux.
• You can now specify an alias when adding a Microsoft Azure MI, Amazon RDS instance or SQL Server on Linux instance to monitored servers through the Microsoft PowerShell module.

Fixes

• Remove Servers option is now available when selecting "All hosts machines" on the Monitored Servers page.
• Servers in trial mode now correctly display as "licensed" instead of "awaiting" on the licensing configuration page.
• The 'replica falling behind' alert details will now display 'log send queue' and 'redo queue' data correctly.
• The 'replica unhealthy alert' will now end automatically once the replica is healthy.
• Installer now correctly autopopulates databases for a selected server on select existing database screen.

Fixes

• Azure SQL databases that are part of an Elastic Pool no longer show up on the Global Dashboard.
• Dialogs no longer incorrectly continue hiding page content from screen readers when closed.
• Dropdowns no longer show by default on alert settings and custom metrics pages.

Features

• Estate configuration export now has Amazon RDS Microsoft SQL Server and Azure Managed Instance database configuration information available.
• It is now possible to filter Linux Machine on the Reports page.
• It is now possible to edit "Use Base Monitor service account" and "authentication type" values for SQL Server on Linux.
• It is now possible to set an Alias for a SQL Server Instance on Linux.

Features

• It is now possible to tag Microsoft SQL Sever on Linux.
• It is now possible to configure alerts on Linux machine disks.
• Increased the default tracked queries limit to 100.

Fixes

• Raise the Availability Group - database unhealthy alert when databases in synchronous commit mode remain synchronizing for more time than allowed by the alert threshold.
• What's new no longer incorrectly shows updates are available when Monitor is up to date.
• Fixed an issue installing SQL Monitor into IIS (exit code 0xe0434352).

Features

• You can now grant user access rights for Microsoft SQL Servers hosted on Linux.
• It is now possible to connect to SQL Server on Linux with Base Monitor Service account.

Fixes

• Validate Active Directory principals and ensure that domain is expanded when added by PowerShell API.
• What's new no longer incorrectly shows updates are available when Monitor is up to date.
• Fix regression where monitored instances can not be annotated using PowerShell module.
• Current Activity now correctly fills the page horizontally.
• Top queries in elastic pools overview now correctly fills the page horizontally.
• Sampling errors for some Linux network interfaces are now reported once.

Fixes

• When the list of VMware guest VMs contains two or more entries that share the same hostname and IP address, a simple heuristic is now used to determine the matching guest VM.

Features

• Now more specific with the range of Microsoft SQL Server versions that support extended events.

Fixes

• Fixed "same key has already been added" error that occurred when using numbered stored procedures.

Features

• Do not require sysadmin permissions to sample when integrity checks were performed on Azure Managed Instance and newer versions of on-premise SQL Server.
• The configuration of Microsoft SQL Server error log entry alerts now supports numeric ranges for specifying error severities and error codes to ignore, along with improved handling of individual numbers.

Fixes

• Warnings for unlicensed servers will no longer be shown on websites that do not manage licenses.
• Prospective fix for Waits sampling stopping indefinitely until the base monitor is restarted.
• Fixed an issue where duplicate values were sampled for replica info.

Features

• The licensing configuration page has been rewritten to show licensing information across all base monitors in a single view.
• Perpetual licences are now shared across multiple base monitors so there's no longer a need to activate the same serial number against multiple base monitors.

Fixes

• Fixed regression where users are forbidden to log in when OpenId Connect is used.

Features

• The "hostname" field of SNMP notifications is now also populated for Microsoft Azure MI, clusters, Postgres, Amazon RDS and Microsoft SQL Server on Linux.

Fixes

• Navigation to the Availability groups section on the server overview page now works correctly.

Features

• Top queries are now grouped by query hash. This reduces duplication of ad-hoc queries.
• It is now possible to connect to Microsoft SQL Server on Linux with Microsoft Windows credentials.

Fixes

• Improved the performance of WMI connections, greatly reducing the number of open outgoing network ports from the Base Monitor.
• What's new, Help and Feedback button links in the top navigation function correctly.
• SQL Index sampler queries will no longer be picked up as a long running query.
• Deadlock alerts are now correctly shown when filtering by database.

Features

• You can now use embedded version of Microsoft SQL Server versions data in the estate page if it is newer than downloaded %ProgramData%\Red Gate\SQL Monitor\SqlServerVersions.json.
• Improved performance of the login for Microsoft Active Directory.

Fixes

• Improved query performance when generating data for the longest running queries summary report, including a bug fix for Azure SQL Servers.
• Query plans are now accessible through alert details page.

Fixes

• Tags in alert inbox table rows now wrap correctly.
• SSIS service alert is now correctly raised for SSIS 2016 and later.

Fixes

• Collection of memory grant values in top queries is now more robust. Historical data might have gaps, and this might be exposed as negative memory grant values in top queries.
• Alerts Inbox is grouped by default again.
• Alert details page no longer crashes in rare scenarios of unavailable details of blocked processes.

Features

• You can now view information about Microsoft SQL Server instances hosted on Linux in your reports.
• Top procedures now works in the elastic pools overview.
• Added I/O metrics for SQL Server for on-prem, Amazon RDS and Linux monitored entities.

Fixes

• Fixed a medium severity (CVSS 6.3) security issue where authorized users could perform certain actions despite lacking the relevant permissions.
• Fixed a low severity (CVSS 3.1) open redirect vulnerability on the alert configuration page.
• Display settings will no longer fail to load after making a change.
• Fixed sampling issues for Linux machines that are not virtualized.
• Procedures with high averages but low totals will now correctly show up in top procedures.
• CPU load data is now collected correctly for Linux machines with different number formatting settings.

Fixes

• Fixed communication protocols link on estate configuration page for failover cluster instances.
• Graphs shown in the server overview pages are no longer missing samples at the start and end boundaries.
• Long Running Query alerts are no longer raised for a wider range of background administrative services for both Azure SQL Databases and Azure SQL Managed Instances.
• Blocking process alert details page no longer crashes if the blocked SQL fragment details are unavailable.

Features

• Connection properties can now be edited for monitored Amazon RDS SQL Servers.
• Added '-BaseMonitor' parameter to Get-SqlMonitorGroup Microsoft PowerShell cmdlet to better support adding a monitored entity assigned to a group when the group is defined in multiple base monitors.

Fixes

• Links in the Server Overview no longer scroll you to the top of the page when clicked.
• Timezone information is now correctly retrieved from Red Hat Enterprise Linux.
• Tracked queries no longer shows a "no tracked queries" message when all tracked queries data is purged.

Features

• You can now view metrics for Microsoft SQL Server hosted on Linux on the Analysis page.
• You can now suppress alerts on SQL Server hosted on Linux.
• Added expand functionality on top procedures to display the queries in the stored procedure.
• Included repository information for SQL Server on Linux instances when retrieving log files.
• "Flyway" can now be specified as the source of an annotation through the Microsoft PowerShell API.

Fixes

• When a stored procedure name is not available due to reduced permissions on the monitored database it will now be sampled with "Unknown procedure" as its name followed by its object ID.
• Fixed an issue where Azure SQL Databases cannot be suspended on the Monitored servers page.
• Fixed an issue with using exact search terms whilst also specifying to search within parent object or database in Top Queries search.
• Fixed an issue where the collection of metrics gets delayed causing data gaps when there are many custom metrics.
• Fixed issue where Top Procedures might generate duplicate data. NOTE: This will dispose of any existing Top Procedures data.
• Fixed an issue where Availability Group replica not healthy alert does not end.
• Fixed the issue that caused a monitoring error when parsing time zone IDs on Linux systems.

Features

• Added 'Page Life Expectancy' alert.

Fixes

• Fixed an issue where searching by database name on the global dashboard wouldn't work for Amazon RDS SQL Servers or Azure Managed Instances.
• Fixed an issue where the test connection button when adding an Amazon RDS SQL Server button would not work correctly when specifying a custom port number.

Features

• Added 'TrustServerCertificate' option when connecting to Amazon RDS SQL Servers and Microsoft Azure Managed Instances.

Fixes

• Resolved an issue where negative request memory grants could cause gaps in collected data for Azure SQL Databases.

Features

• Added 'Top procedures' to performance diagnostics section of the server overview.
• Support for monitoring SQL Servers on Linux machines (Preview feature).
• The PowerShell API module's contents are now authenticode signed.

Fixes

• Fixed an issue where alert settings may be applied to the wrong base monitor.

Features

• You can now use Microsoft Windows account impersonation when connecting to Amazon RDS SQL Servers for monitoring.

Features

• Added support for monitoring an Amazon RDS SQL Server as the Base Monitor's service account.
• Disk IOPS metrics for Amazon RDS SQL Server environments are now retrieved from the basic CloudWatch API instead of the Enhanced Monitoring API, making them available in more cases.
• The disk I/O metric in the activity graph has been changed to total bytes per second instead of transfers per second.
• Changed RDS Network Utilization machine metric to be 'BytesTotalPerSecond' in the Analysis page.

Fixes

• Resolved an issue with incorrect data being displayed for disk and network metrics on Amazon RDS instances for data retrieved through the AWS API.
• Resolved an issue with paging controls on the alert inbox in Firefox.
• Resolved an issue whereby when an Amazon RDS SQL Server was added without supplying any AWS API credentials, and then those credentials were provided some time afterwards, the collection of enhanced monitoring data would silently fail. If you have any existing servers affected by this issue, you will need to resupply the AWS API credentials in order to rectify the problem.
• Resolved an issue where incorrect disk I/O metric data was displayed in the activity graphs for Amazon RDS and Azure Managed Instance SQL Servers.
• Resolved an issue where the Top Queries row action dropdown clipped behind the sidebar.
• Resolved an issue with database paging not correctly displaying the total number of database.
• Fixed wrongly labeled title within estate configuration communication protocols.
• Resolved an issue with annotations not always loading in multi-Base-Monitor configurations.
• Resolved an issue where the server overview page linked to the estates version page for unsupported entity types.

Features

• SQL Deadlock XE alerts are now supported on Amazon RDS (requires SQL Server Standard or Enterprise edition).
• Exposed base monitor GUID and the time when an alert was raised in webhook notifications.

Fixes

• When upgrading the SQL Monitor web server on IIS, the IIS worker process should no longer block installation, although it will still be necessary to wait for the worker process to release file locks.
• Potential fix for faulting web server when accessing a blocking SQL process alert.
• Resolved a low severity (CVSS 3.1) issue where in certain scenarios users could still see monitored servers they used to have permission to.

Features

• Removed Memory utilization alert for Azure SQL Database.

Fixes

• Fixed Top Waits in Alert Details crashing on row expansion.
• Fixed monitored server page status filter.
• Now retains group membership of a newly added server when it gets renamed as part of cluster detection.

Fixes

• Ensure tracked queries can show queries with no records.
• Fixed out-of-range tracked queries not showing on Query Impact tab.
• Fixed an issue with the comparison table instance dropdown sorting when there are multiple Base monitors.
• Fixed an issue where monitored entity name does not escape backslashes when used in a GET request in PowerShell.

Features

• 'Disk usage estate' tab now better handles disks that aren't always attached.

Fixes

• Fixed an issue where instance discovery may fail to run.
• Fixed a bug where the alert details for the fragmented indexes alert would not display any data.

Features

• Improved the performance of web requests made using Authentication Tokens, such as when using the SQL Monitor Microsoft PowerShell module.
• Tracked queries are now limited to 25 per monitored instance.

Fixes

• Fixed an issue where SQL Server instance unreachable alerts may not be raised for SQL Server instances using a non-default port.
• Fixed an issue where the alert details page for the Custom Metric Collection Error alert would sometimes have data missing.

Features

• Top query search has been improved to allow you to search by database name and parent object.
• The 'long running query alert' details page now shows the job name and ID for Amazon RDS SQL Servers and Microsoft Azure Managed Instances.

Fixes

• Fixed issue in Current Activity Page when the query status is rolling back.
• Fixed a bug in the TempDb graph by excluding entries that do not have real sample values.
• Fixed top query details not being visible on current Firefox ESR release (version 91)
• Fixed the collection of Top Queries data that was broken since 12.1.26 for the following SQL Server versions: 2008, 2008R2, 2012 (less than SP3), and 2014 (less than SP 10)
• Fixed a Configuration/Monitored servers page crash when a primary Base Monitor is not available

Features

• Job Name will now be shown in user processes and blocking process.
• Accessibility improvements and bug fixes to the date picker.

Fixes

• Fixed an issue where top queries was broken for Azure SQL Databases names that weren't all lower-case. Azure SQL Database names now appear with the original casing on the global dashboard rather than all lower-case.
• Fix Job Name not showing in long running query alerts happening on localhost
• Fixed the server overview blocking tree rendering duplicates when data was refreshed
• Fixed a bug where the tracked query button was added to the database overview top queries
• Fixes an issue displaying some top query details for queries whose total duration is less than 1ms
• Fixed a bug where retrieving the query plan for a query would fail if there were multiple plans for the same plan handle within a short space of time.

Features

• Improved accessibility of Top Queries, Top Waits and Current Activity tables.
• Query impact formula now uses logical reads instead of physical reads.

Fixes

• Addressed a denial of service vulnerability in the Alerts inbox group details pages, where large page sizes could cause undue load on the SQL Monitor web server.
• Display Names on Global Dashboard cards should now be correct.
• Fixed issue with "Connection failed: Bad Data" error when CPU Time overflows.

Features

• You can now track specific queries in the top queries section, and they will appear in the new tracked queries tab. This feature is in preview.
• Added blocking and blocked process names to the blocking process alert email.

Fixes

• Prospective fix for Top Queries and Waits sampling failing when a negative value ends up in the database.
• Prospective fix for Jobs being ordered incorrectly in alert emails.
• Prospective fix for auth type not being set correctly when adding AD Principal via PowerShell.
• Prospective fix for version store used percentage being more than 100% on an alert.
• Backup and job times are now correctly sampled for any Amazon RDS instance created with a non-default timezone. AWS API monitoring credentials must be provided for this correction to occur.
• Fix some custom alerts not ending when database is excluded from custom metrics.
• Current activity filters now restricted to displaying 3 of the selected items, preventing the control from going off the edge of the screen.
• Fix vulnerability in Alert Details allowing an arbitrary comment author with OpenID/AD authentication. The vulnerability has a CVSS score of 4.3 (Medium). Thanks to Samira Karimi Aghmiuni for reporting the vulnerability.

Fixes

• Prospective fix for Top Queries and Waits sampling failing when a negative value ends up in the database.
• Fix for active custom alerts not ending when database is excluded from the custom metric.

Features

• Filters in the Monitored Servers page are now persisted through page refreshes.

Fixes

• Fixed an issue on the Estate page that prevented SQL Agent jobs from being filtered by Day/Week/Month.

Features

• Metrics for entity types that are not being monitored will no longer appear on the Analysis graph's metric selector.
• Added "WAIT_XTP_HOST_WAIT" to the sampler's list of ignored waits.
• Renamed and made clearer the example script to copy the Alert Settings across multiple entities.

Fixes

• Dropping databases in Azure Managed Instances are no longer categorized as an authentication error, so it should now correctly resume monitoring when the database is recreated.
• Fixed an issue with the Estate backups tab not correctly filtering databases on the page and when exporting.
• Query plans will now show if they were compiled for a different database. Monitor will show an informational message when showing a query plan compiled for a database that differs to what may have been shown elsewhere in Monitor.
• Fixed a graphical layout bug with the Blocking Table in Current Activity.
• Fixed instance waits table showing incorrect values.
• Fixed an issue where alert suppression windows would not load when running SQL Monitor in certain IIS setups.
• Fixed bug where the context menu for report tiles are displayed incorrectly on the report page.
• Failover cluster instances are now displayed on the Monitored servers page with the same name as on the Global dashboard.

Features

• The Global Dashboard now caches your monitored servers, so you can navigate to their overviews without having to wait for the Dashboard data to load.

Fixes

• Fixed long-running query alerts for Azure Managed Instances.
• Fixed SQL Monitor upgrade failure related with Cluster-Machine link.
• Fixed an issue with the scheduling of SQL Monitor update checks.

Features

• The top queries tab on the alert details page is now visible for all types of monitored server.
• Added a link in the tag filter list for assigning tags.

Fixes

• Fixed Top Waits in Top Queries not showing only the waits for that query.
• Fixed Top Queries in Top Waits not being filtered down to only queries with the opened wait.
• Fixed an issue in SQL Server error log sampler due to date time parsing failure.

Fixes

• Monitoring older SQL Server versions should no longer raise error about SQL Monitor not having 'securityadmin' role.
• Fixed an issue with query plans in dialogs not fitting to the whole dialog.
• Fixed an issue with grouping of custom alerts not working properly if they have different ids across base monitors.
• Fixed an issue with "Window range" options on server overview pages not always being correctly applied.

Features

• Memory metrics are now shown in the server overview's activity graph and analysis metrics for Microsoft Azure SQL Managed Instances.
• Improved UI responsiveness when changing the focus range of the activity graph in the server overview pages.
• Improved UI for dealing with live updates and navigating to the current time in the server overview.

Fixes

• Fixed missing VM Host entry in legend for CPU and memory metrics.

Features

• Added new table where queries are ordered by their impact which is available under top queries.
• You can now raise an alert when a Microsoft Azure SQL Database becomes unavailable.
• Replaced the documentation link for the top queries search box with an in-product help popup.
• Updated the number of samples used by all graphs in the server overview pages to improve resolution and consistency.
• Top graph timeline annotations can now be added to cloud servers.
• Moved max results dropdown in TopQueries from below the table to be shown above the table.

Fixes

• The alerts settings page correctly refreshes after removing overrides.
• Improvements to cursor queries that iterate over databases.

Fixes

• Fixed an issue where "License will expire in x days" warning would appear when Permits are not used.
• Fixed an issue where the server overview page would fail for any SQL Server for which monitoring had been suspended.
• Error log entry alert can now be raised for errors raised before SQL server shut down.
• Fixed generic error briefly showing on first load of the Alert Inbox.
• Pagination options for databases shown on Azure Managed Instance and Amazon RDS server overviews are now correctly respected.

Features

• You can now auto-resize some Current Activity and Top Queries columns to their contents.
• Added query context to the recommendations dialog in Top Queries.

Fixes

• Fix showing stagnant alerts when link is followed from Global Dashboard.
• Addressed a migration issue when upgrading from V8 with Azure SQL Servers added.
• Fixed a possible memory leak due to Active Directory sampling.

Features

• User account can now be specified for Microsoft Windows service hosting Website, in addition to default Local System.
• Exposed query plan handle in expanded query details under current activity.
• Renamed value of the SERVICETYPE property from network to local. This property is passed to Web installer msi during an unattended installation.

Fixes

• Custom metrics also apply to newly added servers if all servers selected.
• Fixed recommendations not finding a sampled query plan for SQL Server 2012 instances.
• Correctly classify errors seen on Amazon RDS as connectivity errors rather than authorization errors.

Features

• Query recommendations are now available in the 'top quer