Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server

© Enrico van de Laar 2019

Enrico van de LaarPro SQL Server 2019 Wait Statisticshttps://doi.org/10.1007/978-1-4842-4916-1_13

13. In-Memory OLTP–Related Wait Types

Enrico van de Laar¹ 

(1)

Drachten, The Netherlands

 

With the release of SQL Server 2014, Microsoft introduced a brand new SQL Server feature called In-Memory OLTP (or codename Hekaton). In-Memory OLTP is a memory-optimized database engine that is directly integrated into the SQL Server 2014 SQL Server engine. In-Memory OLTP is an enterprise-only feature designed to improve performance—up to 20 times, according to Microsoft—by placing tables entirely into the memory of your SQL Server instance. These memory-optimized tables are fully durable and use lock-and-latch free structures to optimize ...