Chapter 11. In-Memory OLTP - Why and How to Use it
Performance is crucial for every system's success and it's the same for SQL Server. However, as data contention grows all over the world, the traditional method of continuous algorithm tuning and improving from version to version becomes an insufficient approach. Since 2010, Microsoft has been working on a completely new approach of data processing called Hekaton. The first version was present on SQL Server 2014 as the In-Memory OnLine Transactional Processing (OLTP) feature. It offers new frontiers for developers and administrators to design and maintain very fast applications and also breaks many limits of traditional disk-based data processing.
In this chapter, we will explore:
- In-Memory OLTP architecture: A top-level overview of how it works and what's needed for successful implementation
- Creating In-Memory tables and natively compiled stored procedures: This section will provide an overview of how to create In-Memory tables and how to...