SQL Monitor 13

SQL Monitor 13.0 Release Notes

When should I upgrade?

  • We aim to release a build every week that includes the latest incremental features and bug fixes. These builds are identified by a three-part version number (e.g. v13.1.2). See below for details of improvements and fixes for each release.
  • If you want to wait until all aspects of a feature have been fully completed it’s best to use a minor version release, identified by a two-part version number (e.g. v13.3).
  • Major releases (e.g. v13) combine multiple feature releases and undergo additional QA. Bug fixes are prioritised following a major release.

Version 13.0.61 - April 4, 2024

Fixes

  • Alert configuration changes no longer fail to save.

Version 13.0.60 - April 2, 2024

Improvements

  • The Virtual Instance Name of a SQL Server Failover Cluster Instance can now be retrieved through the PowerShell API.

Fixes

  • Fixed internal server error being shown when trying to view certain Alert Details.

  • The configuration option to raise Job Failing alerts on jobs that succeed with one or more failing steps no longer causes job failing alerts to remain active after a fully successful job run

Version 13.0.59 - March 26, 2024

Features

  • Added excessive planning time recommendation for PostgreSQL.

Fixes

  • Fixed an issue where editing the credentials of an Azure SQL Server or Azure Managed Instance was not correctly displaying the User-assigned Managed Identity option

  • Fixed an issue where PostgreSQL user process information couldn't be sampled when queries were truncated by PostgreSQL.
  • Fixed a validation issue when adding an instance using Microsoft Entra authentication where system assigned managed identities could be given a client ID which they do not use.

Version 13.0.58 - March 19, 2024

Improvements

  • Modernized the System Processes grid in alert details.
  • Changed the counter sampled for the Guest CPU ready time VMware metric to a more appropriate one. This should slightly improve the accuracy of the metric.

Fixes

  • Fixed an issue where configured webhook notifications were not being sent when an alert ends.
  • Fixed an issue where PostgreSQL recommendations would sometimes fail to load on IIS-based installations.
  • Fixed an issue that prevented provisioned PostgreSQL Aurora instances from being monitored correctly

Changes

  • The text "SQL Monitor" has been changed to "Redgate Monitor" in many places, in preparation for the next major release of the product.

Version 13.0.57 - March 12, 2024

Features

  • Added support for aliasing PostgreSQL instances.
  • Added an alert for replication lag for PostgreSQL instances.

Improvements

  • Connections graph on server overview shows combined number of idle and active connections
  • The PowerShell API now supports the AlertOnStepFailure property of the SqlJobFailing alert.

Fixes

  • Fixed an issue where PostgreSQL long running transaction alerts were firing incorrectly.
  • Fixed an issue where Deadlock reports were not being displayed.

Version 13.0.56 - March 5, 2024

Features

  • Daily custom metrics can now be scheduled for specific times of day.
  • Added a link to the the query plan viewer in PostgreSQL recommendations modal.

Fixes

  • Fixed an issue rendering top query recommendations within the PostgreSQL alert details page.
  • Fixed an issue where some alerts would fire again after a Base Monitor restart.
  • Viewing top queries within a top procedure now supports procedures with multiple special characters in their name.
  • Fixed an issue where custom metrics could be tested against Azure SQL Databases that weren't being monitored.
  • Fixed an issue that was preventing the configuration change alert details page from being displayed for PostgreSQL in some cases.

Version 13.0.55 - February 27, 2024

Features

  • Azure Managed Instances can now be monitored using Microsoft Entra (formerly Azure AD) Managed Identity authentication modes.

Improvements

  • Powershell API for AlertSettings now support PostgreSql instances.

  • Job failing alerts can now be raised when any individual job step fails, even if the overall job succeeds.

Fixes

  • Fixed a bug where permissions for a group containing a Linux machine with multiple PostgreSQL instances would only apply to the default instance.
  • Current activity no longer shows incorrect durations of sessions running for longer than 30 minutes.

Version 13.0.54 - February 21, 2024

Features

  • Introduced "Long-running transaction" and "Long-running idle transaction" alerts for PostgreSQL instances.
  • Azure SQL Databases can now be monitored using Microsoft Entra (formerly Azure AD) Managed Identity authentication modes.

Improvements

  • Use job name instead of job id in the names of processes involved in deadlock alerts.
  • The analysis page now includes I/O throughput metrics for machines and databases.

Fixes

  • Certain alerts no longer fail to be raised if configuration change alerts have been customized.
  • Fixed an issue where Microsoft Entra (formerly Azure AD) Integrated authentication was not working correctly.
  • Downloading deadlock XDLs from alert details page no longer fails in certain circumstances.
  • Fixed Top Query search returning no results for Azure Sql Server.
  • Volume labels are now correctly sampled for logical disks that are mounted in a folder, rather than a dedicated drive letter.

Version 13.0.53 - February 14, 2024

Features

  • Configuration change alerts are now available for PostgreSQL.

Improvements

  • Calculate median of jobs duration for the job duration unusual alert using timings from successful jobs only.
  • Use job name instead of job id in the names of processes involved in blocking process alerts.

Fixes

  • Configuration change alerts should now fire for SQL Server on Linux instances
  • Fixed an issue where the History tab auto-refresh function was not paused while certain modals are open.
  • Fixed an issue where actual query plan retention settings were not updated properly when the retention settings were changed.
  • Fixed suspending standalone servers via Powershell
  • Fixed an issue where the server overview page top graph was not rendered correctly when resizing.

Changes

  • Microsoft Entra ID is the new name for Azure Active Directory. Where SQL Monitor UI refers to Azure AD, a note of the rename has been added.
  • Configuration change alerts can now be found under "Instance alerts"

Version 13.0.52 - February 7, 2024

Features

  • Recommendations can now be viewed in the query plan viewer for PostgreSQL.
  • Added inaccurate statistics recommendation for PostgreSQL Top Queries in the server overview page.
  • Added option to send webhook notification for "All Levels", "High and Medium" or "High Only" alerts.

Improvements

  • Failing alerts can now be raised even when a job succeeds, if it has one or more failing steps.
  • Get-SqlMonitorAvailabilityGroup` cmdlet now returns listener information for each Availability Group.

Fixes

  • Fixed data compression showing as enabled even when it is disabled on the data retention settings page.
  • Replace warning with information when PostgreSQL query plan isn't available
  • Added default fallback values for QueryWaitStats and ServerWaitStats sampler settings.
  • Fix Sparklines showing "Loading" and "No Data" simultaneously
  • PDF reports no longer show the SQL Monitor logo outside the header. This caused some reports to use more pages than expected.

Version 13.0.51 - January 30, 2024

Improvements

  • Added temp_blocks_read, temp_blocks_written and block_size values to PostgreSQL spill occurred recommendation.
  • Added an interactive help dialog explaining regular expressions on various Alert configuration pages.

Fixes

  • Server Overview will show Availability Groups section again
  • Fix Database file usage alert details not showing projected growth.
  • Fix SqlIndex sampling with reduced permissions on Azure Managed Instances.

Version 13.0.49 - January 23, 2024

Features

  • IgnoreSecondary` can now be set for Job failed and Job cancelled alerts from the PowerShell API to control whether secondary nodes should be ignored.

Improvements

  • Updated PostgreSQL spill to disk recommendation to display work_mem and temp_buffers values.
  • Login database definition is improved while adding PostgreSQL instances for monitoring.
  • The DISCARD ALL PostgreSQL query is no longer shown in the top queries view.

Fixes

  • Connection properties such as TrustServerCertificate and Encrypt can now be configured on Azure SQL Database.
  • Reports exported as PDF no longer show tiles for the incorrect report.
  • CPU utilization alert emails will no longer display an incorrect list of SQL server instances for the hosted machine.

Version 13.0.48 - January 16, 2024

Features

  • Added spill to disk query recommendation for PostgreSQL Top Queries in the server overview page.
  • Added a graph to the index details sidebar that shows the usage of an index over the last month.

Improvements

  • Process state field is now displayed on Long-running queries alert detail for PostgreSQL instances.
  • Improved terminology when adding an Amazon RDS or Aurora cluster to monitored servers. Removed BETA tag from this feature.

Fixes

  • Long-running queries alert now ignores sessions in idle in transaction and idle in transaction (aborted) states for PostgreSQL instances.

Version 13.0.47 - January 11, 2024

Features

  • Added CSV export to main indexes table.

Fixes

  • Fixed Powershell cmdlets New-SqlMonitorPrincipal, Update-SqlMonitorPrincipal, Get-SqlMonitorPrincipal to work with the pattern "domain\username" or "domain\group"
  • Fixed secondary base monitor not reconnecting after having lost socket connection.
  • Indexes sampling is now resilient to database-specific issues such as some databases being unavailable.
  • Line breaks within SQL fragments are now rendered correctly on alert details pages.
  • Blocking process alerts should no longer be raised against all databases in elastic pool.

Version 13.0.46 - January 3, 2024

Improvements

  • Improve tabular view for Aurora cluster nodes. It now includes Location and Size.
  • Slightly improved behaviour of the Authentication settings configuration page.

Fixes

  • Fixes PostgreSQL top query search indexing.
  • Fix ElasticPool worker exhaustion. Increase ExtendedEvents collection interval.
  • Fixes SuppressDeprecationWarning parameter error with the Powershell cmdlet Get-SqlMonitorDatabase.

Version 13.0.45 - December 20, 2023

Improvements

  • Improve error handling for PostgreSQL SSL handshake.

Fixes

  • Properties filter on Alert Inbox now also works when only some properties are selected.
  • Speculative fix for worker threads being consumed by extended events by allowing multiple events to be lost under heavy load.
  • Last used property on the indexes table now correctly shows the last used date after a SQL Server restart.
  • Fix SQL Server Licensing Estate page chart headers.
  • Improved memory usage for indexes sampling for indexes with partitioning.

Changes

  • rdsadmin databases will no longer be sampled for index information.

Version 13.0.44 - December 12, 2023

Improvements

  • Multiple PostgreSQL database instances can be monitored on the same Linux machine.
  • More consistently show execution plans for PostgreSQL queries.
  • Switching servers using the dropdown in the server overview will now open the new server on the same tab (
    History/Current activity/Indexes) that was open on the previous server.

Fixes

  • Various resource unavailable alerts (such as database unavailable) will now remain active after a Base Monitor restart if the resource remains unavailable. Previously these alerts would have ended and a new alert raised once the threshold for alerting was reached.
  • Users with limited access will no longer see names of servers they don't have access to on the "Monitored servers" page.
  • Database unavailable alert will no longer be raised for mirrored databases.
  • Correctly use DnsName when detecting instances of a cluster that has a distributed network name set-up. The detection is performed when adding a new cluster to SQL Monitor.
  • Index sampling will now work for databases with names containing Unicode characters.
  • Index sampling will now correctly skip sampling from databases that are not online.

Version 13.0.43 - December 6, 2023

Features

  • Added Top Query Search functionality for PostgreSQL.

Improvements

  • Show autovacuum recommendations for PostgreSQL versions 15 and 16.

Fixes

  • Various resource unavailable alerts (such as database unavailable) will now remain active after a Base Monitor restart if the resource remains unavailable. Previously these alerts would have ended and a new alert raised once the threshold for alerting was reached.
  • Users with limited access will no longer see names of servers they don't have access to on the "Monitored servers" page.

Changes

Version 13.0.42 - November 28, 2023

Features

  • Server overview for PostgreSQL instances now display configuration options.

Improvements

  • Table rows in the index tab now show more details when clicked.
  • SQL Monitor now excludes indexes under system and internal tables from sampling. This will make it easier to focus on indexes that are more likely to be useful for performance tuning.

Fixes

  • Fixed an issue where the 'Finish' button is not correctly enabled in the base monitor service installer.
  • Clicking an annotation on the server overview page now correctly navigates to the annotation's URL if present.
  • Fixed an issue where the Base Monitor stored an excessive number of samples of a Linux Machine's OS properties, due to minor timing variations in the way the boot up start time was being sampled.
  • Excel exports no longer fail when data is in an expected format.
  • Fixed issues around the display of Aurora PostgreSQL cluster node metrics.
  • Fixed an issue that would cause the first-time configuration page to fail to load when installing the website without a Base Monitor.

Version 13.0.41 - November 21, 2023

Improvements

  • Added extra metrics to the Aurora Cluster Nodes section.
  • Indexes table now supports column management and remembers your filter preferences.

Fixes

  • Update-SqlMonitorMonitoredObject` cmdlet no longer rejects SQL Server on Linux instances and allows updating the group of Azure SQL Servers and clusters.
  • The base monitor no longer puts all monitored servers into a monitoring error state that can only be resolved by restarting the service.

Version 13.0.40 - November 15, 2023

Improvements

  • Added support for detecting Failover Cluster Instances and Availability Group listeners that are configured to use a distributed network name.
  • Connecting to a SQL Server Failover Cluster Instance now uses the MultiSubnetFailover connection string parameter to improve performance.

Fixes

  • Fixed an issue where Disk usage details Estate page fails to load for Linux hosts.
  • Fixed an issue with sampling SQL Databases.

Version 13.0.39 - November 9, 2023

Improvements

  • The Backups Estate page now includes Azure SQL Databases.

Fixes

  • Fixed an issue where Database File Usage alerts were not being displayed correctly in Alert Inbox.
  • The date range shown on the top of the indexes tab now correctly reflects returned data.
  • The time period dropdown on the indexes tab now opens consistently.
  • Fixed an issue with precision on Server overview CPU mini chart.

Version 13.0.38 - November 8, 2023

Features

  • SQL Server index information is now available in the form of a new tab in the server overview.

Improvements

  • The database file usage alert configuration page now has an updated appearance when configuring at the database level.
  • Octopus" can now be specified as the source of an annotation through the PowerShell api.

Fixes

  • Database unavailable alerts are now raised for databases in the restoring state.

Version 13.0.37 - October 31, 2023

Features

  • The Backups Estate page now includes SQL Server on Linux, Azure Managed Instances and Amazon RDS SQL Servers.

Improvements

  • Add Aurora cluster nodes section in server overview.
  • The Get-SqlMonitorMonitoredObject PowerShell cmdlet now allows the specification of a parent object or group.

Fixes

  • Fixes an issue with timezones when monitoring Linux machines.
  • You can now easily customize custom alerts within subgroups.
  • Fixes adding and editing Azure SQL Databases on non-primary base monitors.

Version 13.0.36 - October 24, 2023

Security fixes

  • CVE-2023-36414 Updated the Azure.Identity package to 1.10.3 to address a reported vulnerability. The vulnerability has a CVSS base score of 8.8 (High), but SQL Monitor's limited use of this library meant that it was not subject to the vulnerability. See https://security.snyk.io/vuln/SNYK-DOTNET-AZUREIDENTITY-6009155 for more details.

Features

  • The SQL Server configuration Estate page now includes Azure SQL Databases.
  • The Disk usage Estate page now includes SQL Server on Linux, and Amazon RDS SQL Servers.

Improvements

  • The Test button when adding a Azure SQL server will only verify the connection to the server, not the databases.
  • Add support for AuroraCluster in Powershell.

Fixes

  • Fixes the filters on the SQL Agent jobs Estate page so that the data updates correctly.
  • Fixed InvalidOperationException when PostgreSQL processes PercentageCpuUsed is empty.
  • Alert summary report tiles that use an unlimited row count now display correctly.
  • Fixes the replication overview and left panel to not display replication when the instance is Aurora PostgreSQL.
  • No longer show in-trial or trial expired banner messages when monitored servers are actually licensed.
  • Fixes issue where getting MonitoredObject for PostgreSQL from Powershell returned object with some empty value.

Version 13.0.35 - October 17, 2023

Features

  • SQL Monitor now supports monitoring PostgreSQL v16 instances.

Improvements

  • Updated the Powershell API to support Log File for Configuration of DatabaseFileUsageAlerts.
  • Added "End of extended support" column to the Estate SQL Server Versions page table.

Fixes

  • Authorization for alert groups no longer fails for alerts on non-primary Base Monitors.
  • Updated documentation for the Get-SqlMonitorMonitoredObject cmdlet's Type parameter and its permitted values.

Version 13.0.34 - October 12, 2023

Fixes

  • Add Monitored Server button on Server Overview Replication for Postgres instances no longer fails to redirect and will pre fill the machine name.

  • Adding new monitored servers will now correctly respect the selected Base Monitor.

Version 13.0.33 - October 11, 2023

Features

  • It is now possible to configure Storage alerts on Elastic pools.
  • SQL Server licensing Estate page now include SQL Server on Linux servers.

Improvements

  • Execution plans now include additional information made available by recent versions of SQL Server, including details of newly-introduced operators, as well as richer data and warnings when viewing runtime (actual) query execution plans.
  • In the Monitored Servers configuration page you can now manage servers across multiple Base Monitors.
  • Update database file usage alert configuration to allow users to alert on different system databases and to enable alerting on log files with its own configuration.

Fixes

  • Alert report tile previews no longer show as blank.
  • Fixed an issue accessing machine status for Linux machines from PowerShell.
  • Fixed sampling for Linux Machine Physical processors on Ubuntu version 22.04
  • Fixed an issue with Top Queries Indexing failing when certain characters were present in database names
  • Reduced server overhead of Top Queries recommendations.
  • Monitored servers no longer fails to load for non-admin users.
  • Fixes sampling of CPU metrics for Amazon Aurora instances.

API changes

  • The AutoDetectClusterName parameter of the New-SqlMonitorWindowsHost cmdlet now defaults to true.

Version 13.0.32 - October 6, 2023

Fixes

  • Fixed an issue accessing machine status for Linux machines from PowerShell.
  • Fixed an issue where the Database File Usage alert was raised unexpectedly for databases with autogrowth enabled.

Version 13.0.31 - October 4, 2023

Features

  • A PowerShell script can now be run as an alert response. See the documentation for more information.

Improvements

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

Version 13.0.30 - October 3, 2023

Improvements

  • Now you can 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).

Version 13.0.29 - September 27, 2023

Improvements

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

Version 13.0.28 - September 19, 2023

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.

Version 13.0.27 - September 14, 2023

Features

  • Added beta support for Amazon Aurora PostgreSQL instance monitoring.

Improvements

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

Version 13.0.26 - September 12, 2023

Features

  • SQL Server versions page now supports SQL Server on Linux, Azure Managed Instances and Amazon RDS SQL Servers.

Fixes

  • Improve sampling data for databases with non-English characters in their names.

API changes

  • Added the following PowerShell cmdlets to support both OIDC (OpenID Connect) and AD (Active Directory) access management: Get-SqlMonitorPrincipal, New-SqlMonitorPrincipal, Update-SqlMonitorPrincipal, Remove-SqlMonitorPrincipal.
  • Added OIDC (OpenID Connect) support for following PowerShell cmdlets: Add-SqlMonitorAccessRights, Remove-SqlMonitorAccessRights, Test-SqlMonitorGroupAccess, Test-SqlMonitorMonitoredObjectAccess.

Version 13.0.25 - September 5, 2023

Features

  • SQL Server configuration page now supports SQL Server on Linux.
  • SQL Agent jobs page now supports SQL Server on Linux, 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.

Version 13.0.24 - August 29, 2023

Improvements

  • The Powershell API now supports selecting which Azure SQL Databases to monitor.
  • The WAL size graph now includes a max WAL size metric line for PostgreSQL outgoing replication.

Fixes

  • Fixed an issue with sampling from a read-only PostgreSQL instance (code 25006).

API changes

  • Some PowerShell cmdlets are now singularized to follow Microsoft guidelines. The old names were 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, Remove-SqlMonitorTags.
  • Fixed usage of Get-SqlMonitorMonitoredObject for Postgres instances hosted on Amazon RDS.

Version 13.0.23 - August 22, 2023

Features

  • Recommendations based on actual plan warnings (e.g. spill to tempdb) are now available on servers / databases where actual plan collection is enabled.

Fixes

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

Changes

  • Re-enabled top queries recommendations indicator.

Version 13.0.22 - August 16, 2023

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 not being sorted correctly. Introduced in version 13.0.21.

Version 13.0.21 - August 15, 2023

Security fixes

  • CVE-2023-38180 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 select which Azure SQL Databases to monitor.

Improvements

  • You can now use an account without the db_owner role for the data repository of the base monitor. See the documentation for details.
  • You can now edit connection properties for monitored Azure SQL Databases.

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.

Changes

  • The impact view of top queries and top procedures now shows the columns contributing to the impact calculation.

Version 13.0.20 - August 9, 2023

Improvements

  • You can now see the UTC offset in Summary title for Excel reports exported from the Estate pages.
  • Added incoming replication charts for PostgreSQL monitoring.

API changes

  • PowerShell API now supports passing a combination of objects constructed using New-SqlMonitorWindowsHost and New-SqlMonitorSqlServer cmdlets to the Add-SqlMonitorMonitoredObject cmdlet.

Version 13.0.19 - August 3, 2023

Fixes

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

Changes

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

Version 13.0.18 - August 1, 2023

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.

Version 13.0.17 - July 26, 2023

Security fixes

  • CVE-2022-47870 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.

Improvements

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

Version 13.0.16 - July 19, 2023

Improvements

  • You can now use private endpoints for SQL servers and PostgreSQL servers hosted on Amazon RDS.

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.

API changes

  • Renamed Get-SqlMonitorSshPrivateKeys PowerShell cmdlet to Get-SqlMonitorSshPrivateKey and added a -Name parameter to allow filtering by name.

Version 13.0.15 - July 17, 2023

Features

  • You can now connect to 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.

Improvements

  • Latest actual plan can now be viewed from inside the query recommendations dialog.

Fixes

  • Fix 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.
  • Fix suspend/resume of multiple Linux Machines so that all children are also suspended/resumed.
  • Fix 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.

API changes

  • Suspension and unsuspension of Azure Managed Instances and Amazon RDS SQL Servers is now possible through the Update-SqlMonitorMonitoredObjectSuspendedStatus cmdlet.

Version 13.0.14 - July 5, 2023

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.

Version 13.0.13 - June 28, 2023

Features

  • You can now connect to 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.

Version 13.0.12 - June 16, 2023

Security fixes

Improvements

  • On machine-level email alerts, the hosted SQL instances list now also shows those instances tags.
  • Added new PowerShell cmdlet Get-SqlMonitorMonitoredObject.
  • Added support for adding PostgreSQL on Amazon RDS via PowerShell Add-SqlMonitorMonitoredObject cmdlet.
  • Added support for annotating PostgreSQL on Amazon RDS and Linux via PowerShell Add-SqlMonitorAnnotation cmdlet.

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.

API changes

  • 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. See documentation on downloading the PowerShell module to learn how to automate.

Version 13.0.11 - June 7, 2023

Features

  • You can now connect to Linux hosts securely using SSH public key authentication.

Improvements

  • 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

Version 13.0.10 - June 1, 2023

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

Version 13.0.9 - May 24, 2023

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.

Version 13.0.8 - May 17, 2023

Features

  • Transaction ID consumption is now available in the PostgreSQL metric section of the Analysis page.

Improvements

  • Response compression was enabled for self-hosted websites (Kestrel-based). For websites hosted on IIS we recommend enabling compression directly in IIS (both static and dynamic compression, incl. for application/json response types).

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.

Changes

  • Getting Base Monitors from the PowerShell API will now return all configured Base Monitors rather than filtering to those that have been recently connected to.

Version 13.0.7 - May 10, 2023

Features

  • Added Percentage of connections used alert for PostgreSQL instances.
  • The SQL Server error log entry alert has been extended to PostgreSQL and renamed to "Database instance error log entry".

Improvements

  • Added Top process section in overview pages 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.

Version 13.0.6 - April 26, 2023

Features

  • PowerShell API now supports SQL Server on Linux.

Improvements

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

Version 13.0.5 - April 19, 2023

Improvements

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

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.

Changes

  • The waits table usually shown only in an expanded query in top queries now also shows in expanded queries in
    top waits. This applies to both the server overview and alert details pages

API changes

  • Enforce usage of the PowerShell module in the same version as SQL Monitor website it connects to, to avoid errors caused by the mismatch.

Version 13.0.4 - April 13, 2023

Improvements

  • Improved the time to alert of Database unavailable alerts from approximately 10 minutes to 30 seconds.
  • Added support for Amazon RDS instances behind a load balancer.
  • Improved the PostgreSQL top queries section to highlight missing configurations that are required to show query plans.

Fixes

  • Improved handling of unexpected end of stream exceptions when connected to a PostgreSQL instance.
  • 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.

Changes

  • Restructured Configuration page to make it easier to navigate.
  • Rearranged the Reports header UI to make it more intuitive and easier to use.

Version 13.0.3 - April 5, 2023

Improvements

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

Fixes

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

Changes

  • SQL Monitor now always uses Extended Events: it's no longer possible to disable them.

Version 13.0.2 - March 29, 2023

Improvements

ZD-288784: 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.

Version 13.0.1 - March 23, 2023

Improvements

  • Obfuscate exception details when reporting SQL Server on Linux errors

Version 13.0.0 - March 21, 2023

Major changes

  • Introducing support for PostgreSQL: SQL Monitor users can now add and monitor PostgreSQL instances hosted on Linux or Amazon RDS.
  • Monitoring SQL Server on Linux instances is now out of preview.
  • New global dashboard card design, including detail to help identify the database platform and availability group structure.
  • Credentials stored by SQL Monitor now use AES encryption. The encryption keys are now stored in the encryption keys file in the new Secrets folder in %ProgramData%\Red Gate\SQL Monitor. See Managing the encryption keys file for details including recommendations on backing up and securing access to this file.

Fixes

  • Modifying alert settings at the base monitor and group level via PowerShell should no longer throw type errors.
  • Databases on the server overview page can now be sorted across multiple pages.
  • Encountering an exception while loading the monitored servers page should no longer result in an indefinite loading period.

Changes

  • Windows 7 SP1+ and Windows 8 (including 8.1) and Windows Vista are no longer supported for monitoring or installation of SQL Monitor. Support for older versions of Windows Server is unchanged.

API changes

  • Passing specific parameters to Add-SqlMonitorMonitoredObject is now deprecated and will be removed in a future version of SQL Monitor. As per examples, construct new objects using helper cmdlets (i.e. New-SqlMonitorWindowsHost, New-SqlMonitorLinuxHost, New-SqlMonitorSqlServer, New-SqlMonitorPostgreSql etc.) and pass constructed objects to Add-SqlMonitorMonitoredObject instead.
  • The alias is now part of the structure returned when getting a Windows SQL Server instance, an Azure MI, Amazon RDS instance, SQL Server on Linux instance, or an Azure SQL Server database.
  • Aliases can now be updated using the new Update-SqlMonitorMonitoredObject cmdlet.

Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com


Didn't find what you were looking for?