Configuring memory for caches

Memory is the most important consideration when you are configuring Adaptive Server. Memory is consumed by various configuration parameters, the procedure cache, statement cache, and data caches. Setting the values of the various configuration parameters and the caches correctly is critical for good system performance.

What remains after all other memory needs have been met is available for the procedure and statement cache, and the data cache. Figure 3-5 shows how memory is divided.

Figure 3-5: How Adaptive Server uses memory

Image shows a vertical view of how ASE Replicator uses memory. Starting from the bottom the levels are: Total physical memory, data cache, data cache overhead, procedures cache, statement cache, Kernel and server structures, static overhead, Adaptive Server executable, and OS and other programs.