Considerations in Storage Management Decisions

The system administrator must make many decisions regarding the physical allocation of space to SAP ASE databases.

The major considerations are:

Recovery – disk mirroring and maintaining logs on a separate physical device provide two mechanisms for full recovery in the event of physical disk failures.
Performance – for tables or databases where speed of disk reads and writes is crucial, properly placing database objects on physical devices yields performance improvements. Disk mirroring slows the speed of disk writes.

Recovery
Recovery is the key motivation for using several disk devices. You can ensure full recovery by storing a database’s log on a separate physical device. You can also mirror database devices to achieve nonstop recovery.
Performance
You can improve system performance by placing logs and database objects on separate devices.

Parent topic: Disk Resource Issues

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com