Restricting Concurrent Queries

Set the -iqgovern switch to specify the number of concurrent queries on a particular server. This is not the same as the number of connections, which is controlled by your license.

There is an optimal value for -iqgovern that will provide the correct number of concurrent query access to provide optimal throughput. If -iqgovern is set over this threshold, contention or resourse starvation occurs, slowing down all requests.

By specifying the -iqgovern switch, you can help SAP Sybase IQ optimize paging of buffer data out to disk, and avoid over committing memory. The default value of -iqgovern is (2 x the number of CPUs) + 10. You may need to experiment to find an ideal value. For sites with large numbers of active connections, try setting -iqgovernslightly lower.

Related concepts
Optimizing for Typical Usage
Optimizing for Large Numbers of Users
Limiting Query Temp Space
Limiting Queries by Rows Returned
Forcing Cursors to be Non-Scrolling
Limiting the Number of Cursors
Limiting the Number of Statements
Prefetching Cache Pages
Controlling the Number of Prefetched Rows
Controlling File System Buffering
Optimizing the Cache Partitions