Dell PowerVault MD1120 User Manual

Page 33

A REFERENCE GUIDE FOR OPTIMIZING DELL™ POWERVAULT™ MD1XXX FAMILY SAS SOLUTION

VER A02

PAGE 33

6/16/2008

Online Transaction Processing (OLTP) oriented servers are used in a number of industries for the
entry and retrieval of transactions. For example, OLTP is common in banking, airlines, mail-order,
and supermarkets. These servers are generally critical and require maximum availability and
redundancy.

Table 14: Database or OLTP General IO profile

I/O Profile
(Read/Write)

I/O Profile
(Sequential/Random)

Bandwidth

I/O
Size

Latency
Sensitivity

Growth
Rate

Criticality

80/20

Random

Moderate 8k Moderate Low High

Table 15: OLTP RAID Guidelines

Application

RAID Level

OLTP

Recommended

Not Recommended

Possible

Recommended:

• RAID 10 – Since OLTP systems are critical for most business, this RAID configuration is

highly recommended because of the high availability and redundancy and good
performance.

• RAID 5 – Recommended for OLTP servers that require maximum storage capacity and

moderate data protection and performance.

• RAID 6 – Recommended for OLTP servers that require maximum storage capacity,

enhanced data protection, and moderate performance.

• RAID 50 – Recommended for those solutions that require a balance between storage

capacity and performance.

• RAID 60 – Recommended for those solutions that require a balance between storage

capacity and performance with maximum data protection.

Possible:

•

RAID 1 – Possible solution for situations which do not require high storage capacity.

Not recommended:

•

RAID 0, Concatenated - These are not recommended because of the lack of
redundancy and data protection.

Note: While these configurations are not recommended, they can be configured and
used.

Table 16: OLTP Enclosure Guidelines

Application

Enclosure

MD1000

MD1120