SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton

What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”, code-name: Hekaton.  In short, Hekaton is a SQL Server In-memory OLTP Engine.  Hekaton provides in-memory OLTP capabilities built into core SQL Server database to significantly improve the performance of your database application.  Hekaton is installed with the SQL Server 2014 Engine without requiring any additional actions and allows in-memory performance benefits without rewriting your database application.  You can also increase performance of existing SQL Server applications without having to refresh your hardware.  Hekaton is easy to deploy and allows you to access the other rich features in SQL Server, while taking advantage of in-memory performance.

This complements the existing in-memory data-warehousing and business-intelligence (BI) capabilities already in SQL Server via xVelocity.  Hekaton could benefit DW/BI solutions in two ways that I see: 1) By speeding up the time it takes to pull data from a source system that is in-memory into the data warehouse, and 2) Instead of persisting staging data in tables on disk, you can store them in memory.

Here is the description from the Microsoft site:

Hekaton in-memory OLTP: In-memory database technology that will provide breakthrough performance gains 10 times for existing apps and up to 50 times for new applications optimized for in-memory performance with no additional hardware required.  There will be a diagnostic tool that will suggest which databases and tables are the best candidates to run in-memory.  The “Hekaton” codename will fade and  it will be referred to as the SQL Server In-Memory OLTP Engine.

More info:

In-Memory OLTP White Paper

Edgenet Gain Real-Time Access to Retail Product Data with In-Memory Technology

First steps with Extreme Transaction Processing – Hekaton

SQL Server 2014 In-Memory Technologies: Blog Series Introduction

Getting Started with SQL Server 2014 In-Memory OLTP

SQL Server 2014 CTP1 native compiled Hekaton procedures are faster than regular procedures

Supported and unsupported datatypes with Hekaton tables

Hekaton data and code – where does that stuff actually live?

Geek City: SQL Server 2014 In-Memory OLTP (“Hekaton”) Whitepaper

First baby steps with SQL Server 2014 CTP1

Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1

SQL 2014 In-Memory OLTP ‘Hekaton’: training videos and white papers

Hekaton: Transforming Query Plans into C Code

In-Memory (Memory Optimized) Tables in SQL Server 2014

In-Memory OLTP Q & A: Myths and Realities

Architectural Overview of SQL Server 2014’s In-Memory OLTP Technology

SQL Server 2014 hastens transaction processing

A Tour of the Hekaton AMR Tool

Hardware Considerations for In-Memory OLTP in SQL Server 2014

SQL Server 2014 In-Memory OLTP: App Migration Scenario Leveraging the Integrated Approach

Extreme Transaction Processing (XTP, Hekaton) – the solution to everything?

How Memory-Optimized Database Technology is Integrated into SQL Server 2014

SQL SERVER 2014 IN-MEMORY OLTP HEKATON USEFUL LINKS

SQL Server 2014: Pushing the Boundaries of In-Memory Performance

In-Memory OLTP: How Durability is Achieved for Memory-Optimized Tables

SQL Server 2014 CTP2 In-Memory OLTP Sample, based

Overview of the Different In-Memory OLTP Index Types

About James Serra

James is SQL Server MVP and a independent consultant with the title of Business Intelligence/Data Warehouse/Master Data Management Architect and Developer, specializing in the Microsoft SQL Server BI stack.
This entry was posted in SQL Server 2014, SQLServerPedia Syndication. Bookmark the permalink.

3 Responses to SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton

  1. Steven Neumersky says:

    Agree. The less time spent taxing the source system, the better. So much is going on in the MS BI stack, and I await the next edition of the MSDWH toolkit as there is so much more to cover. 2014 should give them a chance to catch their BI breath and update the next edition :)

  2. Pingback: SQL Server 2014 In-Memory OLTP (Hekaton) Limitations - SQL Server - SQL Server - Toad World

  3. Pingback: SQL Server 2014 In-Memory OLTP (Hekaton) Limitations | James Serra's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>