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
gptkb:SQL_Server_Express_edition
all T-SQL features
gptkbp:designedFor high-throughput transactional workloads
gptkbp:enables high concurrency
gptkbp:features gptkb:Microsoft_SQL_Server
https://www.w3.org/2000/01/rdf-schema#label in-memory OLTP
gptkbp:improves transaction processing speed
gptkbp:introducedIn gptkb:SQL_Server_2014
gptkbp:persistsData transaction log and checkpoint files
gptkbp:purpose improve OLTP performance
gptkbp:reduces locking and latching overhead
gptkbp:requires sufficient RAM
gptkbp:storage main memory
gptkbp:supports natively compiled stored procedures
memory-optimized tables
gptkbp:uses row versioning for concurrency control
gptkbp:bfsParent gptkb:Azure_SQL_Database
gptkbp:bfsLayer 5