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. Goals:
  • 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!
Presented by Kalen Delaney at SQLBits XVI