Effect of configuration on I/O activity

The configuration of your database server affects I/O activity.

The following factors affect I/O activity:

  • The assignment of chunks and dbspaces can create I/O hot spots, or disk partitions with a disproportionate amount of I/O activity.
  • Your allocation of critical data, sort areas, and areas for temporary files and index builds can place intermittent loads on various disks.
  • How you configure read-ahead can increase the effectiveness of individual I/O operations.
  • How you configure the background I/O tasks, such as logging and page cleaning, can affect I/O throughput.