다음을 통해 공유

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

  • Anonymous
    April 21, 2013
    Had not heard about Hekaton... thanks a ton Deepthi. Helpful as always...

  • Anonymous
    May 25, 2013
    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.

  • Anonymous
    May 30, 2013
    Sathyanarayana - SQL 14 is lock and latch free apart from holding tables in memory which makes  big difference. Await from details on the same

  • Anonymous
    June 06, 2013
    The comment has been removed

  • Anonymous
    June 08, 2013
    Hi Deepthi, Thanks for your reply.! ! will wait to get more and detailed information on Hekaton .

  • Anonymous
    June 13, 2013
    Column Store Indexes are updateable in SQL 2014

  • Anonymous
    June 20, 2013
    Product Guides for SQL 2014 are now available. For details please check - blogs.msdn.com/.../microsoft-sql-14-ctp1-product-guide.aspx

  • Anonymous
    July 04, 2013
    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.