Redgate Monitor 新版本發表

Released: Feb 7, 2024

v13.0.52 中的更新

特性

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

修補程式

  • Fixed data...

Released: Jan 30, 2024

v13.0.51 中的更新

特性

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

修補程式

  • 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

v13.0.49 中的更新

特性

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

修補程式

  • Connection properties such as TrustServerCertificate and Encrypt can now be...

Released: Jan 16, 2024

v13.0.48 中的更新

特性

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

修補程式

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

Released: Jan 11, 2024

v13.0.47 中的更新

特性

  • Added CSV export to the main indexes table.

修補程式

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

Released: Jan 3, 2024

v13.0.46 中的更新

特性

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

修補程式

  • 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

v13.0.45 中的更新

特性

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

修補程式

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

Released: Dec 12, 2023

v13.0.44 中的更新

特性

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

修補程式

  • 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

v13.0.43 中的更新

特性

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

修補程式

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

Released: Nov 28, 2023

v13.0.42 中的更新

特性

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

修補程式

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