SQL Sentry Release Notes

2023

Version 2023.1 [January 18, 2023]

Fixes

  • 62886: Duplicate Key Exception when viewing AlwaysOn tab
  • 68596: Frequent DCOM errors on monitored targets after updating to latest Sept. Windows patch on Windows Server 2019
  • 68700: Open PE in Top SQL for RDS targets does not work for Completed Queries
  • 69805: Distributed AG's running on Named Instances do not allow for traversing between Sub AGs
  • 69875: Log To Windows Event Log action not in the Actions Log
  • 69922: Upgrade CefSharp
  • 69957: Portal: Case sensitivity issue on Top SQL Totals list
  • 69974: Portal: Connection information not visible in PCU

Features

2022

Version 2022.4.1 [November 17, 2022]

Fixes

  • 69918: Arithmetic overflow exception causing dashboard to not open
  • 69886: Portal: Top SQL: Trace Events not being properly mapped to Totals Records

Version 2022.4 [October 18, 2022]

Features

Fixes

  • 68989: [CVE-2022-38107_Sensitive Data Disclosure in SQL Sentry] Console Status shows errors for targets hidden by Rights based security
  • 69269: Autogrowth warning value not displaying correct value
  • 69475: Execute SQL Actions tied to Advisory Conditions do not honor SQL Auth config
  • 68624: Execute SQL does not work for SQL Instances on Non-Default port
  • 69303: No data on Total Buffer Usage chart on Indexes tab

Version 2022.3.2 [July 12, 2022]

Features

  • 68754: Performance enhancements to minimize lock durations
  • 69161: Blocking support for Amazon RDS
  • 68545: Portal Custom Charts: Add ability to clone charts
  • 69012: Portal: Custom Charts: Add ability to control transparency of area charts
  • 69056: Portal: Consolidate and enhance SQL Sentry Support and Documentation icons
  • 69237: Portal: VMware Dashboard
  • 69238: Portal: Azure SQL DB Deadlocks
  • 69166: Security: Upgrade CefSharp library
  • 68777: Re-add Tools menu option to re-run the Onboarding Wizard
  • 67149: Performance improvements to Navigator failure refresh process

Fixes

  • 69042: About page crashes the SQL Sentry Client for Allow_All users
  • 68863: Distributed AG collection not showing in UI
  • 68783: Invalid length parameter passed to the left or substring function
  • 53052: PA\Top SSAS -SSAS Usage Totals Query Timeout
  • 68724: Portal-Top SQL Charts at top of page display time in UTC
  • 68979: Portal-Storage: Include all log reuse wait types
  • 69099: Portal-Storage tab will not load
  • 66923: Reports-Arithmetic overflow error for ReportProc_SQLFileUtilizationAllServers stored procedure

Version 2022.2.0 [April 19, 2022]

Features

  • 68984: Generic Webhooks Support
  • 68926: New EULA for SQL Sentry
  • 64645: GetFileSizeData running long, timing out
  • 68793: Portal: EHO: Add time range selector
  • 68980: Portal: Storage Visualization
  • 68981: Portal: Feature Based Security

Fixes

  • 68625: AG discovery queries have poor performance on RDS instances part of a Basic AG
  • 68483: Installed R Packages Show as Missing (assertthat, R6)
  • 68698: Portal: Configuration Utility: Connection String does not support special characters for the password field

Version 2021.18.10 [January 19, 2022]

Fixes

  • 68638: Licenses being cleared out and reverting to the Evaluation license

2021

Version 2021.18.8 [November 30, 2021]

Fixes

  • 68451: Execute Powershell does not execute against (Target) when specified
  • 68640: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
  • 67781: Inconsistent behavior with advisory condition evaluation
  • 68565: AG/DAG collection query exhausting Connection Pool on Server

Version 2021.18.2 [October 19, 2021]

Features

  • 67354: Allow free repository license to work for AGs
  • 68499: Portal config encryption improvements

Fixes

  • 68463: Overwrites Scalability Pack Enhanced Resolution values
  • 68489: Distributed Availability Groups not visible in UI

Version 2021.12.11 [August 20, 2021]

Fixes

  • 67163: Advisory Conditions that query the SQLSentry database not honoring Monitoring Service's SQL Server auth configuration
  • 68295: Memory Clerks: Incorrect counter category when watching Sql Server 2005
  • 61104: Portal: Case Sensitive database query optimizations

Version 2021.12.2 [ July 15, 2021]

Features

  • 68291: Distributed Availability Group Support
  • 68292: Enhanced Failover Cluster Instance support
  • 67222: Indexes: Collect Indexed Views
  • 67061: PE: Implemented Azure AD - Password Support

Fixes

  • 65849: Advanced disk forecasting errors out for SentryOne databases on SQL Server 2019
  • 67706: Portal: Blocking Tab Incorrectly Shows the Head Blockers Application for all Sub-nodes

Version 2021.8.20 [May 25, 2021]

Features

  • 67829: SQL Sentry Rebrand
  • 67733: Migrated to SolarWinds licensing
  • 67040: New Memory Clerk Counters
  • 63915: Add Processes to Well Known Processes
  • 67068: SQL Sentry: Top SQL: Add Setting for XEvents Collection
  • 66256: Portal: Update Alerts grid to reflect alert type
  • 66819: Portal: Custom Charts: Update metrics to use friendly counter name
  • 66880: Portal: Custom Dashboards: Add chart type selector for each metric
  • 66097: Portal: Add SentryOne Database server name to the top of Environment Heath Overview page
  • 66998: TempDB: Increase Minimum TempDB Page Allocations Threshold to 128 pages

Fixes

  • 66967: Premium license with ONLY Azure SQL DB product items does not permit Azure SQL DB targets to be added
  • 67445: Amazon RDS target collection errors with SQL Server Data Collector and Performance Analysis Data Collector
  • 67578: Performance Analysis Tabs Missing for RDS Target
  • 67447: Always-On collection fails for versions prior to SQL Server 2016
  • 65696: SQL Server: Memory Node: Free Node Memory (KB) is skewing metrics in the SQL Server Memory Chart
  • 63660: Disk Space: File size value incorrect for databases with multiple log files
  • 67426: SQL Sentry: Query plans are mismatched with procedure calls in Plan Explorer
  • 64721: Incorrect events shown for Processing Commands on SSAS 2016+
  • 67425: Key violation errors during plan collection
  • 66878: Portal: Custom Dashboards: Default targets for widgets not filtered correctly
  • 66943: Portal: Performance: Last enabled legend item can be disabled
  • 67259: Portal: Update SQL Server Memory metrics to new counters
  • 65376: Portal: Deadlocks: Deadlock XML Copy button scrolls with content
  • 66952: Portal: Deadlocks: No Data File image misalignment when jumping to Deadlocks
  • 67006: Portal: EHO: Wait time is sorted ascending

Version 2021.1.13 [April 14, 2021]

Features

  • 67349: Enhanced PowerShell Capabilities to Allow Environment Settings Migration

Fixes

  • 67484: Setting "Databases Source : Max Partitions to Collect per Database" not honored when set to a value > 500 for a SQL Server instance or a database.
  • 67208: Portal: Custom Charts: Chart fails to load when intervals cannot align
  • 67332: Portal: Area charts do not display correctly when monitoring service is restarted

Version 2021.1.10 [ February 18, 2021] 

Features 

67156: Portal: Dashboards broken from memory clerk counter migration

Version 2021.1.9 [ February 09, 2021]

Features

  • 65704: Add Condition Type column to Events Log
  • 65723: Display Audit/Failsafe/General condition entries in Events Log for all action types
  • 65871: Apply a default severity to Audit/Failsafe/General conditions
  • 65973: Create "Info" severity level for all conditions
  • 66571: Audit/Failsafe/General conditions impact health score
  • 66724: Update SQL Sentry to use SolarWinds EULA
  • 66455: New Memory Clerk counters for SQL Server 2012+
  • 66573: Portal: Enhanced Custom Dashboards
  • 65500: Portal: Rights-based security support for AD Groups
  • 65952: Portal: Enhanced Rights Based Security

Fixes

  • 50182: Exception occurs when attempting to create a copy of an existing event chain
  • 66428: SQL Server: AlwaysOn: DAG Collection: Stacked Area Charts Broken on Certain Views
  • 64042: "Assigned user" not working in Events Log: Global and Global Conditions Action Settings
  • 66618: Timeouts on Disk Activity
  • 65446: Denying access to certain Hosts prevents all hosts from being monitored
  • 65085: Portal Installation Fails when installing on any Drive other than C
  • 66420: Upgrade fails when upgrading to 2020.20.4
  • 65512: Targets not added to selected group

Additional Information: For more information about release notes for previous SQL Sentry Versions, see the SQL Sentry changelist.