Wednesday, November 21, 2012

Hekaton – SQL Server’s in-memory database engine

http://blogs.technet.com/b/dataplatforminsider/archive/2012/04/09/the-coming-in-memory-database-tipping-point.aspx

Microsoft have just went 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:
  1. Main memory optimized tables which are decoupled from on-disk structures;
  2. Everything is lock and latch free;
  3. More work is pushed to compile time so your T-SQL code is compiled natively into low-level code.