Use sp_cacheconfig to increase the size of an in-memory storage cache at runtime. For example, to increase the size of imdb_cache to 3GB, enter:
sp_cacheconfig imdb_cache, '3G', inmemory_storage
You can reduce the size of an in-memory storage cache using the same procedure. You can reduce the size of the in-memory storage cache only by the amount of space on the cache that is currently unused by an in-memory database—in other words, the in-memory storage cache cannot be smaller than the in-memory database.
A reduced cache size is created when you restart the server.
