Deep Dive into Memory Optimized TempDB

TempDB contention has always been a challenge for DBAs, especially in high-concurrency OLTP environments. To address this, SQL Server has introduced several enhancements starting with SQL Server 2019, to reduce bottlenecks and improve performance, including Memory-Optimized TempDB.

In this session, I’ll show you how Memory-Optimized TempDB works, when to use it, and how to implement it. I’ll demonstrate how it will resolve contention. I'll also cover limitations and provide strategies to manage them effectively.

By the end of this session, you'll have a clear understanding of how and when to leverage Memory-Optimized TempDB to enhance server performance.