Monitoring Cache Space

Check data cache and procedure cache space with the total data cache size configuration parameter.

Another way to determine how SAP ASE uses memory is to examine the memory-related messages written to the error log when SAP ASE starts. These messages state exactly how much data and procedure cache is allocated, how many compiled objects can reside in cache at any one time, and buffer pool sizes.

These messages provide the most accurate information regarding cache allocation on SAP ASE. The amount of memory allocated for the procedure caches depends on the run value of the procedure cache size configuration parameter.

Each of these error log messages is described below.