Viewing the Configuration Parameters for Memory

Issue the Memory Use configuration parameter to view the parameters associated with memory use on SAP ASE.

A “#” in the Memory Used column indicates that this parameter is a component of another parameter and that its memory use is included in the memory use for the other component. For example, memory used for stack size and stack guard size contributes to the memory requirements for each user connection and worker process, so the value is included in the memory required for number of user connections and for number of worker processes, if they are set to more than 200.

Some of the values from the Memory Use output are computed values. You cannot set them using sp_configure, but are reported to show where memory is allocated. Among the computed values is total data cache size.