Activity overview
Latest activity by Jon_H
SQL Monitor 12.0.14 has been released. Direct download link. Improvements
Provide option to remove requirement of db_owner permission on tempdb. See documentation here.
Adds a horizontal scroll bar to the left sidebar on the Alert settings page.
Display blocking processes tree on the Current Activity page.
Fixes An issue that could cause SQL Monitor to fail to reconnect to monitored servers after they are restarted has been fixed. / comments
SQL Monitor 12.0.14 has been released. Direct download link.Improvements
Provide option to remove requirement of db_owner permission on tempdb. See documentation here.
Adds a horizontal scroll bar...
SQL Monitor 12.0.8 has been released. Direct download link.
Fixes SRP-14041 Fix internal SQL Monitor error caused by access to the SQL Monitor repository using monitoring credentials
/ comments
SQL Monitor 12.0.8 has been released. Direct download link.
Fixes SRP-14041 Fix internal SQL Monitor error caused by access to the SQL Monitor repository using monitoring credentials
SQL Monitor 12.0.1 has been released. Direct download link.
Fixes
ZD-260627 Fix issue where SQL Monitor stops monitoring Azure Managed
Instances after an authorization error related to AG failover.
Fixed issue with export button in the Estate Configuration and Discovery pages for Amazon RDS and Azure Managed Instances.
Display more information for Azure Managed Instances and Amazon RDS
on their version and edition on the Estate Configuration page.
/ comments
SQL Monitor 12.0.1 has been released. Direct download link.
Fixes
ZD-260627 Fix issue where SQL Monitor stops monitoring Azure Managed
Instances after an authorization error related to AG failov...
Version 11.2.17 - October 7, 2021
Direct download link Improvements
Display query search folder size on data settings page
Show full query text on deadlock report
Fixes Fixed top queries search for Azure SQL Database for databases that have special or mixed case characters in their names
/ comments
Version 11.2.17 - October 7, 2021
Direct download linkImprovements
Display query search folder size on data settings page
Show full query text on deadlock report
Fixes Fixed top queries search ...
Version 11.2.4 - July 14, 2021 Direct download link Improvements
Time column in the error log section of the server overview page contains seconds.
Improved display of Key Lookups in query plans
Fixes Fixed an issue that caused incorrect blocking process to be shown on blocking process alert. / comments
Version 11.2.4 - July 14, 2021Direct download linkImprovements
Time column in the error log section of the server overview page contains seconds.
Improved display of Key Lookups in query plans
Fix...
Version 11.0.21 has been released Direct download link Features
Added PowerShell API support for Azure SQL Managed Instances, including alert settings configuration.
Additional SQL Server configuration options are displayed on the server overview. Configuration can be compared across different instances.
Improvements
Added spinners on the tempDB section that are displayed when the data is being loaded.
SRP-13629
changed the settings on database file usage alert to consider
autogrowth and maximum file size. Alerts that have been set to be
disabled when autogrowth is enabled will now start alerting if the
database has a maximum file size set.
Ignore the following waits: RESOURCE_GOVERNOR_IDLE , WAIT_XTP_OFFLINE_CKPT_NEW_LOG , PVS_PREALLOCATE , HADR_FABRIC_CALLBACK , PWAIT_EXTENSIBILITY_CLEANUP_TASK .
Fixes
Fix escaping error in SqlDatabaseFileSampler and SqlDatabaseStorageSampler
SRP-13610 The active directory API now accepts principal names in mixed case
SRP-13625 Fix regression of ignoring clock display settings in the Alerts Group Details page.
Z246544 Fix regression of not showing query text for blocking processes.
Resolves an issue with unreachable alerts being erroneously raised immediately after the base service is restarted.
Z244488 Improves reliability sampling SQL Server process utilization after a failover.
Version
11.0.19 contained a fix for a security vulnerability that affected
access control for non-administrator users when Active Directory
authentication is enabled. See https://www.red-gate.com/privacy-and-security/vulnerabilities/2021-02-24-sql-monitor for details.
SRP-13626 Reports will be generated when the website is not open.
/ comments
Version 11.0.21 has been releasedDirect download linkFeatures
Added PowerShell API support for Azure SQL Managed Instances, including alert settings configuration.
Additional SQL Server configurat...
SQL Monitor 10.2.9 has been released. Direct download link
Features
SRP-13285 - Added Version Store graph to tempdb
SRP-13395 - Added tempdb monitoring for Amazon RDS
Improvements
SRP-13360 - Query plan viewer has link to open it in new tab
SRP-13356 - Added SQL Text to tempdb sessions table
Fixes
SRP-13247 - SQL Monitor now picks up query plan changes even when an existing plan handle is reused.
SRP-13384 - Installer will once again automatically populate credentials for SQL Auth when updating
SRP-13411 - Resolves an issue with "Monitoring Error" on server in SqlProcessSampler
SRP-13374 - Fixes inability to launch a base monitor due to duplicated alert at a target
SRP-13307 - Ignore database in transition state as a monitoring error
SRP-13387 - Fixed errors caused by the integrity check sampler running against snapshots of offline databases
Zendesk 169089 - Resolves an issue with "configure alert" link on alert email not working
SRP-13409 - Fixes error on startup when the service account does not have permission to access process start time
SRP-13388 - Alert Suppression Windows resolve base api url correctly when SQL Monitor Web not at server root
SRP-13404 - Fixes an error in the installer: Problem connecting to SQL Monitor repository data store
Changes
Multiple base monitor installs no longer require Active Directory
(AD) settings to be replicated on secondary base monitors to correctly
resolve authorized entities. All AD operations are performed on
/ comments
SQL Monitor 10.2.9 has been released. Direct download link
Features
SRP-13285 - Added Version Store graph to tempdb
SRP-13395 - Added tempdb monitoring for Amazon RDS
Improvements
SRP-13360 - Q...
SQL Monitor 10.0.9 has been released. Direct download link
Drops SSL3 and TLS 1.0 support for communication between the base monitor and website. Communication between the base monitor and website will now use TLS 1.2 or TLS 1.1 as available. Features SRP-12841 Filtering version filter as version and edition in SQL Server Licensing page
Fixes
SRP-12935 The alert inbox now retains use of the next and last alert arrows if the "Configure Alerts" link is used
SRP-12925 It is now possible to enter thresholds over 100% for the job duration unusual alert
SRP-12937 Prevent job duration unusual alert being raised due to improperly terminated SQL Agent sessions
SRP-12673 Test and Add will both resolve cluster names using the same mechanism
SRP-12422 Fix casing issue in database name when raising backup overdue alerts for availability group databases
SRP-12159 SQL Monitor will now report "Cannot connect" and raise an alert if the wrong port number is provided for a SQL instance
/ comments
SQL Monitor 10.0.9 has been released. Direct download link
Drops SSL3 and TLS 1.0 support for communication between the base monitor and website. Communication between the base monitor and website ...
SQL Monitor 10.0.7 has been released. Direct download link
Features
SRP-12886 WinRM connections now support HTTP
SRP-12787 Improve webhook diagnostic response
Fixes SRP-12872 SQL Server licensing now uses logical processors instead of number of cores for virtual machines / comments
SQL Monitor 10.0.7 has been released. Direct download link
Features
SRP-12886 WinRM connections now support HTTP
SRP-12787 Improve webhook diagnostic response
FixesSRP-12872 SQL Server licensing n...
SQL Monitor 10.0.4 has been released. Direct download link
Features
SRP-12852 Added WMIType parameter option for Add-SqlMonitorMonitoredObject cmdlet.
SRP-12723 Job Duration Unusal alert now triggers on currently running alerts instead of only on finished alerts
New SQL Server licensing page added
Fixes SRP-12861 Fixes mapping of "Day" property when creating alert suppression windows through PowerShell API / comments
SQL Monitor 10.0.4 has been released. Direct download link
Features
SRP-12852 Added WMIType parameter option for Add-SqlMonitorMonitoredObject cmdlet.
SRP-12723 Job Duration Unusal alert now trigg...