Updated: July 14, 2020 (December 23, 2013)

First Release of SQL Server In-Memory OLTP Shows Promise

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server 2014 In-Memory Online Transactional Processing (OLTP), code-named Hekaton, is a new set of SQL Server Enterprise edition database features that substantially improve transactional performance and offer the potential of creating real-time data analysis and summarization previously unattainable. The features use memory-resident tables and database technologies to take advantage of large memory and multicore processors. Existing recovery processes and most standard T-SQL commands are used with in-memory tables, which will help migration, but using the features may require data schema and application changes, which could hinder early adoption.

Case Studies Demonstrate Business Value

The most common types of database applications that will benefit from in-memory tables are highly transactional, where immediate response, real-time calculations, and performance are most important. The following examples are based on Microsoft case studies of business situations that benefit from in-memory table technology:

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now