Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why the size of your TempDB is suddenly 3TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be Always On Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to configure it properly, you will be better prepared for your workloads whether it be an Azure VM, a physical server, or a container.
Monica Rathbun lives in Virginia, and is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. Monica is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. Monica is passionate about SQL Server and the SQL Server community, doing anything she can to give back. She can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com.
Topics: Database Diagnostics, Database Monitoring, Database Performance, SQL Query Performance Products: SQL Diagnostic Manager for SQL Server