Sybase 12.4.2 manual Platform-specific memory options, 434

Overview of memory use

Within the "proc:" section of this file you must update max-threads-per-user.

For example:

proc:

:

.

max-threads-per-user = 9000

Since this count is on a per user basis (not a per process basis) this number must be high enough to allow for all threads of all processes running under the Sybase user ID.

Platform-specific memory options

On all platforms, Adaptive Server IQ uses memory for four primary purposes:

•Main buffer cache

•Temporary buffer cache

•Thread stacks

•Load buffers

See Figure 12-1: Buffer caches in relation to physical memory earlier in this chapter for a diagram of IQ memory use.

The HP UNIX and AIX platforms limit the total amount of memory available to IQ or any other single application. You must set IQ server options on these platforms in order to gain the maximum usable memory.

The total amount of usable memory varies by platform. See the following table for details.

434