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 sameAnonymous
June 06, 2013
The comment has been removedAnonymous
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 2014Anonymous
June 20, 2013
Product Guides for SQL 2014 are now available. For details please check - blogs.msdn.com/.../microsoft-sql-14-ctp1-product-guide.aspxAnonymous
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.