Understanding Locking with Distributed Systems

Abstract:

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.

Speakers:

  • 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.

Recorded At:

Recorded on:

Jan 17, 2017

More Info:

http://cactuss.sqlpass.org/Home.aspx?EventID=6279

Tags: