Monitoring and Tuning Performance

Describes the tools you use to determine whether your system is making optimal use of available resources.

• Viewing the Sybase IQ Environment
  The first step in tuning Sybase IQ performance is to look at your environment.
• Monitoring Performance Statistics
  Use Performance Monitor in Sybase Central to display statistics for simplex and multiplex servers. Statistics display in a dynamic chart in real time.
• Monitoring the Buffer Caches
  Buffer cache performance is a key factor in overall performance. Buffer cache monitor logs buffer cache, memory, and I/O statistics.
• Buffer Cache Structure
  Changing the CACHE_PARTITIONS value may improve load or query performance in a multi-CPU configuration.
• Avoid Buffer Manager Thrashing
  Thrashing occurs when the system must write a dirty page before it can read a requested page, which drastically slows down the system. For optimum performance, always allocate enough free memory to allow the page writers to keep up with the free space demand.
• Buffer Cache Monitor Checklist
  Review this checklist to adjust cache behavior that falls outside the normal range.
• System Utilities to Monitor CPU Use
  OS-specific utilities are available to monitor CPU usage