CHAPTER 32
In-Memory OLTP Internals
Hekaton is the code name of an in-memory OLTP engine introduced in SQL Server 2014. It is an Enterprise Edition feature, and it is available only in the 64-bit version of SQL Server. Hekaton is Greek for one hundred, which was the target performance improvement goal of the project. Even though this goal has yet to be achieved, it is not uncommon to see a 10X-30X system-throughput increase when in-memory OLTP is used.
This chapter discusses the internal architecture of in-memory OLTP, the in-memory and on-disk storage format for memory-optimized data and the concurrency model used in Hekaton.
Why Hekaton?
Get Pro SQL Server Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
