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