Memory Optimized TempDB for Faster Performance

There is a huge misconception that TempDB contention is fully resolved in SQL Server 2022, that is NOT true. Contention still exists due to frequent creation/dropping of temp tables in stored procedures 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.

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 levels.