Memory Optimized TempDB for faster performance with Haripriya Naidu
Details
There is a misconception that TempDB contention is fully resolved in SQL Server 2022. 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.
Agenda:
6:00-6:30 - Networking and speaker setup time
6:30-6:35 - Opening remarks & Introductions
6:35 - Speaker time!