Released: Oct 4, 2023

Updates in v13.0.31

Features

• A Microsoft PowerShell script can now be run as an alert response.
• Updated the design of the server overview pages to improve contrast and readability.

Fixes

• Fixed an issue where Auto Shrink property was not being displayed correctly on server overview page for Azure SQL Databases.

Released: Oct 3, 2023

Updates in v13.0.30

Features

• You can now set to always redact query plan parameters, even for administrators, by setting the SQLMONITOR_AlwaysRedactQueryPlanParameters environment variable on the Website to true.

Fixes

• Fixed an issue where a PostgreSQL server overview page could fail to render (Highcharts error #14).

Released: Sep 27, 2023

Updates in v13.0.29

Features

• Up-to-date software bill of materials (SBOM) is now available to download from the Configuration -> About -> Configuration Information page.

Fixes

• Fixed an issue of Postgres query history not loading when monitor installed on IIS.
• Error messages are now correctly displayed when attempting to add a Postgres instance on AmazonRDS with missing API credentials.
• Fixed an issue where Azure Managed Instance version was displayed incorrectly on Versions Estate page.

Released: Sep 19, 2023

Updates in v13.0.28

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...

Released: Sep 14, 2023

Updates in v13.0.27

Features

• 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.

Released: Sep 12, 2023

Updates in v13.0.26

Features

• 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...

Released: Sep 5, 2023

Updates in v13.0.25

Features

• 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...

Released: Aug 29, 2023

Updates in v13.0.24

Features

• 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...

Released: Aug 22, 2023

Updates in v13.0.23

Features

• 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.

Released: Aug 16, 2023

Updates in v13.0.22

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.