Understanding Locking with Distributed Systems

By default with SQL Server, locking occurs when one or more queries are waiting on another query to finish. Depending on your workload, that might not be the ideal locking method for your application, or a subset of your queries. In this session, you are going to learn the basics of all the isolation modes inside of SQL Server and the pros and cons of each one so you know how to use them effectively. We will review table hints and how they impact application concurrency. Finally, we will cover how to identify and prevent deadlocks in your system.

• John Sterrett

  19 Recordings
  John's experience leading large technical teams in complex environments has made him a global expert in performance and scalability. John speaks at conferences around the world on database strategy and topics related to performance tuning, development, and cloud computing. He is a Microsoft Certified Trainer, is the principal consultant and founder at Procure SQL.

• Capitol Area Central Texas Users of SQL Server 87 Recordings

• SQL Performance 20 Recordings