KB5049296: Cumulative Update 31 for SQL Server 2019

SQL Server 2019 Cumulative Update (CU) builds

Known issues in this update
Access violation when session is reset
SQL Server 2019 CU14 introduced a fix to address wrong results in parallel plans returned by the built-in SESSION_CONTEXT. However, this fix might create access violation dump files when the SESSION is reset for reuse. To mitigate this issue and avoid incorrect results, you can disable the original fix, and also disable the parallelism for the built-in SESSION_CONTEXT. To do this, use the following trace flags:

• 11042 - This trace flag disables the parallelism for the built-in SESSION_CONTEXT.
• 9432 - This trace flag disables the fix that was introduced in SQL Server 2019 CU14.
  Microsoft is working on a fix for this issue and it will be available in a future CU.

Improvements and fixes included in this update
A downloadable Excel workbook that contains a summary list of builds, together with their current support lifecycle, is available. The Excel file also contains detailed fix lists for SQL Server 2022, SQL Server 2019, and SQL Server 2017.