SQL Monitor v10.2.x

Released: Jul 22, 2020

Atualizações na v10.2.x

v10.2.12

Updated Oct 7, 2020

Features

  • Added database graph to tempdb.
  • Added temporary table usage to tempdb section.

v10.2.11

Updated Sep 30, 2020

Features

  • Amazon RDS machine metrics now collected from Amazon AWS API.
  • Amazon RDS Server Overview page now shows Memory and Disk metrics.

v10.2.10

Updated Sep 29, 2020

Features

  • Added application graph to tempdb.

Fixes

  • SRP-13413 fix issue causing deadlocks in tempdb.

v10.2.9

Updated Sep 24, 2020

Features

  • Added Version Store graph to tempdb.
  • Added tempdb monitoring for Amazon RDS.
  • Query plan viewer has link to open it in new tab.
  • 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.
  • SRP-13400 - 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.
  • Changed - 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 the primary base monitor only.

v10.2.8

Updated Sep 10, 2020

Fixes

  • Resolves an issue with some tiles of the example report failing to load.
  • 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).

v10.2.7

Updated Sep 3, 2020

Features

  • Released new feature for monitoring tempdb.
  • Reports now support Amazon RDS and Microsoft Azure for analysis graph and summary tiles.
  • Improved performance of vmware sampling.

Fixes

  • SRP-13386 - Prevent duplicate dashboard cards for Microsoft Azure SQL Databases with non-lowercase names.

v10.2.6

Updated Aug 27, 2020

Features

  • Reports now support Amazon RDS and Microsoft Azure for analysis graph and summary tiles.
  • Improvements
    • SRP-13362 - Change left navigation bar databases icon.

Fixes

  • SRP-13030 - Fixed issue with msdb.dbo.sp_help_job returning no value when querying.
  • Fixed validation message not being displayed correctly in monitored servers add form.
  • Internal
    • Update jQuery and knockout libraries used by the query plan viewer.

v10.2.5

Updated Aug 25, 2020

Fixes

  • SRP-13303 - Fixed installation error while upgrading SQL Monitor Web server.
  • Fixes wait stats sampling failing due to NULL value.
  • API changes
    • SRP-13341 - Add support for Get-SqlMonitorDatabase for AmazonRds databases.
  • Internal
    • Remove unconfigurable tables from config schema.
    • Bump .NET Core to 3.1.401.

v10.2.4

Updated Aug 19, 2020

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.
    • Disk space SNMP alert shows disk space values.

Fixes

  • Log Backup overdue will not raise on master databases.
  • Fixed issue with testing server connectivity on the manage monitored servers page when the 'auto-detect cluster name' option is deselected.
  • Classify additional sql server processes as sql processes correctly.
  • Fixed issue with Microsoft Azure SQL Databases failing to be listed on the analysis page.
  • Restored the ability to set an HTTP proxy for Webhooks and Slack notifications.
  • 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, Redgate Software have 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
    • Microsoft PowerShell API updated to support Add, Get, Remove SQL Servers for Amazon RDS and Microsoft Azure SQL Servers.

v10.2.3

Updated Jul 30, 2020

Fixes

  • SRP-13308 Fixes a monitoring error on Microsoft SQL Server 2012 SP1 caused by accessing user_objects_deferred_dealloc_page_count.
  • Resolved a visual issue with the top graph on server overview pages.

v10.2.2

Updated Jul 29, 2020

Features

  • SRP-13263 Trust Server Certificate in Microsoft SQL Server connection properties is now available through the API.

Fixes

  • SRP-13300 Fixed Alert Suppression Windows powershell client issues.
  • Fixed an issue with popup action menus sometimes not being visible.
  • SRP-13306 Analysis pages now correctly get show data from all base monitors.

v10.2.1

Updated Jul 23, 2020

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.

v10.2.0

Updated Jul 22, 2020

Fixes

  • SRP-13259 Fixed grouping of deadlock alerts in the alert inbox.
  • SRP-13243 Fixed an issue with the server waits alert raising at severities that are not enabled.
  • SRP-13275 Fixed units in display for Clock Skew alerts.
  • SRP-13272 The alert configuration page now displays correctly for sites with custom alerts defined against multiple base monitors.
  • Improved load speed and responsiveness of versions estate tab.