Allocate approximately 2K additional memory per secure connection. The value of the max total_memory configuration parameter specifies the amount of memory that Adaptive Server requires at start-up. For example, if your server uses 2K logical pages, and if you expect the maximum number of secure connections occurring at the same time to be 150, increase the max total_memory parameter by 150, which increases memory allocation by 150 2K blocks.
The syntax is:
sp_configure “max total_memory”, value
For example, if Adaptive Server requires 75,000 2K blocks of memory, including the increased memory for network-based security, execute:
sp_configure "max total_memory", 75000
For information about estimating and specifying memory requirements, see the Chapter 18, “Configuring Memory.”
