KB4537749 - Improvement: Add two system tables in the Memory-optimized TempDB metadata feature in SQL Server 2019

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Applies To

SQL Server 2019 on Linux (all editions) SQL Server 2019 on Windows (all editions)

Summary

This improvement adds two new system tables sys.sysallocunits and sys.sysrowsets in the Memory-optimized TempDB metadata mode. Any metadata contention previously present on these two system tables in tempdb is now mitigated.

Note: You can use trace flag 3899 to disable the improvement and return to the previous functionality, where the sys.sysallocunits and sys.sysrowsets tables aren't included in the Memory-optimized TempDB metadata mode.

More information

This improvement is included in the following cumulative update for SQL Server:

Cumulative Update 2 for SQL Server 2019

Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server:

Latest cumulative update for SQL Server 2019