SQL Server 2022 Cumulative Update 24 (CU24, KB5080999) is documented as a post-CU23 release that includes 14 fixes across the engine, high availability, replication, search, programmability, and Linux-related areas. The update brings the build to 16.0.4245.2.

For DBAs and developers, the main point is that CU24 is not just a rollup of fixes. It also introduces a couple of functional changes, including a new optional parameter for replication setup and a configurable timeout for full-text search batch processing.

Improvements and fixes

Microsoft lists 14 fixes in this release, spanning several practical areas:

  • Replication: Adds the optional @multi_subnet_failover parameter to sp_adddistributor, and fixes an issue where the distribution agent could use the AG primary replica name instead of the listener name in a case-sensitive availability group setup.
  • High Availability and Disaster Recovery: Fixes issues involving contained availability group connections, configure-only replicas after restart, and a local monitor server used with Log Shipping and Contained Availability Group after failover.
  • Backup and restore: Fixes an in-memory sort buffer calculation issue that could lead to an infinite loop when the required page count exceeds supported limits.
  • Query processing and execution: Fixes a floating point exception when switching from a Hekaton stack to a non-Hekaton stack, and addresses a sort failure on rowsets larger than four billion rows that could generate an assertion error.
  • Programmability: Fixes a memory access violation that could occur when altering a disabled DDL trigger.
  • Search: Adds a configurable full-text search batch timeout through sp_fulltext_service 'batch_timeout', with values from one minute to one hour in milliseconds. Microsoft says batches time out after 10 minutes by default if there are no progress updates.
  • Security infrastructure: Addresses contention on security-related metadata tables by adding a sysowners check for frequently accessed metadata tables.
  • Linux-specific changes: Corrects the ios_in_progess column name to ios_in_progress in sys.dm_os_linux_disk_stats, adds support for symbolic links in the getattribute API, and adds a configuration option to include Bulkadmin operations in the allowlist.

Known issues

Microsoft documents three known issues for CU24:

  • SESSION_CONTEXT in parallel plans: Queries using SESSION_CONTEXT can return incorrect results or produce access violation dump files when they run in parallel query plans, especially if the session is reset for reuse.
  • Linked server queries with MSDASQL: Linked server queries that use the MSDASQL provider and specify a provider string can fail with error 7416, reporting that no login-mapping exists.
  • Availability group listener error 10013: When a SQL Server availability group with a listener starts, fails over, or creates a new listener, error log messages can indicate listener object problems or a port already in use. Microsoft says the listener connections continue to work, and the issue is under investigation.

This release notes that removing an issue from the source would not, by itself, prove it has been resolved; however, the packet here explicitly lists these as known issues for CU24.

Official source