If you are running on Windows, make sure the Network Services Server option “Maximize Throughput for Network Applications” is enabled. Enabling this option ensures that the NTFS cache does not steal memory from Sybase IQ and cause excessive page faulting, particularly in memory-constrained environments.
To enable Maximize Throughput for Network Applications:
From the Control Panel, double click on the Network Services Server icon.
Select the Services tab and double click on the Server network service.
Click on the option “Maximize Throughput for Network Applications”.
Click OK twice and reboot the machine.
