SQL Server Locking, Blocking, and Deadlocking



Locks are used by SQL Server to isolate database users from each other. Unfortunately incompatible locks lead to blocking situations. And blocking situations always hurt your end user response times. In this one-day long deep dive online training we will have a detailed look at Locking & Blocking in SQL Server, and at how you can influence SQL Server in this area.

During the training we will cover the following areas:

  • Transactions
    • ACID Properties
    • Transaction Control
  • Pessimistic Concurrency
    • Read Uncommitted
    • Read Committed
    • Repeatable Read
    • Serializable
  • Optimistic Concurrency
    • Read Committed Snapshot Isolation
    • Snapshot Isolation
  • Locking
    • Internals
    • Lock Escalations
  • Deadlocking