| title | In-Memory Database | Microsoft Docs | |||
|---|---|---|---|---|
| ms.date | 05/22/2019 | |||
| ms.prod | sql | |||
| ms.prod_service | database-engine | |||
| ms.reviewer | ||||
| ms.technology | ||||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | 11f8017e-5bc3-4bab-8060-c16282cfbac1 | |||
| author | briancarrig | |||
| ms.author | brcarrig | |||
| manager | amitban |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
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.
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
Hybrid Buffer Pool allows the database engine to directly access data pages in database files stored on Persistent Memory (PMEM) devices.
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
[!INCLUDEsql-server-2019] 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.
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]
In-Memory OLTP is the premier technology available in [!INCLUDEssNoVersion] and [!INCLUDEssSDS] for optimizing performance of transaction processing, data ingestion, data load, and transient data scenarios.
Applies to: [!INCLUDEssSQL14] to [!INCLUDEssNoVersion].
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-linuxonly]
[!INCLUDEsqlv15] adds support for Persistent Memory (PMEM) devices to Linux, providing full enlightenment of data and transaction log files placed on persistent memory.
Applies to: [!INCLUDEsqlv15] to [!INCLUDEssNoVersion].