Transactions and Memory-Optimized Tables
As described previously in the sections describing the in-memory data row and index structures, SQL Server In-Memory OLTP uses row-versioning to determine which row versions are visible to which transactions. This is accomplished by maintaining an internal Transaction ID that serves the purpose of a timestamp. The timestamps are monotonically increasing every time a transaction commits. A transaction’s start time is the timestamp in the database at the time the transaction starts. When the transaction commits, it generates a new timestamp, the Global Transaction Timestamp, which is used to uniquely identify that transaction. Timestamps are used to specify the following:
Commit/End Time—The distinct point ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
