Managing System Resources

Tuning your hardware and software configuration provides better performance and faster queries.

• Optimize Memory Use
  Understanding how Sybase IQ allocates memory can help you get the best performance from your system.
• The Process Threading Model
  Sybase IQ uses operating system kernel threads for best performance. By default, Sybase IQ allocates the number of threads based on the number of CPUs on the system.
• Balancing I/O
  Discusses disk striping, random and sequential file disk access, and ways to control the size of the message log file.
• Options for Tuning Resource Use
  Tune your resources for faster query execution.
• Other Ways to Improve Resource Use
  There are several ways to adjust your system for maximum performance or better use of disk space.
• Managing Database Size and Structure
  Database size depends largely on indexing and data quantity. Create indexes for faster queries. Drop unnecessary objects to free disk space and shorten load times.
• Network Performance
  Minor changes in your environment can solve some network performance issues.