Creating Devices for In-Memory and Relaxed Durability Databases

Considerations for creating devices for in-memory and relaxed durability databases.

  • The logical name of the in-memory device cannot be the same as the name of the cache on which a device is created.

  • In-memory devices are reserved for the first in-memory database you assign to it.

  • You must use the physical device name as the logical name of the in-memory device.

  • The logical name of the in-memory device must be unique across all devices.

  • You cannot:
    • Use these parameters when you create an in-memory device: vstart, cntrltype, dsync, directio, and skip_alloc.

    • Create an in-memory device that is larger than the cache on which it is created.

    • Create an in-memory device from a regular named cache, including the default data cache.

    • Increase the size of an in-memory device once it is created. However, you can use sp_cacheconfig to increase the size of the in-memory cache, and use disk init to create new in-memory devices.

    • Use these commands against in-memory devices: disk resize, disk mirror, disk remirror, disk unmirror, disk refit, and disk reinit.

    • Use the sp_deviceattr and sp_diskdefault system procedures on disk devices.