Apply these general guidelines for loading and querying data.
The recommended minimum amount of memory (RAM) for running Sybase IQ under Windows is 512MB. For most applications 4GB is recommended for best performance. Set the /3GB and /PAE switches in the boot.ini to allow Sybase IQ to address as much memory as possible on Windows 32bit systems.
Excessive system page faulting results from overallocating the physical memory (RAM) of the machine. Excessive page faults severely degrade the performance of Sybase IQ. By carefully allocating Sybase IQ buffers, monitoring the virtual address space of the Sybase IQ process(es), and monitoring available physical memory, you can prevent memory overallocation. This section offers guidelines for monitoring Sybase IQ use of your machine's physical memory.
The amount of physical memory available to applications (Sybase IQ) is displayed under Physical Memory (K). If the Available value is consistently below 5000 it is possible the physical memory for the machine is overallocated. This is because at the 5000(K) mark, Windows produces page faults in order to maintain a minimum of 5MB of free memory.
To monitor physical memory, from Task Manager, select the Performance tab.