In-Memory OLTP

GPTKB entity

Statements (21)
Predicate Object
gptkbp:instanceOf relational database management system
gptkbp:alsoKnownAs gptkb:Hekaton
gptkbp:compatibleWith gptkb:SQL_Server_2014_and_later
all T-SQL features
gptkbp:developedBy gptkb:Microsoft
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:improves transaction throughput
gptkbp:introducedIn gptkb:SQL_Server_2014
gptkbp:persistsData to disk for durability
gptkbp:purpose improve OLTP performance
gptkbp:reduces locking and latching overhead
gptkbp:storage in system memory
gptkbp:supports natively compiled stored procedures
memory-optimized tables
gptkbp:targetUser high-concurrency OLTP workloads
gptkbp:uses multi-version concurrency control
hash and range indexes
gptkbp:bfsParent gptkb:Azure_SQL_Managed_Instance
gptkbp:bfsLayer 6