SQL Monitor Releases
Released: Mar 12, 2024
Updates in v13.0.57
Features
- Added support for aliasing PostgreSQL instances.
- Added an alert for replication lag for PostgreSQL instances.
- Connections graph on server overview now 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.
Released: Mar 5, 2024
Updates in v13.0.56
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.
Released: Feb 27, 2024
Updates in v13.0.55
Features
- Microsoft Azure Managed Instances can now be monitored using Microsoft Entra (formerly Azure Active Directory) Managed Identity authentication modes.
- Microsoft Powershell API for AlertSettings now supports 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...
Released: Feb 21, 2024
Updates in v13.0.54
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 Active Directory) Managed Identity authentication modes.
- You can now 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
- Fixed an issue where Microsoft Entra (formerly Azure AD...
Released: Feb 14, 2024
Updates in v13.0.53
Features
- Configuration change alerts are now available for PostgreSQL.
- You can now use job name instead of job ID when blocking process alerts.
- 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".
Fixes
- Configuration change alerts should now fire for SQL Server on Linux instances.
- Fixed an issue where the History tab auto-refresh function...
Released: Feb 7, 2024
Updates in v13.0.52
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 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.
Fixes
Released: Jan 30, 2024
Updates in v13.0.51
Features
- 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.
- Fixed Database file usage alert details not showing projected growth.
- Fixed SqlIndex sampling with reduced permissions on Azure Managed Instances.
Released: Jan 23, 2024
Updates in v13.0.49
Features
- 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.
Fixes
- Connection properties such as TrustServerCertificate and Encrypt can...
Released: Jan 16, 2024
Updates in v13.0.48
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.
- 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.
Fixes
- Long-running queries alert now ignores sessions in idle in transaction and idle in transaction (aborted...
Released: Jan 11, 2024
Updates in v13.0.47
Features
- Added CSV export to the 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...