Kbase P56106: How should I locate my data, bi and after image extents when using RAID.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/05/2009 |
|
Status: Verified
GOAL:
How should I locate my data, bi and after image extents when using RAID.
GOAL:
Where should I locate my data, bi and after image extents when using RAID.
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
OpenEdge Database Category: Performance
FIX:
There is no prescribed method for extent positioning of files when you are using RAID 0 or RAID 10.
The same statement can be made for RAID 5 however RAID 5 is not recommended for use with any database that has anything beyond light amount of creates, updates or deletes.
The normal recommendation would be to reduce disk IO contention and typically with RAID this will be provided by the RAID.
If you do not have sufficient spindles within your RAID set then your disks will become overly busy and will not perform well.
If the RAID set has become overly busy, saturated, either add more disks to the RAID disk set (may require removal of all data from the stripe set) or create an additional stripe set.
As long as there are sufficient spindles all database files could reside on one stripe set.
For safety sake it would be advisable to have the stripe set mirrored.