TempDB Contention: How to Identify and Resolve it

Abstract:
As a DBA, you know that TempDB performance is crucial to overall health and server performance. At the same time, you have tons of concurrent tasks running on your server that depend heavily on TempDB, causing a slowdown in performance.

In this session, I'll cover how the allocation of resources and workspace on TempDB is being managed. Next, I'll show you how to analyze the causes of contention and explore methods to identify and fix them. This includes configuring, and monitoring the TempDB to operate optimally on production servers.
Finally, I'll show you a demo on how to mitigate each of the contention types and how it varies across SQL Server versions.

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.

Agenda:
6:00-6:30 - Networking and speaker setup time
6:30-6:35 - Opening remarks & Introductions
6:35 - Speaker time!