| title | Managing Memory for In-Memory OLTP | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 06/13/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | in-memory-oltp |
| ms.topic | conceptual |
| ms.assetid | d82f21fa-6be1-4723-a72e-f2526fafd1b6 |
| author | stevestein |
| ms.author | sstein |
| manager | craigg |
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.
| Section | Description |
|---|---|
| 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 [!INCLUDEhek_2] database and bind it to a named resource pool. |
| In-Memory OLTP Garbage Collection | Understand how garbage collection operates on deleted rows. |