Readers of this blog will know that I recently attended SQL Server (PASS) Summit 2012. There were, of course, a lot of fascinating subjects and people, but let me talk about one of my favorites right now. Ted Kummert, corporate vice president of the Data Platform group at Microsoft, announced that the new version of SQL Server will include a feature called “Hekaton.” Hekaton is Greek for “hundreds,” and it was given this name for its ability to speed up database function 100x (possibly). It certainly increases application speed by 10x and nearly 50x for new, optimized applications.
Hekaton works by providing in-application memory storage for the most often used tables in SQL Server. With a new tool that will be available in the new version of SQL Server, it will help identify tables that are most accessed, and will store them in the system’s main memory for faster access time. The rest of the data will still be stored in the traditional manner. The whole system will optimize queries and procedures, with Hekaton compiling T-SQL stored procedures in native code, so that the whole system runs faster.
Some eagle-eyed readers will see that this is very similar to other products that are currently available – like Oracle, xVelocity, or even Microsoft’s own PowerPivot and Power View. However, the biggest difference is that Hekaton is built directly into SQL Server, so that there are no extensions, downloads, or interfaces that can slow down the very program meant to help increase your speed.
Hekaton is currently being tested by a few very lucky developers, but will be available for all users in the new version of SQL Server, which is expected in 2014 or 2015.
Reference: Pinal Dave (https://blog.sqlauthority.com)