Chapter 10: 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 to 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 speedy applications and also break many limits of traditional disk-based data processing.
In this chapter, we will have a top-level overview ...
Get SQL Server 2019 Administrator's Guide - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
