Attention Contention
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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.
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
Related Courses
Delivering a Relational Data WarehouseMicrosoft via edX Recovering Data in Azure and SQL Server
Microsoft via edX Databases in Azure
Microsoft via edX Introduction to Data Modeling
Microsoft via edX Extend Your Application with REST Services
Microsoft via edX