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.
