Transcript Row header Payload (table columns) 8 bytes * (IdxLinkCount – 1) Begin Ts 8 bytes End Ts StmtId IdxLinkCount 8 bytes 4 bytes 2 bytes.

Row header
Payload (table columns)
8 bytes * (IdxLinkCount – 1)
Begin Ts
8 bytes
End Ts
StmtId
IdxLinkCount
8 bytes
4 bytes
2 bytes
Hash index
on Name
R1
R3
Matching index record
R2
TX4: Begin = 210
Oldest Active Hint = 175
100
200
1
John
Smith
Kirkland
200
∞
1
John
Smith
Redmond
50
100
1
Jim
Spring
Kirkland
300
∞
1
Ken
Stone
Boston
0
100
Checkpoint File Pair
Data File
TS (ins)
TS (ins)
TS (ins)
TableId
TableId
TableId
RowId
RowId
RowId
Delta File
TS (ins)
TS (ins)
TS (ins)
TS (del)
TS (del)
TS (del)
RowId
RowId
RowId
Row pay load
Row pay load
Row pay load
DelDel
Tran1
(TS150) )
Tran1(TS150
Del Tran2
(TS 450)
Log in SQL
Table
DelTran3
Tran3
Del
(TS250)
250)
(TS
Insert into
Hekaton T1
Offline Checkpoint Thread
New Inserts
Range 500-
Delete 450 TS
Range 400-499
Range 300-399
Delete 250 TS
Range 200-299
Delete 150 TS
Range 100-199
SQL Transaction log
Memory-optimized Table Filegroup
Data file with rows generated in timestamp range
IDs of Deleted Rows (height indicates % deleted)
Memory-optimized Table Filegroup
Data file with rows generated in
timestamp range
Range 500-599
Range 400-499
Range 200-399
Range 300-399
Merge
200-399
Range 200-299
Files as of Time 600
Range 100-199
Range 400-499
Range 300-399
Range 200-299
Range 100-199
Files as of Time 500
Memory-optimized Table Filegroup
IDs of Deleted Rows (height
indicates % deleted)
Files Under Merge
Deleted Files
Memory
Optimized Tables
Delta map
Delta map
Delta map
Data
File1
Recovery Data
Loader
filter
Recovery Data
Loader
filter
Recovery Data
Loader
filter
Delta
File1
Data
File2
Delta
File3
Memory Optimized Container - 1
Data
File3
Delta
File2
Memory Optimized Container - 2
Checkpoint
Done
SQL
Server
exits
HK:
Table
T1
is loaded
Restarts
HK:
HK:
SQL
SQLProcess
Process
Restarts
Exits
HK:
Checkpoint
Done
SQL
SQLServer
Server
Process
SSQL
ServerProcess
Process
QL Server Process
Memory
Memory
Memory
T1
T1
T2
T3
HK
Windows
Azure
mva
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn