Understanding SQL Server Buffer Cache vs Memory

Unlikestandardtables,memory-optimizedtablesrequireaspecialfilegrouptohandledurability(checkpointfiles).Eventhoughthedataisinmemory,weneedaplaceondisktostorethetransactionlogssowedon’tlosedataifthepowergoesout。參考影片的文章的如下：

In-Memory OLTP in SQL Server 2017
In-Memory OLTP in SQL Server 2017
In Memory OLTP SQL Server 2017 en Ubuntu Server
In Memory OLTP SQL Server 2017 en Ubuntu Server
SQL Server 2016
SQL Server 2016
How to Evaluate if SQL 2016 In-Memory OLTP is Right ...
How to Evaluate if SQL 2016 In-Memory OLTP is Right ...
How to Create a SQL Server In-Memory OLTP-Enabled Database
How to Create a SQL Server In-Memory OLTP-Enabled Database
SQL Server - Performance
SQL Server - Performance
SQL Server 2017: Adaptive Query Processing
SQL Server 2017: Adaptive Query Processing
Troubleshoot high memory utilization in SQL Server
Troubleshoot high memory utilization in SQL Server
SQL Server Diagnostic Memory Queries
SQL Server Diagnostic Memory Queries
In-Memory (Hekaton) enhancements in SQL Server 2016 CTP
In-Memory (Hekaton) enhancements in SQL Server 2016 CTP

參考內容推薦

SQL Server In Memory Tables

Unlike standard tables, memory-optimized tables require a special filegroup to handle durability (checkpoint files). Even though the data is in memory, we need a place on disk to store the transaction logs so we don’t lose data if the power goes out

memoryoptimizedtable

Unlikestandardtables,memory-optimizedtablesrequireaspecialfilegrouptohandledurability(checkpointfiles).Eventhoughthedataisinmemory,weneedaplaceondisktostorethetransactionlogssowedon’tlosedataifthepowergoesout

參考資訊如下