Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners

© Dmitri Korotkevitch 2018

Dmitri KorotkevitchExpert SQL Server Transactions and Lockinghttps://doi.org/10.1007/978-1-4842-3957-5_13

13. In-Memory OLTP Concurrency Model

Dmitri Korotkevitch¹ 

(1)

Land O Lakes, Florida, USA

 

The In-Memory OLTP technology, introduced in SQL Server 2014, can significantly improve the performance and throughput of OLTP systems. The key technology component—memory-optimized tables—stores the data in-memory, utilizing lock- and latch-free multi-versioning concurrency control.

This chapter will provide an overview of the In-Memory OLTP Concurrency Model and explain how the Engine handles transactions internally.

In-Memory OLTP Overview

Way back when SQL Server and other major databases were originally designed, hardware was ...