High Performance SQL Server: Consistent Response for Mission-Critical Applications

© 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 Nevarez¹  

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