© Benjamin Nevarez 2021
B. NevarezHigh Performance SQL Serverhttps://doi.org/10.1007/978-1-4842-6491-1_7

7. SQL Server In-Memory Technologies

Benjamin Nevarez1  
(1)
Santa Clarita, CA, USA
 

This chapter covers in-memory databases along with some other new technologies and paradigms that radically depart from the traditional disk-based rowstore architecture and query processing algorithms that most relational databases have been using for a few decades now. Current relational databases were architected back in the late 1970s, when hardware was totally different from what it is today, and databases were too large to fit in memory and assumed to be kept on disk. In addition to faster processors and declining memory cost, memory capacity in current hardware ...

Get High Performance SQL Server: Consistent Response for Mission-Critical Applications 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.