The Agenda

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