March 2018
Intermediate to advanced
816 pages
19h 35m
English
System-versioned temporal tables are also supported for memory-optimized tables. You can assign or let SQL Server create a history table for your memory-optimized table. The history table must be a disk table, but this is exactly what you want; frequently used (hot) data remains in memory, while cold data can reside in disk tables. By taking this approach, you can use all the benefits provided by memory-optimized tables (high transactional throughput, lock-free concurrency), save their historical data on disk-based tables, and leave memory for active datasets only. The following figure shows the architecture of system-versioned memory-optimized tables. It is taken from the Books Online page at ...