[email protected] SQL Server 2014 adds in-memory technology to boost performance of OLTP workloads.
Download ReportTranscript [email protected] SQL Server 2014 adds in-memory technology to boost performance of OLTP workloads.
[email protected] SQL Server 2014 adds in-memory technology to boost performance of OLTP workloads Memory Usage and Management On Disk Storage for Durability Row header Payload (table columns) 8 bytes * (IdxLinkCount – 1) Begin Ts 8 bytes End Ts StmtId IdxLinkCount 8 bytes 4 bytes 2 bytes Timestamps Hash index on Name 50, ∞ Chain ptrs Name Jane City Prague 100, ∞ John Prague 90,150 ∞ 90, Susan Bogota Hash index on City 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) RowId RowId RowId TableId TableId TableId TS (ins) TS (ins) TS (ins) RowId RowId RowId TS (del) TS (del) TS (del) Delta File Row pay load Row pay load Row pay load DelDel Tran1 (row TS150)) Tran1(TS150 Del Tran2 (TSTS 450) (row 450) Log in disk Table Del Tran3 (row 250) (TSTS 250) Insert into Insert into T1 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 data 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 data Filegroup IDs of Deleted Rows (height indicates % deleted) Files Under Merge Deleted Files Memory Optimized Tables Recovery Data Loader filter Recovery Data Loader filter Recovery Data Loader filter Delta map Delta map Delta map Data File1 Delta File1 Data File2 Delta File2 Memory Optimized Container - 1 Data File3 Delta File3 Memory Optimized Container - 2 http://channel9.msdn.com/Events/TechEd www.microsoft.com/learning http://microsoft.com/technet http://microsoft.com/msdn