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 Memory Requirements for Memory-Optimized Tables||Estimate a table’s memory needs.|
|Bind a Database with Memory-Optimized Tables to a Resource Pool||Step by step walkthrough to bind a database with a resource pool.|
|Monitor and Troubleshoot Memory Usage||Tools you can use to monitor your memory usage. Also covers troubleshooting if memory usage gets too high.|
|Resolve Out Of Memory Issues||Steps to recover from an OOM (Out of Memory) situation.|
|Restore a Database and Bind it to a Resource Pool||Steps to restore an In-Memory OLTP database and bind it to a named resource pool.|
|In-Memory OLTP Garbage Collection||Understand how garbage collection operates on deleted rows.|