TempDB The Good The Bad The Ugly - Pam Lahoud

Показать описание

If you ask 100 SQL Server DBAs what their biggest headaches are, at least 99 of them will say something to do with TempDB. Over the years, there have been many different recommendations about configuration options for TempDB and they have changed over time. The behavior of TempDB has also changed over time. What hasn't changed is the criticality of TempDB and how its proper use and configuration can have major implications in the performance of your application. In this session, we will discuss some of the improvements with TempDB in the latest versions of SQL Server and what good TempDB practices look like today. We will also discuss the improvements that were released in SQL Server 2019 that will unlock the scalability of TempDB-heavy workloads now, and into the future.