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
About cumulative updates for SQL Server
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
References
Learn about the terminology that Microsoft uses to describe software updates.