Many versions ago, SQL Server managed concurrency only pessimistically, using locking and blocking to prevent multiple users from updating the same data simultaneously and to provide data consistency. In this seminar we will look at the concurrency enhancements based on a technology called row-level versioning (RLV) that implement a form of optimistic concurrency. We’ll compare concurrency management with RLV to concurrency management with locking and blocking.
- Differences between Pessimistic and Optimistic Concurrency Control in SQL Server
- How your application’s transaction control affects concurrency
- SQL Server’s locking and blocking behaviors
- SQL Server metadata to observe the locking, blocking and row versioning
- Differences between the two snapshot based isolation levels: Read Committed Snapshot and Full Snapshot
Prerequisites: a basic understanding of batches and transactions in SQL Server and some experience writing TSQL-based applications.
About the instructor: Kalen Delaney has been a Microsoft MVP for SQL Server since 1993. She is the author of several highly regarded books, including Microsoft SQL Server 2012 Internals, SQL Server Concurrency, SQL Server MVP Deep Dives, and SQL Server Internals of In-Memory OLTP.
This is an online class – Kalen hosts it in GoToWebinar, live on webcam, taking questions as she goes through the material. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way. For more information, check out the Training Logistics PDF for our online classes.
You can watch again later with Instant Replay – after your class finishes, you can stream the online recordings for a year. Brush up on stuff you missed or revisit your favorite topics. It’s the best of both worlds: live training with us, plus reminders.
Online class times:
- June 14, 2018 Noon-4PM Eastern, – 9AM-1PM Pacific – view in your time zone