Information on creating cache for in-memory or relaxed durability databases.
The cache name cannot be longer than 127 bytes.
The minimum size of in-memory storage cache is 256 logical pages (512K on a server using 2K logical pages).
Include the strict or relaxed replacement strategies for in-memory storage. By default, sp_cacheconfig uses a replacement strategy of none for in-memory storage cache.
Create large I/O pools for in-memory storage cache (in-memory databases do not perform I/O). The SAP ASE server issues an error if you use sp_poolconfig to create buffer pools an in-memory storage cache.
Change the cache type from mixed to logonly, or vice-versa.