In-memory OLTP

GPTKB entity

Statements (23)
Predicate Object
gptkbp:instanceOf Database technology
gptkbp:alsoKnownAs gptkb:Hekaton
gptkbp:benefit High throughput
Low latency transactions
gptkbp:compatibleWith gptkb:SQL_Server_Management_Studio
gptkb:SQL_Server_Express_Edition
gptkbp:documentation https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/in-memory-oltp-overview
gptkbp:features gptkb:Microsoft_SQL_Server
https://www.w3.org/2000/01/rdf-schema#label In-memory OLTP
gptkbp:introducedIn gptkb:SQL_Server_2014
gptkbp:limitation Limited index types
Some T-SQL features not supported
No foreign key constraints referencing memory-optimized tables
gptkbp:purpose Improve transaction processing performance
gptkbp:reduces Locking and latching overhead
gptkbp:requires gptkb:64-bit_SQL_Server
gptkbp:supports Durability
High concurrency
Non-durable tables
gptkbp:uses Memory-optimized tables
Natively compiled stored procedures
gptkbp:bfsParent gptkb:SQL_Server
gptkbp:bfsLayer 5