Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

T. LaRock, E. van de LaarPro SQL Server 2022 Wait Statisticshttps://doi.org/10.1007/978-1-4842-8771-2_13

13. In-Memory OLTP–Related Wait Types

Thomas LaRock¹   and Enrico van de Laar²

(1)

East Longmeadow, MA, USA

(2)

Drachten, The Netherlands

 

With the release of SQL Server 2014, Microsoft introduced a brand new SQL Server feature called In-Memory OLTP (codename Hekaton). In-Memory OLTP is a memory-optimized database engine directly integrated into the SQL Server engine. In-Memory OLTP is designed to improve performance – up to 20 times, according to Microsoft – by loading tables entirely into the memory of your SQL Server instance. These memory-optimized tables ...