In-Memory Database is an umbrella term for the features within SQL Server that leverage in-memory based technologies. As new in-memory based features are developed this page will continue to be updated.
Hybrid Buffer Pool
Hybrid Buffer Pool allows the database engine to directly access data pages in database files stored on Persistent Memory (PMEM) devices.
Memory-Optimized TempDB Metadata
SQL Server 2019 (15.x) introduces a new feature that is memory-optimized tempdb metadata, which effectively removes some contention bottlenecks and unlocks a new level of scalability for tempdb-heavy workloads.
In-Memory OLTP is the premier technology available in SQL Server and SQL Database for optimizing performance of transaction processing, data ingestion, data load, and transient data scenarios.
Applies to: SQL Server 2014 (12.x) to SQL Server.
Persistent Memory Support for Linux
SQL Server 2019 (15.x) adds support for Persistent Memory (PMEM) devices to Linux, providing full enlightenment of data and transaction log files placed on persistent memory.
Applies to: SQL Server 2019 (15.x) to SQL Server.