In-Memory OLTP – Common Workload Patterns and Migration Considerations

Summary: In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. For performance critical workloads, users can also migrate Transact-SQL code to natively compiled stored procedures. This can provide additional performance gains. This paper aims to help readers understand some of the common architectural patterns where In-Memory OLTP has provided significant benefits. The paper also discusses considerations for migrating applications to In-Memory OLTP.

Authors: Mike Weiner, Ami Levin (SolidQ)

Contributers: Shep Sheppard

Technical Reviewers: Sunil Agarwal, Carl Nolan, David Schwartz, Yorihito Tada, Lindsey Allen, Jos de Bruijn, Jamie Reding, Denzil Ribeiro, Rama Ramani, George Li, Emanual Rivera, Rick Kutschera (BWin.party), Sanjay Mishra, Michael Steineke (Edgenet)

Published: July 2014

Applies to: SQL Server 2014

To review the document, please download the In-Memory OLTP – Common Workload Patterns and Migration Considerations Word document.

Ask a question in the SQL Server Forums
Send Feedback