Managing Memory for In-Memory OLTP
Memory-optimized tables require that sufficient memory exist to keep all of the rows and indexes in memory. Because memory is a finite resource, it is important that you understand and manage memory usage on your system. The topics in this section cover common memory use and management scenarios.
Estimate a table’s memory needs.
Step by step walkthrough to bind a database with a resource pool.
Tools you can use to monitor your memory usage. Also covers troubleshooting if memory usage gets too high.
Steps to recover from an OOM (Out of Memory) situation.
Steps to restore an In-Memory OLTP database and bind it to a named resource pool.
Understand how garbage collection operates on deleted rows.