Managing Memory for In-Memory OLTP


Applies To: SQL Server 2016

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

In-Memory OLTP (In-Memory Optimization)