SQL Server 2014: What is Hekaton?

The Hekaton is a new database engine, also known as SQL Server In-Memory OLTP. Hekaton collaborates with Microsoft Research and was released with Microsoft SQL Server 2014.

The Hekaton is a Greek word and meaning is 100 because this newly launched in-memory database is 100 times faster than the existing SQL Server engine.

You can visit this article,

Database Theory: What is In-memory Database?

If we look at traditional RDBMS system in which memory resource were very expensive and it was optimized for disk storage.

The Hekaton allows us to work with memory-optimized tables and indexes which are entirely stored in main memory and still we can access via T-SQL like other normal tables.

We can also create a stored procedure by adding the “WITH NATIVE_COMPILATION” clause that only reference to memory optimized tables.

The Hekaton eliminates logical locks using automatic SNAPSHOT ISOLATION with multi-versioning, also have a lock free and latch free structures to access all data.

How Hekaton is differ than SQL Server standard relational engine?

Very simple answer,

SQL Server standard relational engine developed basically for those data which resides on disk and it reads and writes 8 KB per data pages to store them into the extents. This process requires lots of CPU I/O and memory.

With memory-optimized tables, there are not any data pages and extents. It stores only the data rows into memory with index pointer.

This engine also supports MVCC (Multiversion Concurrency Control) in which same data row has may be different version at a single time so last updated version accessible by last most requests.

Because of MVCC nature, there is no blocking in Hekaton engine.

What is MVCC?

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com

Leave a Reply

1 Comment on "SQL Server 2014: What is Hekaton?"

Notify of
Sort by:   newest | oldest | most voted

Thank anvesh, This is very useful.