As a SQL Server enthusiast, I recently attended the SQL Server (PASS) Summit 2012 and was thrilled to learn about a new feature called “Hekaton” that will be included in the upcoming version of SQL Server. This feature has the potential to revolutionize the performance of database applications.
Hekaton, which means “hundreds” in Greek, is aptly named for its ability to significantly speed up database functions. While it may not achieve a 100x improvement as initially speculated, it does offer a remarkable 10x increase in application speed and nearly 50x improvement for new, optimized applications.
So, how does Hekaton work? It provides in-application memory storage for the most frequently accessed tables in SQL Server. With the help of a new tool, developers can identify these tables and store them in the system’s main memory, resulting in faster access times. The remaining data will still be stored in the traditional manner.
One of the key advantages of Hekaton is its ability to optimize queries and procedures. It achieves this by compiling T-SQL stored procedures in native code, allowing the entire system to run faster. This approach is similar to other products like Oracle, xVelocity, or even Microsoft’s own PowerPivot and Power View. However, the key difference is that Hekaton is built directly into SQL Server, eliminating the need for additional extensions, downloads, or interfaces that can potentially slow down the system.
Currently, Hekaton is being tested by a select group of developers, but it is expected to be available for all users in the new version of SQL Server, which is anticipated to be released in 2014 or 2015.
With Hekaton, SQL Server users can expect significant performance improvements, especially for applications that heavily rely on database operations. The ability to store frequently accessed tables in memory and compile stored procedures in native code will undoubtedly enhance the overall speed and efficiency of SQL Server.
Stay tuned for more updates on the new version of SQL Server and the exciting features it will bring!