SQL Server offers two methods for applications to provide
data consistency: Pessimistic and Optimistic Concurrency Control. In this
seminar we’ll discuss what consistency might mean to your applications, and
describe the details of how each concurrency model works internally. We’ll
examine the costs and trade-offs between the two models. Finally, we’ll examine
the metadata and tools available for analyzing and troubleshooting problems.
- Understand why concurrency management is a
crucial part of database and application tuning
- Explore the details of how SQL Server
implements pessimistic concurrency with locking, and when optimistic
concurrency can be a useful alternative
- Look at how in-memory OLTP changes the
whole concurrency story!