Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

Locking and Blocking in SQL Server

Description

Locks are used by SQL Server to isolate database users from each other. Unfortunately incompatible locks leads to blocking. And blocking situations are always hurting your end users regarding their response time. In this one-day long workshop we will have a detailed look at Locking & Blocking in SQL Server, and how you can influence SQL Server in this area. During the precon we will cover the following areas:
  • Transactions
  • Isolation Levels Locking Deadlocking Latches & Spinlocks

Learning Objectives

Previous Experience

Tech Covered