Hardware issues that impact SAP Sybase IQ
performance.
Setting the Number of CPUs Available
Set the -iqnumbercpus startup switch to specify the number of CPUs available. This parameter overrides the physical number of CPUs for resource planning purposes.
The Process Threading Model
SAP Sybase IQ uses operating system kernel threads for best performance. By default, SAP Sybase IQ allocates the number of threads based on the number of CPUs on the system.
Network Performance
Minor changes in your environment can solve some network performance issues.
Created December 19, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com