Hekaton and Bwtree makes the next version of SQL Server super fast


The next version of SQL Server due to release in 2014/2015 is code named hekaton. Hekaton in greek means hundreds and is expected to speed up database performance by 30X times without code changes to existing applications or hardware.

Hekaton stores most frequently accessed tables in Memory. A new tool which is being in-built within SQL Server will help identify tables that are most frequently accessed.

This is similar to the concept in PowerPivot, x-Velocity, Tabular models in BISM where everything is stored in memory.

The other performance enhancer is Bwtree, which is latch based. 

Bwin (largest regulated online trading company) one of our esteemed clients increased its through put 10 times when in trial runs.

 

Comments (8)
  1. Ajay Muralidhar says:

    Had not heard about Hekaton… thanks a ton Deepthi. Helpful as always…

  2. Hi Deepthi,

    DBCC PINTABLE was introduced in SQL Server version 6.5 which does not flush the pages of the pinned table from memory .This feature was later removed . DBCC PINTABLE which looks very similar to enhancement (stores most frequently accessed tables in Memory) in Hekaton ,What is the internal changes done to bring this feature back in Hekaton.

  3. Sathyanarayana – SQL 14 is lock and latch free apart from holding tables in memory which makes  big difference. Await from details on the same

  4. Peter says:

    "The other performance enhancer is Bwtree, which is latch based."  Really?

    this is from MSFT research:

    "Our new form of B-tree, called the Bw-tree achieves its very high performance via a latch-free approach that effectively exploits the processor caches of modern multi-core chips. …."

  5. Hi Deepthi,

    Thanks for your reply.! ! will wait to get more and detailed information on Hekaton .

  6. Column Store Indexes are updateable in SQL 2014

  7. Product Guides for SQL 2014 are now available. For details please check – blogs.msdn.com/…/microsoft-sql-14-ctp1-product-guide.aspx

  8. Really? says:

    The next version of SQL Server due to release in 2014/2015 is code named hekaton. – Really?

    Hekaton is just code name for one part of sql engine.

Comments are closed.

Skip to main content