Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Inside SQL Server Latches

PASS Data Community Summit via YouTube

Overview

Dive deep into the advanced internals of SQL Server's latch mechanism in this 1 hour 25 minute conference talk from PASS Data Community Summit. Explore how the SQL Server database engine utilizes latches for internal synchronization of critical operations. Gain insights into why understanding latches is crucial for close monitoring of SQL Server performance. Delve into the intricacies of how SQL Server employs latches to synchronize key internal data structures. Be prepared for an advanced "500" level session that may include discussions on advanced diagnostics like the Windows debugger and Windows APIs. Prerequisite knowledge includes a basic understanding of the SQL Server engine and familiarity with common SQL Server Engine DMVs such as sys.dm_exec_sessions, sys.dm_exec_requests, and sys.dm_os_wait_stats.

Syllabus

Inside SQL Server Latches - Bob Ward

Taught by

PASS Data Community Summit

Reviews

Start your review of Inside SQL Server Latches

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.