Every major database vendor offers In-Memory technology: Oracle, SAP, and also Microsoft. Since SQL Server 2014 Microsoft provides us “In-Memory OLTP” (formerly known as “Hekaton”). The goal of In-Memory OLTP is very simple: improve the throughput of your workload by 100 times! Here are links with further resources about In-Memory OLTP in SQL Server.
Blog postings about In-Memory OLTP
In-Memory OLTP (Hekaton) and Sort Warnings – Even Sort operators in In-Memory OLTP based execution plans can spill over to TempDb and cause physical I/O. Learn in this blog posting how to avoid them.
Configuring the In-Memory OLTP File Group for High Performance – In-Memory OLTP is about Extreme Transaction Processing. Unfortunately a default configuration of In-Memory OLTP doesn’t give you the best possible performance. In this blog posting I show you which options you have to tune for a maximum performance.
Myths and Misconceptions about Hekaton – There are so many myths and misconceptions around In-Memory OLTP. I have busted all of them for you!
Choose your Hash Bucket Count very wisely in Hekaton! – Learn how slow In-Memory OLTP will be with an in-correctly chosen Hash Bucket Count.
Extreme Transaction Processing (XTP, Hekaton) – the solution to everything? – The main goal of this blog posting is to give you a better understanding of Hekaton, the current limitations, and the scalability of this amazing new In-Memory technology.
First Steps with Extreme Transaction Processing – This blog posting gives you a brief overview how to make your first steps with In-Memory OLTP that was formerly known as Hekaton.
Whitepapers/Books about In-Memory OLTP
SQL Server Internals: In-Memory OLTP – The one and only book currently available about In-Memory OLTP. Written by the famous Kalen Delaney. Sometimes very hard to read, but every page is worth it!
SQL Server In-Memory OLTP Internals Overview – This whitepaper gives you an overview about the In-Memory OLTP engine in SQL Server 2014.
Hekaton: SQL Server’s Memory-Optimized OLTP Engine – This whitepaper talks about the main pillars of In-Memory OLTP: Indexing, Native Compilation, Transaction Processing, Transaction Durability & Garbage Collection.
High-Performance Concurrency Control Mechanisms for Main-Memory Databases – This whitepaper is about the Multi Version Concurrency Control Mechanism implemented by In-Memory OLTP.
The BW-Tree: A Latch-Free B-Tree for Log-Structured Flash Storage – This whitepaper talks about the Bw-Tree – the indexing structure on which Range Indexes are build on.
The Bw-Tree: A B-tree for New Hardware Platforms – A more detailed whitepaper about the Bw-Tree. This one also covers the Page Mapping Table in more detail.
Compilation in the Microsoft SQL Server Hekaton Engine – This whitepaper talks about the Native Stored Procedure Compilation in In-Memory OLTP.
Videos about In-Memory OLTP
SQLPASS Summit 2013 Keynote: Hekaton: Why, What, and How (by David DeWitt) – David DeWitt gives one of the best introductions to In-Memory OLTP in SQL Server 2014. A must watch!
In-Memory OLTP: Overview of Project “Hekaton” – This Microsoft TechEd 2013 overview session covers the user scenarios and the hardware trends such as decreasing memory cost, many-core processors, and stalling CPU clock rate that prompted the key architectural pillars of memory optimization, no lock/latch concurrency control, and native compilation.
In-Memory OLTP Developer Deep Dive – This Microsoft TechEd 2013 database developer focused session discusses how memory optimized tables and natively compiled stored procedures work, and how ACID is achieved from the transaction perspective without locking and latching, as well as the analysis and migration tool.
In-Memory OLTP Management Deep Dive – This Microsoft TechEd 2013 DBA focused session discusses how ACID is achieved, especially around storage. The session also covers a deep dive into memory provisioning, high availability, as well as manageability and supportability.