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)