I/O considerations

It is critical to have a well-tuned I/O system. RAID is preferred, but at the very least, logs must be physically separated from data on separate disks and controllers. If applicable to your DBMS, the system catalog table space should also be isolated on separate disks. In general, try to spread the database across as many disks as possible to minimize I/O wait.

For high volume/high traffic environments, RAID 5 is not recommended for the transaction log or for temporary data storage.
Was this page helpful? Yes No Submitting... Thank you

Comments