O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_35

35. In-Memory OLTP Internals

Dmitri Korotkevitch

(1)Tampa, Florida, USA

Hekaton was 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–40X system throughput increase when In-Memory OLTP is used.

This chapter discusses the internal architecture of In-Memory OLTP and explains how In-Memory OLTP stores and works with data in-memory and persists it on-disk. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required