Creating Cache for In-Memory or Relaxed Durability Databases

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

  • You cannot:
    • 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.