Hekaton – SQL Server’s in-memory database engine

Published 07 November 12 03:38 PM | Christian

Microsoft have just gone public at the PASS Summit in Seattle about a new SQL Server engine that they’re working on which is optimized for high-memory servers – an in-memory OLTP database engine which is built-in to SQL Server rather than a separate entity.  This means that you can move just the performance critical parts of your database to Hekaton.

The new engine really pushes the performance boundaries by eliminating as many instructions as possible:

  • Main memory optimized tables which are decoupled from on-disk structures;
  • Everything is lock and latch free;
  • More work is pushed to compile time so your T-SQL code is compiled natively into low-level code.

We’re already working with a customer on an early adoption program so expect to hear from us on what we learn about implementing it!

 

Christian Bolton - MCA, MCM, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services

Comments

# Christian said on November 7, 2012 07:22 PM:

Read more about Microsoft's entry into the in-memory database market from David Campbell, Technical Fellow at Microsoft here: blogs.technet.com/.../the-coming-in-memory-database-tipping-point.aspx