2021 Data.SQL.Saturday.LA presents: Lock Picking your SQL Server

Event organizer:
https://linktr.ee/sqlsatla

Session Room:
SIOS (@SIOSTech)

Session Speakers:
Shane Welgama (@ShaneWelgama)

Session Hosts:
Brodie Brickey

Session Abstract:
Locking is an essential need to uphold data integrity. Managing locking behavior is also important when it comes to improving transaction concurrency. In this talk, we will dive into the locking behavior of SQL Server. We will learn how to uncover performance problems related to locks and lock escalations, when and why deadlocks happen, and the possible steps you can take to prevent deadlocks from happening. Join me in understanding the key to SQL Server’s locking behavior.

Session Materials:
TBD

Session Feedback:
https://forms.office.com/r/zL5V1VKp6F