Managing Memory with the Resource Governor
In SQL Server 2014, you can use the Resource Governor to manage the amount of memory available for in-memory databases and objects. You can bind a database with memory-optimized table(s) databases to a resource pool, assign the desired amount of memory to the pool and that will be the maximum amount of memory available to memory-optimized objects in that database.
The first step is to create a resource pool for the In-Memory OLTP database, specifying a MIN_MEMORY_PERCENT and MAX_MEMORY_PERCENT of the same value. This will ensure that this fixed percentage of available memory is always available for the In-Memory OLTP database.
CREATE RESOURCE POOL InMemPool WITH (MIN_MEMORY_PERCENT ...
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.
