Memory Optimized TempDB for Faster Performance

Presentation Title: Memory Optimized TempDB for Faster Performance

Abstract:
There is a misconception that TempDB contention is fully resolved in SQL Server 2022, that is NOT true. Contention still occurs due to temp tables when stored procedures execute concurrently multiple times in busy OLTP environments.
In this session, I will show you how to tackle this issue by leveraging the memory-optimized TempDB metadata feature.
I’ll demonstrate how and when to enable this feature to address issues with temp tables. I’ll also discuss the potential downsides of this feature and share the best practices for optimizing TempDB performance. TempDB behaves the same in Azure and managed instance.
By the end of this session, you will have a better understanding of how to use this feature to improve performance at both the query and server level.