Fixes

• Editing credentials on the monitored servers page will no longer incorrectly show credentials from a previously edited server.
• Stop showing Azure SQL Databases on SQL Server versions Estate page until it is fully supported.
• Fixed Get-SqlMonitorDatabase PowerShell cmdlet so that it doesn't show deprecated warnings.
• Fixed an issue where comments on alerts could not be edited or deleted.
• Fixed an issue where all Azure SQL databases in an Elastic pool were displayed on the Global Dashboard.
• SQL Server on Linux is now displayed under the correct Group on SQL Agent jobs and SQL Server versions Estate pages.

Feature

• Added beta support for Amazon Aurora PostgreSQL instance monitoring.
• Additional explanation has been included in the PostgreSQL replication area.

Fixes

• Fixed an issue where the Alert Suppression Window fails to load for Azure Entities using Azure Integrated Authentication.
• Fixed an issue where GMSA authentication failed when connecting to SQL Server.

Feature

• Microsoft SQL Server versions page now supports SQL Server on Linux, Microsoft Azure Managed Instances and Amazon RDS SQL Servers.
• Improved sampling data for databases with non-English characters in their names.
• API changes:
  • Added the following Microsoft PowerShell cmdlets to support both OIDC (OpenID Connect) and Microsoft Active Directory (AD) access management: Get-SqlMonitorPrincipal, New-SqlMonitorPrincipal, Update-SqlMonitorPrincipal and Remove-SqlMonitorPrincipal.
  • Added OIDC (OpenID Connect) support for the following PowerShell cmdlets: Add-SqlMonitorAccessRights, Remove-SqlMonitorAccessRights, Test-SqlMonitorGroupAccess and Test-SqlMonitorMonitoredObjectAccess.

Feature

• The configuration page now supports Microsoft SQL Server on Linux.
• SQL Agent jobs page now supports SQL Server on Linux, Microsoft Azure Managed Instances and Amazon RDS SQL Servers.

Fixes

• A query that could cause excessive resource usage on the data repository when viewing a server overview is no longer run.
• Actual query plan collection no longer errors on plans containing multi-byte characters.
• Adding new servers through the UI or using PowerShell will now complete earlier and not wait for non-critical work to finish.
• Fixed an issue where Availability Groups information was not shown in the Server Overview for a default SQL Server instance if there were other named instances on the same host.
• Group membership for OIDC users is now immediately refreshed after logging in.

Feature

• Microsoft Powershell API now includes the ability to select which Microsoft Azure SQL Databases to monitor.
• The WAL size graph now includes a max WAL size metric line for PostgreSQL outgoing replication.
• API changes
  • Some PowerShell cmdlets are now singularized to follow Microsoft guidelines. The old names have been kept as aliases for now, but they will be removed in a future version of SQL Monitor, so please migrate your scripts. Singularized cmdlets: Add-SqlMonitorAccessRights, Remove-SqlMonitorAccessRights, Update-SqlMonitorAlertSettingsComments, Get-SqlMonitorMainGroups, Get-SqlMonitorSubGroups, Add-SqlMonitorTags, Get-SqlMonitorTags and Remove-SqlMonitorTags.

Fixes

• Fixed an issue with sampling from a read-only PostgreSQL instance.
• API changes
  • Fixed usage of Get-SqlMonitorMonitoredObject for Postgres instances hosted on Amazon RDS.

Feature

• Recommendations based on actual plan warnings are now available on servers/databases where actual plan collection is enabled.
• Re-enabled top query recommendations indicator.

Fixes

• Fixed an error fetching tracked queries if top queries' data retention was set to indefinite.

Fixes

• Fixed an issue where SQL Server log entry Alert threshold values could not be configured.
• Fixed regression where top queries, tracked queries and top procedures were not being sorted correctly. Introduced in version 13.0.21.

Features

• You can now select which Microsoft Azure SQL database to monitor.
• You can now edit connection properties for monitored Azure SQL databases.
• SQL Monitor service accounts no longer require 'db_owner role' database role.
• Impact view now shows columns contributing to impact calculation.

Fixes

• PostgreSQL instances in Amazon RDS will now suspend and resume monitoring along with their associated host.
• The version of Cybertec PostgreSQL instances will now be properly retrieved.
• Prevent backup overdue alerts from being raised when there is insufficient data.
• Security fixes - Resolved a Denial of Service vulnerability that affects the built-in web server used by the SQL Monitor Web Service. The CVSS base score is 7.5 (High) and it's recommended that all customers upgrade to avoid this issue. Any denial of service attack would not compromise the confidentiality or integrity of any information held by SQL Monitor.

Features

• You can now see the UTC offset in Summary title for Microsoft Excel reports exported from the Estate pages.
• Added incoming replication charts for PostgreSQL monitoring.
• Microsoft PowerShell API now supports passing a combination of objects constructed using New-SqlMonitorWindowsHost and New-SqlMonitorSqlServer cmdlets to the Add-SqlMonitorMonitoredObject cmdlet.

Features

• Top queries recommendations indicator released in v13.0.17 has been disabled temporarily.

Fixes

• Fixed an issue where the Export CSV link was not visible on the Analysis page.

Fixes

• You can now see the entire query when hovering over a query on the Longest running queries tile.
• Alert group details page no longer fails to load.

Features

• Added an indicator to top queries table for queries that have recommendations.

Fixes

• Fixed a medium severity (CVSS 4.3) open redirect vulnerability. In regular operation, a user will never see the malicious link, so the chances of exploiting are minimal.

Features

• You can now use private endpoints for SQL servers and PostgreSQL servers hosted on Amazon RDS.
• Renamed 'Get-SqlMonitorSshPrivateKeys' Microsoft PowerShell cmdlet to 'Get-SqlMonitorSshPrivateKey' and added a '-Name' parameter to allow filtering by name.

Fixes

• Fixed an issue where monitoring was failing with 'The input string was not in a correct format' error.
• Allow to use proxy for licensing server from Website.

Features

• You can now connect to Microsoft Azure Managed Instances and Azure SQL Databases using Azure Active Directory integrated authentication.
• PostgreSQL physical streaming replication data is now monitored and can be viewed from the server overview page.
• It is now possible to choose a specific database to login to when adding a PostgreSQL instance.
• Latest actual plan can now be viewed from inside the query recommendations dialog.
• Suspension and unsuspension of Azure Managed Instances and Amazon RDS SQL Servers is now possible.

Fixes

• Fixed query history chart not rendering anything other than actual vs estimated drift. Issue was introduced in 13.0.14.
• Fixed an issue where monitoring was failing with 'Failed to read property' error.
• Fixed suspend/resume of multiple Linux Machines so that all children are also suspended/resumed.
• Fixed Group not being set properly when adding instances via PowerShell.
• Fixed an issue displaying availability group database status information where database names are inconsistently cased across the availability group.

Features

• Deadlock rate alerts are now available for PostgreSQL.

Fixes

• Suspended Azure SQL Databases are no longer displayed on dashboard if the configuration to "Do not show suspended instance on the global dashboard" has been toggled.
• Saving the display configuration now is redirecting to the main configuration page and it saves the changes on all base monitors.
• Display saved SNMP configuration on Notification Settings page and send SNMP notification.

Features

• You can now connect to Microsoft Azure Managed Instances and Azure SQL Databases using Azure Active Directory - Password authentication.
• The query history graph in top queries can now show the difference between the actual and estimated number of rows returned over time, and allows users to view historical actual plans.

Fixes

• Top Waits in Alert Details should no longer show an error when expanding a wait.
• Sampling issues fixed for the Linux machines those using comma as decimal separator.
• The left hand navigation on Alert Configurations should now load faster.
• Added server URL validation before connecting to SQL Monitor using PowerShell.
• Reports server summary tile now resizes to fit the available space.
• Fixed naming inconsistency between "Global overview" and "Global Dashboard" on the Cluster and AG overview pages.
• The left hand navigation now loads when viewing the AG overview page.
• Linux machine network sampling now disregards any files in the network directory.

Features

• On machine-level email alerts, the hosted SQL instances list now also shows instances tags.
• Added new Microsoft PowerShell cmdlet 'Get-SqlMonitorMonitoredObject'.
• Added support for adding PostgreSQL on Amazon RDS via PowerShell cmdlet.
• Added support for annotating PostgreSQL on Amazon RDS and Linux via PowerShell cmdlet.
• Improved handling of version mismatch between the PowerShell module and the SQL Monitor instance. Now it is required that both the PowerShell module and the SQL Monitor instance have the very same versions. For older versions of the PowerShell module running from PowerShell 5 it can manifest itself as The remote server returned an error: (417) Expectation Failed.

Fixes

• Fixed the issue regarding the named instance database file not being displayed on the Disk Details page.
• Adjusted the query used when sampling query wait stats to avoid a potential deadlock.
• Swap disk capacity is now sampled correctly on Linux hosts.
• Connection errors caused by the connection pool being exhausted are now reported as an Unreachable error rather that an internal monitoring error.
• Fixed an issue where filtering by machine name on the disks estate page would incorrectly include other machines on the same cluster.
• Updated the System.Security.Cryptography.Pkcs package to 7.0.2 to address a reported vulnerability. The vulnerability has a CVSS base score of 7.5 (High), but SQL Monitor's limited use of this library meant that it was not subject to the vulnerability.

Features

• You can now connect to Linux hosts securely using SSH public key authentication.
• Improved performance of the estate SQL Agent jobs page.

Fixes

• Fixed an issue where the data in the summary table in the estate disk usage page would sometimes not match the data in the disks table.
• Fixed an issue where no alert suppression targets would be available when creating a new alert suppression window.
• Fixed an issue with parsing non-standard PostgreSQL version strings.

Features

• High Transaction ID consumption alerts are now available for PostgreSQL.

Fixes

• Ensuring safeguards are in place to handle null Configuration Options when accessing the Alert Detail page for ConfigurationOptionChange alerts.
• Fixed the failures on alert suppression PowerShell APIs.
• Fixed an issue where PostgreSQL error logs would not be captured if the instance's logging directory was set to an absolute path.
• Fixed an issue where virtual machines in nested groups were not displayed on the estate licensing page.

Fixes

• Reduced RPC calls on Alert Configuration page to improve performance of the left hand navigation.
• Fixed issue where CPU % exceeds 100% for SQL user processes on the Server Overview page.
• Fixed issue where incorrect number of uncleared alerts was displayed on AG Overview page.
• Fixed issue where PowerShell API Get-SqlMonitorAlertSuppressionWindow returns incorrect StartDate in PowerShell 5 when the client's time zone is west of UTC.

Features

• Transaction ID consumption is now available in the PostgreSQL metric section of the Analysis page.
• Response compression has been enabled for self-hosted websites (Kestrel-based). For websites hosted on IIS it recommended to enable compression directly in IIS (both static and dynamic compression, incl. for application/JSON response types).
• Getting Base Monitors from the Microsoft PowerShell API will now return all configured Base Monitors rather than filtering to those that have been recently connected to.

Fixes

• Server Overview Databases dropdown no longer limited to the pagination limit.
• Query waits stats sampler no longer causes duplicate object name errors.
• The node and instance name for clusters are now correctly displayed on the Estate SQL Server Versions page.
• Correct monitoring error with some French versions of Windows.
• Long-running query report logic should now execute more efficiently.

Features

• Added 'Percentage of connections used' alert for PostgreSQL instances.
• The 'Microsoft SQL Server error log entry alert' has been extended to PostgreSQL and renamed to 'Database instance error log entry'.
• Added 'Top process' to overview page for PostgreSQL instances on Linux and Amazon RDS.
• Added Time selection dropdown for PostgreSQL Vacuum section.

Fixes

• Improved error message when top query search indexes are corrupted.
• SQL Server Failover Cluster Instances that have been uninstalled can now be removed from SQL Monitor via the monitored servers page.
• VMware hosts page renders as expected when host is taken offline.

Features

• The Microsoft PowerShell API now supports Microsoft SQL Server on Linux.
• Increased RSA key size to 4096 bits when generating a certificate that encrypts traffic between website and base monitors.
• Tags in dropdown filters are now sorted.

Fixes

• Fixed issue where "Availability group - replica not healthy" alert is raised incorrectly.
• Fixed Categories filter on Estate SQL Agent jobs page.
• Fixed missing "Disk I/O" to "Throughput" nomenclature change for Postgres instances on Server Overview.
• Fixed issue where custom metric collection could not be tested on non-primary base monitors.

Features

• Now includes a more descriptive file name (with a timestamp) in emails instead of AttachedReport.pdf.
• An error message will now display on the notification settings page when the password for the mail server cannot be decrypted.
• Replaced "Disk I/O" for "Throughput" on server overview for more clarity.
• The waits table is usually shown only in an expanded query in top queries, now it also shows in expanded queries in top waits. This applies to both the server overview and alert details pages.
• You now need to enforce usage of the Microsoft PowerShell module in the same version as that of the SQL Monitor website it connects to, to avoid errors caused by the mismatch.

Fixes

• Fixed regression where integrity check tries to use a legacy method (DBCC DBINFO) on Amazon RDS.
• Installation no longer fails when saved credentials in Windows Credential Manager have been manually edited.
• Custom metric page "Test metric collection..." will no longer fail when run on a non-primary base monitor.
• Graphs on the server overview page now link directly to analysis page metrics in more cases.

Features

• Changed time alerts for 'Database unavailable alerts' from approximately 10 minutes to 30 seconds.
• Added support for Amazon RDS instances behind a load balancer.
• Improved PostgreSQL top queries section to highlight missing configurations that are required to show query plans.
• Restructured Configuration page to make it easier to navigate.
• Rearranged Reports header UI to make it more intuitive and easier to use.
• Improved handling of unexpected 'end of stream' exceptions when connected to a PostgreSQL instance.

Fixes

• Fixed High CPU consumption when viewing Availability Groups Overview page.
• Editing credentials for a PostgreSQL instance hosted on Amazon RDS no longer fails if no API credentials were provided.
• Handle collation mismatch between default and master in SqlPerfCounter sampler.

Features

• Added a button to test PostgreSQL instance connections before adding them.
• Improved hashing algorithm to protect the four fixed-role accounts (Administrator, Standard user, Read-only user and Reporting user) in line with the latest OWASP guidance for FIPS-140 compliance.
• SQL Monitor now always uses Extended Events: it is no longer possible to disable them.

Fixes

• Fixed a regression where some visual elements was not rendered properly.

Features

• Webhook notifications now support the colon character in header values.

Fixes

• Fixed an issue where Azure SQL Databases would be in the "Awaiting License" state despite sufficient licenses being available.
• Manually-sent alert notification emails are no longer rate limited.
• Fixed an issue where Add-SqlMonitorAccessRights PowerShell cmdlet returns an error for Azure Managed Instances.
• Fixed an issue where database id not found issues were being reported while sampling database configuration options.

Features

• You can now obfuscate exception details when reporting errors in Microsoft SQL Server on Linux.