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 a Principal Consultant and the Founder of Procure SQL LLC. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a PASS Regional Mentor, leader of the Austin SQL Server User Group and founder of the HADR Virtual Chapter.