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