4

Checking SQL Server 2019 CTP 2.5 (15.0.1500.28) I found this new configuration option and was wandering what is behind it. Couldn't find any information so far and was wondering if you know where to find more about it?

4

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
1

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

0

New in-memory database feature, memory-optimized tempdb metadata added. See below link https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database?view=sqlallproducts-allversions#memory-optimized-tempdb-metadata

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.