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 ...
