"tempdb metadata memory-optimized" configuration option

As far as I can tell the feature has not been officially announced yet.

There are a couple of resources available on this feature from members of the community:

Youtube video from Erik Darling

Blog post from Ned Otter

This would appear to be the configuration option that will allow you to put some TempDB metadata tables into memory, preventing many types of resource wait and hopefully speeding use of that database up on busy systems. The value of the configuration option can be found with this query:

SELECT * FROM sys.configurations
WHERE configuration_id = 1589

Uses memory-optimized tables to hold tempdb metadata to eliminate the PAGELATCH_UP and PAGELATCH_EX waits

Tags:

Sql Server

Tempdb

Sql Server 2019

Memory Optimized Tables

Related

Displaying an Estimated Execution Plan generates CXPACKET, PAGELATCH_SH, and LATCH_EX [ACCESS_METHODS_DATASET_PARENT] waits Does restarting the SQL Services (on the machine) clear the server cache (for things like query plans and statistics)? Concatenate all values of the same XML element using XPath/XQuery Can I combine SELECT TOP() with the IN operator? Can full drive backup be used instead of MSSQL database backup? Start job from another SQL server instance Using column size much larger than necessary SQL Server Management Studio SSMS 18.0 General Availability release (GA) install fails 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column Executing a stored procedure which selects and inserts into tables in SQL Server can anyone help me with this awful query plan? Can SQL Server create collisions in system generated constraint names?

Recent Posts