Server Memory

Sybase IQ allocates heap memory for buffers, transactions, databases, and servers. Shared memory may also be used, but in much smaller quantities.

At the operating system level, Sybase IQ server memory consists of heap memory. For the most part, you do not need to be concerned with whether memory used by Sybase IQ is heap memory or shared memory. All memory allocation is handled automatically. However, you may need to make sure that your operating system kernel is correctly configured to use shared memory before you run Sybase IQ.

Managing Multiplex Memory

Each server in the multiplex can be on its own host or share a host with other servers. Two or more servers on the same system consume no more CPU time than a single combined server handling the same workload, but separate servers might need more physical memory than a single combined server, because the memory used by each server is not shared by any other server.

Warning!  

Killing processes on UNIX systems may result in semaphores or shared memory being left behind instead of being cleaned up automatically. The correct way to shut down a Sybase IQ server on UNIX is the stop_iq utility,.

Related concepts
Paging Increases Available Memory
Utilities to Monitor Swapping
Manage Buffer Caches
Determine the Sizes of the Buffer Caches
Set the Buffer Cache Sizes
Specify the Page Size
Optimize for Large Numbers of Users
Platform-Specific Memory Options