Tuning Servers on 32-bit Windows Systems

Refer to the tuning guidelines to optimize performance on Windows 32-bit systems.

• General Performance Guidelines
  Apply these general guidelines for loading and querying data.
• Monitoring Performance
  Use Sybase IQ Performance Monitor, Windows Task Manager, and the Windows Performance tool to monitor system performance.
• NTFS Cache
  Use the NTFS cache to improve performance for inserts and queries.
• Inserts and Queries
  Well-tuned Sybase IQ insert operations exhibit certain characteristics. You can observe these characteristics from the Windows Task Manager and the Windows Performance tool.
• Backup Operations
  Set the BLOCK FACTOR close to the maximum block size to optimize backup operations.