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.