Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 454 / 536

Overview of memory use
434
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.