Managing Memory for In-Memory OLTP
When running In-Memory OLTP, SQL Server will need to be configured with sufficient memory to hold all your memory-optimized tables. If available memory is insufficient transactions will fail at run-time during any operations that require additional memory. Normally this would happen during INSERT or UPDATE operations, but could also happen for DELETE operations on a memory-optimized nonclustered index if the DELETE generates a page merge operation which, if you recall from the discussion previously in this chapter, requires allocating additional pages.
If the system runs out of memory during memory-optimized table transactions and you cannot add more memory to the SQL Server instance, you may have to drop some ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
