YoVDO

Attention Contention

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Azure SQL Database Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 Warehouse
Microsoft 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