Parallel processing requires more memory than serial processing.
number or worker processes – sets the total number of worker processes available simultaneously in SAP ASE. Each worker process requires about the same amount of memory as a user connection.
default network packet size
stack size and stack guard size
user log cache size
memory per worker process – controls the additional memory that is placed in a pool for all worker processes. This additional memory stores miscellaneous data structure overhead and interworker process communication buffers.
memory per worker processes
number of mailboxes and number of messages
Each worker process makes its own copy of the query plan in space borrowed from the procedure cache. The coordinating process keeps two copies of the query plan in memory.