The virtual address space of a process is the total size of the process. The working set of a process is the amount of physical memory currently allocated to the process. In most cases, in order to avoid excessive system page faulting the virtual address space for the Sybase IQ process(es) should be less than the physical memory of the machine.
Due to the virtual memory usage pattern within the Sybase IQ server, virtual memory fragmentation could cause excessive process growth on Windows platforms. To reduce the likelihood of this situation, Sybase IQ supports the use of Microsoft's low-fragmentation heap (LFH) on Windows XP and Windows Server 2003.
Monitoring virtual address space and memory usage
Right-click an empty space on the taskbar, choose Task Manager, then click the Processes tab.
Click View, choose Select Columns.
On the Select Columns dialog, choose these columns:
Memory usage
Memory usage delta
Peak memory usage
Page faults
Page faults delta
Virtual memory size
