Released: Feb 7, 2024

Atualizações na v13.0.52

Recursos

• 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 the option to send webhook notification for "All Levels", "High and Medium" or "High Only" alerts.
• 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.

Correções...

Released: Jan 30, 2024

Atualizações na v13.0.51

Recursos

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

Correções

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

Released: Jan 23, 2024

Atualizações na v13.0.49

Recursos

• IgnoreSecondary can now be set for 'Job failed' and 'Job canceled' alerts from the PowerShell API to control whether secondary nodes should be ignored.
• Updated PostgreSQL spill to disk recommendation to display work_mem and temp_buffers values.
• Login database definition has been improved while adding PostgreSQL instances for monitoring.
• The DISCARD ALL PostgreSQL query is no longer shown in the top queries view.

Correções

• Connection properties such as TrustServerCertificate and Encrypt...

Released: Jan 16, 2024

Atualizações na v13.0.48

Recursos

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

Correções

• Long-running queries alert now ignores sessions in idle in transaction and idle in transaction...

Released: Jan 11, 2024

Atualizações na v13.0.47

Recursos

• Added CSV export to the main indexes table.

Correções

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

Released: Jan 3, 2024

Atualizações na v13.0.46

Recursos

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

Correções

• Fixed PostgreSQL top query search indexing.
• Fixed ElasticPool worker exhaustion, by increasing ExtendedEvents collection interval.
• Fixed SuppressDeprecationWarning parameter error with the PowerShell cmdlet Get-SqlMonitorDatabase.

Released: Dec 20, 2023

Atualizações na v13.0.45

Recursos

• Improved error handling for PostgreSQL SSL handshake.
• rdsadmin databases will no longer be sampled for index information.

Correções

• 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.
• Fixed SQL Server Licensing Estate page...

Released: Dec 12, 2023

Atualizações na v13.0.44

Recursos

• Multiple PostgreSQL database instances can now be monitored on the same Linux machine.
• Improved consistency when showing 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.

Correções

• Various resource unavailable alerts (such as database unavailable) will now remain active after a Base Monitor restart if the resource remains...

Released: Dec 6, 2023

Atualizações na v13.0.43

Recursos

• Added Top Query Search functionality for PostgreSQL.
• Now shows autovacuum recommendations for PostgreSQL versions 15 and 16.
• Disabled index sampling by default due to concerns about high memory use.

Correções

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

Released: Nov 28, 2023

Atualizações na v13.0.42

Recursos

• Server overview for PostgreSQL instances now display configuration options.
• 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.

Correções

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