Home > ASE, Developement, Start Sybase, Sybase ASE/REP Interview Questions > Guidelines for improving I/O performance

Guidelines for improving I/O performance

The major guidelines for improving I/O performance in Adaptive Server are as follows:

• Spreading data across disks to avoid I/O contention.

• Isolating server-wide I/O from database I/O.

• Separating data storage and log storage for frequently updated databases.

• Keeping random disk I/O away from sequential disk I/O.

• Mirroring devices on separate physical disks.

• Partitioning tables to match the number of physical devices in a segment.

Check the Sybase Wiki @
  1. No comments yet.
  1. No trackbacks yet.