SRP-13143 Job duration unusual alert can now be excluded based on job owner
Fixes
SRP-13121 Low CSV space alerts and notifications now show the volume label of the affected CSV
SRP-13099 Web pages that aggregate information from multiple base monitors no longer fail with an internal server error when any base monitor is unhealthy.
Fixes a memory leak on the website when calling API endpoints
SRP-13170 Improved performance and error handling when collecting custom metrics
SRP-13161 Fixed minor cosmetic issues mostly related to spacing
SRP-13168 Fixed failure to display query plans when accessed through the top queries-query history links
SRP-13172 Fix webhook custom HTTP headers for IE11
SRP-12296 Query text for SQL User Processes is now available by selecting a process on the server overview
Fixes
SRP-13108 Delays database backup overdue alerts being raised to allow for availability group DMVs to be initialized
SRP-13086 Handle monitoring errors raised when a database becomes unavailable that were previously putting the monitored server into a stopped monitoring state.
Resolves an issue during base monitor startup when the data repository is not available
Eliminated some monitoring queries when it's known up-front that they won't return any monitoring data.
Reduced the impact of high-latency base monitors on the overall latency of the website when using multiple base monitors.
Fixes
SRP-13190 Fixed issue indicating SQL Server licenses required from exempt editions
SRP-13207 An issue where the "primary replica" section of the availability group page could appear blank for servers with a case-sensitive collation has been fixed
SRP-13213 Get-SqlMonitorAlertSuppressionWindow by name no longer fails to return alert suppression windows
SRP-13212 Fixes display issue with Manage Users page
SRP-13182 Fixes time-scaling issue with server waits alert
Removes debug timings erroneously made visible on the website by default
Preview release of monitoring Amazon RDS SQL Servers. See documentation for more details.
SRP-13055 SQL User Processes combines information from sessions and now requests to provide more incremental values over time.
Fixes
SRP-13217 Fixed a security vulnerability (CVSS 4.7, CVE-2020-15526) whereby the scope of disabling TLS certificate checking might accidentally extend beyond that required by various Notification Configuration options to "Ignore SSL or TLS certificate errors".
SRP-13244 Fixed webhook "Preview and test" notification dialog UI bug when accessing response tab.
SRP-13181 Fixed an issue with the longest-running queries summary report not correctly displaying the number of executions within the report period.
SRP-13189 An issue that could cause a memory leak for sites with high usage of WinRM has been fixed.
Starting with SQL Monitor v10.2, SQL Monitor base monitors can no longer be installed on Windows Server 2012 or earlier. For the time being, this only affects the base monitor. Support for running the SQL Monitor website on Windows Server 2012 or earlier will be removed in the future.
We've moved to .NET Core 3.1; Microsoft do not support Windows Server 2012 or earlier as deployment targets for .NET Core 3.1. This also means that SQL Monitor base monitors cannot be installed on unsupported desktop operating systems. Refer to Microsoft's installation guidance for specific versions.
You can monitor the same versions of Windows and SQL Server that you've always monitored. However, base monitors need to be installed on Windows Server 2012 R2 or newer.
Features
The Amazon RDS SQL Server monitoring preview now includes support for alerts and groups.
Most SQL Server-specific alerts can now be raised for Amazon RDS SQL Servers.
The alerts appear in the alert inbox, and alert summaries appear in the global and server overview pages.
Amazon RDS SQL Servers can now be placed into groups.
Alert settings for each server are inherited from their group, and can be overridden in the Configure > Alert settings pages.
Fixes
SRP-13298 fixed an issue loading log pages for clusters or cluster nodes.
Correctly display warning when upgrading from a version of SQL Monitor earlier than 10.2 that installing on older Windows versions is no longer supported.
on upgrade to 10.2.3, 100% (4 out of 4) of base monitor installs failed with "SQL Monitor Base failed with exit code 0xe0434352". However all base monitors show up in configuration without reporting errors, so I'm kind of assuming that everything is OK.
PaulD, I too experience this issue. If you run the install a second time, it will succeed. I'm not sure if running a second time is really needed, but I get nervous when the installer reports that the installation failed, so I run it again just in case.
This issue only seems to manifest itself if you are running the web monitor and base monitors on separate hosts. I have reported this issue to Red Gate Support and they have been able to reproduce it. They have created SRP-13303 to address this. I have not received an indication as to when it is expected to be resolved. But am hopeful it will be soon.
The Amazon RDS SQL Server monitoring preview now includes support for Analysis and Active Directory permissions. You can also specify Amazon RDS Sql Servers in Custom metrics.
Improvements
Improved support for Amazon RDS SQL Servers on the monitored servers page.
SRP-13342 - Disk space SNMP alert shows disk space values.
Fixes
SRP-13246 - Log Backup overdue will not raise on master databases.
SRP-13277 - Fix issue with testing server connectivity on the manage monitored servers page when the 'auto-detect cluster name' option is deselected.
SRP-13339 - Classify additional sql server processes as sql processes correctly.
SRP-13355 - Fix issue with Azure SQL Databases failing to be listed on the analysis page.
Restored the ability to set an HTTP proxy for Webhooks and Slack notifications. See documentation for steps to set this up.
Changes
Replaced the log4net logging library with Serilog. A security vulnerability was reported against log4net (CVE-2018-1285, CVSS base score 9.8). Whilst the use of log4net within SQL Monitor was not subject to the vulnerability, we've nonetheless removed log4net to avoid false positives in security scans. If you have customized your log4net configuration within SQL Monitor, those customizations will no longer apply. In this case, please contact Redgate support for help with replicating your customizations using the new Serilog configuration files.
API changes
PowerShell API update to support Add, Get, Remove SQL Servers for Amazon RDS and Azure SQL Servers.
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
Features
Fixes
<#
Features
Fixes
Features
Query text for SQL User Processes is now available by selecting a process on the server overview
Fixes
SRP-13108
Delays database backup overdue alerts being raised to allow for availability group DMVs to be initialized
SRP-13086
Handle monitoring errors raised when a database becomes unavailable that were previously putting the monitored server into a stopped monitoring state.
Resolves an issue during base monitor startup when the data repository is not available
Eliminated some monitoring queries when it's known up-front that they won't return any monitoring data.
Improved the performance of global dashboard
Features
Fixes
Features
Fixes
Features
Fixes
Breaking Changes
Starting with SQL Monitor v10.2, SQL Monitor base monitors can no longer be installed on Windows Server 2012 or earlier. For the time being, this only affects the base monitor. Support for running the SQL Monitor website on Windows Server 2012 or earlier will be removed in the future.
We've moved to .NET Core 3.1; Microsoft do not support Windows Server 2012 or earlier as deployment targets for .NET Core 3.1. This also means that SQL Monitor base monitors cannot be installed on unsupported desktop operating systems. Refer to Microsoft's installation guidance for specific versions.
You can monitor the same versions of Windows and SQL Server that you've always monitored. However, base monitors need to be installed on Windows Server 2012 R2 or newer.
Features
Fixes
Features
Fixes
Fixes
This issue only seems to manifest itself if you are running the web monitor and base monitors on separate hosts. I have reported this issue to Red Gate Support and they have been able to reproduce it. They have created SRP-13303 to address this. I have not received an indication as to when it is expected to be resolved. But am hopeful it will be soon.
Features
- The Amazon RDS SQL Server monitoring preview now includes support for Analysis and Active Directory permissions. You can also specify Amazon RDS Sql Servers in Custom metrics.
Improvements- Improved support for Amazon RDS SQL Servers on the monitored servers page.
- SRP-13342 - Disk space SNMP alert shows disk space values.
Fixes- SRP-13246 - Log Backup overdue will not raise on master databases.
- SRP-13277 - Fix issue with testing server connectivity on the manage monitored servers page when the 'auto-detect cluster name' option is deselected.
- SRP-13339 - Classify additional sql server processes as sql processes correctly.
- SRP-13355 - Fix issue with Azure SQL Databases failing to be listed on the analysis page.
- Restored the ability to set an HTTP proxy for Webhooks and Slack notifications. See documentation for steps to set this up.
Changes- Replaced the log4net logging library with Serilog. A security vulnerability was reported against log4net (CVE-2018-1285, CVSS base score 9.8). Whilst the use of log4net within SQL Monitor was not subject to the vulnerability, we've nonetheless removed log4net to avoid false positives in security scans. If you have customized your log4net configuration within SQL Monitor, those customizations will no longer apply. In this case, please contact Redgate support for help with replicating your customizations using the new Serilog configuration files.
API changesFeatures
Improvements
Fixes
Features
Improvements
Fixes
Fixes
Resolves an issue with some tiles of the example report failing to load
#168702 Resolves an issue with displaying Query History Details in SQL Monitor with Azure Databases.
Changes
SRP-13077 Reduce frequency of DBCC calls
API changes
7670 - The Cluster, Standalone Machine, AzureSqlServer, and AmazonRdsSqlServer classes contain Group property (please download updated powershell module)
Features
Improvements
Fixes
Changes
Redgate Software
Features
Fixes
Features
Improvements
Features
Added database graph to tempdb
Added temporary table usage to tempdb section