Understanding and Monitoring Tempdb [Room 1.113]
Speaker(s):
Vicky Harp
Duration: 60 minutes
Track: Performance
Every SQL Server system that you work with has a tempdb database. In this session, learn how tempdb is structured, what it is used for, and what common performance problems are tied to this shared resource. Gain an understanding of tempdb contention and the snapshot isolation version store and how to detect problems with both. You will leave this session with a new confidence in what configuration and file settings may prevent problems in your environment.