Figure 3 – Dell Compellent SC8000 Controller User Manual

Page 12

Advertising
background image

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage

Page 9

users. The database configuration used in the tests was a 2-node Oracle 11g R2 (11.2.0.3) Real
Application Cluster (RAC). The database schema was populated by Benchmark Factory. The TPC-C test
runs conducted simulated loads from 100 to 3,000 concurrent users in an increment of 100. Test
outputs include metrics such as the average transaction response time and transaction per second
(TPS).

The test configuration consists of the following components:

PowerEdge R720 servers running Oracle Enterprise Linux 5 Update 7 x86_64, and Oracle 11g R2
Real Application Cluster (RAC) database Enterprise Edition (EE) version 11.2.0.3.0

Redundant Dell PowerConnect™ Gigabit Ethernet switches for Oracle cluster interconnect
private network

Server-storage interconnect using redundant Brocade® 5300 Fibre Channel switches

Redundant Dell Compellent Series 40 controllers

Dell Compellent SBOD Fibre Channel enclosure populated with 8 SSD drives for tier 1 storage

Dell Compellent 2.5’’ SAS enclosure populated with 24 15K RPM SAS drives for tier 2 storage

Dell Compellent 3.5’’ SAS enclosure populated with 12 7K RPM SAS drives for tier 3 storage

An architecture overview of the test configuration is shown in Figure 3.

Figure 3.

Configuration architecture of Oracle RAC database and Dell Compellent

storage system

The hardware and software details of the test configuration are summarized in Table 1.

Advertising