Explore tempdb contention in SQL Server environments, including on-premises, Azure SQL Managed Instance, and Azure SQL Database in this 54-minute conference talk. Dive into both allocation and metadata contention, understanding their occurrence, diagnosis, and prevention. Gain insights through theoretical explanations and practical examples, learning best practices and alternatives to resolve and avoid these issues. Discover key points on pages, extents, and recommendations for optimizing SQL Server performance across various platforms.
Overview
Syllabus
Introduction
Agenda
First demo
Allocation contention
Pages
Recommendation
How it works
What is an extent
Demo
Metadata Contention
Diagnosis
How to fix
Example
Key Points
Taught by
PASS Data Community Summit