SQL Server Features and Components

SQT09 HSQL Server 2014 "Hekaton" (a.k.a. In-Memory OLTP) Deep Dive


2:00pm - 3:15pm

Level: Advanced

Bradley Ball

Sr. Consultant – Premier Support for Developers


Microsoft has announced that SQL Server 2014 (the next version of the product) will finally enter the In-Memory Table market via project "Hekaton:" In-Memory OLTP tables. With this new technology comes a lot of questions! How does it work, how are records stored in memory, how are they stored on disk? Better yet are they stored on disk? What are hash tables, how to do you query them, how do queries work internally, what do we need to change and what are the limitations? How does Hekaton work on SQL restart (Redo & Undo), with Clustering, or with AlwaysOn AG's? You have questions and in this Deep Dive into Hekaton we'll cover all the answers.

You will learn:

  • Memory record structures as well as the way that Hekaton is loaded into memory on SQL Restart (Redo and Undo)
  • On disk structures for Hekaton, and review Hash Indexes
  • How Hekaton works with HA/DR technologies such Clustering and Availability Groups
  • How to use Hekaton using regular queries and special memory optimized stored procedures, as well as what transaction isolation levels are compatible with one another