How to set up in memory database?

Image

Overview

Many client systems have for a number of years used "in memory" or "private" databases for the engine/app layers. Private ( in memory) databases can be used for the engine and application layer databases which are effective static between releases. Private ( in memory ) databases allow for many performance enhancements and reduces downtime when upgrading servers.  Private databases should not be used for data layers ( ones that we want to keep data between releases).