SQL Server In-Memory OLTP Internals for SQL Server 2016

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Summary: In-memory OLTP, frequently referred to by its codename "Hekaton", was introduced in SQL Server 2014. This powerful technology allows you to take advantage of large amounts of memory and many dozens of cores to increase performance for OLTP operations by up to 30 to 40 times! SQL Server 2016 is continuing the investment in In-memory OLTP by removing many of the limitations found in SQL Server 2014, and enhancing internal processing algorithms so that In-memory OLTP can provide even greater improvements. This paper describes the implementation of SQL Server 2016's In-memory OLTP technology as of SQL Server 2016 RTM. Using In-memory OLTP, tables can be declared as 'memory optimized' to enable In-Memory OLTP's capabilities. Memory-optimized tables are fully transactional and can be accessed using Transact-SQL. Transact-SQL stored procedures, triggers and scalar UDFs can be compiled to machine code for further performance improvements on memory-optimized tables. The engine is designed for high concurrency with no blocking.

Writer: Kalen Delaney

Technical Reviewers: Sunil Agarwal and Jos de Bruijn

Published: June, 2016

Applies to: SQL Server 2016

To review the document, please download the SQL Server In-Memory OLTP Internals for SQL Server 2016 document.