Execute sp_configure, specifying “Memory Use,” to see the parameters associated with memory use on Adaptive Server.
sp_configure "Memory Use"
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 this is more than 200.
Some of the values in this list are computed values. They cannot be set directly with sp_configure, but are reported to show where memory is allocated. Among the computed values is total data cache size.
