Export (0) Print
Expand All

Managing Memory for In-Memory OLTP

SQL Server 2014

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 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft