User Guide
SAP AG November 2002
• Data volumes [Page 130]
If you wish to ensure a high standard of availability, we recommend using RAID-5 or
RAID-1 configurations for the data area [Page
131]. A disk crash and change will then
not affect the running of the database, if the RAID system is able to carry out a
recovery.
Every volume category should be stored on a different disk.
When using fault-tolerant hardware, it is best to only use the same type of hardware when
you want to extend the capacity. For example, RAID-5 systems should only be extended
using RAID-5 systems and mirroring disks with mirroring disks.
UNIX: In a production system, data volumes and log volumes should be used in conjunction
with raw devices. In the event of a system crash, raw devices are extremely secure.
Performance Requirements
For performance reasons, each of the different types of volume [Page 153] should be stored
on a different disk. Therefore, create data volumes [Page 130] and log volumes [Page 144] on
different disks. Because all changes to the database instance are logged in the log areas
[Page 142] , it is the log volumes for a database instance [Page 132] that see the most write
activity.
When RAID-5 systems are used, the database instance should be configured with several
data volumes. Performance will be better with many data volumes than with a single one,
because some parallel mechanisms used by the database system depend on the number of
configured data volumes.
For performance reasons, the log volumes must not be created on RAID-5 systems but only
on dedicated disks or RAID-1 systems.
If swap or paging areas and log entries are kept on the same disk, performance will be
negatively affected.
UNIX: Raw devices should be used for the data volumes and log volumes, because
accessing to data in raw devices is generally quicker than accessing data in files.
Example Configuration
... 03
... 03
DB data
DISKD01
... 02
... 02
Data
Data
Volume
Volume
DISKD01
DISKD01
... A5
... A5
DB data
DISKD01
... A2
... A2
Log
Log
Volume
Volume
DISKLA1
DISKLA1
... B5
... B5
DB data
DISKD01
... B2
... B2
Mirrored
Mirrored
Log
Log
Volume
Volume
DISKLB1
DISKLB1
User Manual: SAP DB 69