SQL Server In-Memory OLTP helps improve performance of OLTP applications through efficient, memory-optimized data access, native compilation of business logic, and lock- and latch free algorithms. The In-Memory OLTP feature includes memory-optimized tables and table types, as well as native compilation of Transact-SQL stored procedures for efficient access to these tables.
For more information about memory-optimized tables, see:
Details what memory-optimized tables are and provides information about data durability, accessing data in memory-optimized tables, and performance and scalability.
Details how memory-optimized tables and natively compiled stored procedures are compiled into DLLs, and provides related security considerations.
Guidelines for updating memory-optimized tables (including changing table columns, indexes, and bucket_count).
This section provides several topics related to performing transactions on memory-optimized tables including transaction isolation levels, and cross-container transactions.
Detailed code sample that shows how to emulate partitioned tables when using memory-optimized tables.
Details how statistics are compiled for memory-optimized tables and how to maintain and manually update statistics for memory-optimized tables.
Details the restrictions on supported collations and code pages for memory-optimized tables.
Details the 8060 byte limit on memory-optimized table rows, and provides an example for calculating table and row sizes.
Provides an overview of query processing for both memory-optimized tables, and natively compiled stored procedures.