TempDB Contention: How to Identify and Resolve it
18/12/2024
Abstract
In SQL Server 2022, there is a huge misconception that TempDB contention is completely resolved. This is NOT true.
Attend this session to find out why and what needs to be addressed in TempDB for better performance.
In this session, I’ll show you how contention on TempDB occurs and how to identify when it occurs. I’ll explore methods to analyze and resolve contention.
Finally, I’ll show you a demo on how to mitigate each of the contention types and how it varies across SQL Server versions 2019 and 2022. By the end of this session, you will be able to address and resolve TempDB contention promptly, ensuring optimal TempDB performance in your SQL Server.
Speakers
Haripriya Naidu has been working as a SQL Server Database Administrator for 10 years in Boston, MA. She is passionate about databases and enjoys diving into SQL Server engine internals and optimizing performance. Additionally, she is an AWS Certified Solutions Associate and won the “Rookie of the Year” Award at work in 2024.
She actively participates in the New England SQL Server User group, SQL Saturdays, and engages in multiple online learning communities. These activities fuel her passion for learning and sharing insights within the SQL community.
She finds joy in reading non-fiction books. Being a SQL enthusiast, a perpetual learner, and a family person defines her interests and passions.
Agenda (CET, UTC+1)
| 18u30 | Welcome and introductions |
| 18u30 | TempDB Contention: How to Identify and Resolve it (75 minutes) |
| 19u45 | Session End |
Location
Virtual Meeting (Teams Link)