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...