SQL Server In-Memory OLTP Internals for SQL Server 2016

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.

Related Posts:


SQL Server 2008 R2, like its predecessors, is more than a database engine. It is a

Azure SQL Server

Azure SQL for beginners is a series to help bring SQL Server professionals to Azure SQL (Azure SQ

Deeper insights across data with SQL Server 2016

The growing volume, velocity, diversity, and locations of enterprise data make it increasingly ch