In-Memory Database

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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

APPLIES TO: yesSQL Server (Linux only) noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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.