Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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:
Introduction to Memory-Optimized Tables
Details what memory-optimized tables are and provides information about data durability, accessing data in memory-optimized tables, and performance and scalability.
Native Compilation of Tables and Stored Procedures
Details how memory-optimized tables and natively compiled stored procedures are compiled into DLLs, and provides related security considerations.
Altering Memory-Optimized Tables
Guidelines for updating memory-optimized tables (including changing table columns, indexes, and bucket_count).
Understanding Transactions on Memory-Optimized Tables
This section provides several topics related to performing transactions on memory-optimized tables including transaction isolation levels, and cross-container transactions.
Application Pattern for Partitioning Memory-Optimized Tables
Detailed code sample that shows how to emulate partitioned tables when using memory-optimized tables.
Statistics for 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.
Table and Row Size in Memory-Optimized Tables
Details the 8060 byte limit on memory-optimized table rows, and provides an example for calculating table and row sizes.
A Guide to Query Processing for Memory-Optimized Tables
Provides an overview of query processing for both memory-optimized tables, and natively compiled stored procedures.