Dell Compellent SC8000 Controller - Manual (Page 19)

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage
Page 16
Figure 7. Oracle TPC-C average response time (second) vs. user load
The blue lines in Figures 6 and 7 represent the results from the baseline configuration, in which no
storage tiering is implemented and all Oracle volumes reside on the 15K RPM SAS disk drives. The red
lines in these Figures represent the results from the tiered storage configuration, in which Data
Progression automatically moves data pages among the three storage tiers according to the access
frequency.
In a typical Oracle OLTP environment, 1 second application response time is generally acceptable.
Therefore, when analyzing the test results, an average transaction response time of 1 second was
chosen as the Service Level Agreement (SLA). All data beyond 1 second average transaction response
time was discarded from the analysis.
As illustrated in Figure 6, application throughput in TPS improves by implementing Dell Compellent
Data Progression as compared to a traditional configuration of placing all Oracle volumes on one type
of storage media. Figure 6 shows that for OLTP workload, moving active data set to the tier 1 SSD
drives can achieve higher throughput.
Figure 6 shows that Data Progression improves the Oracle database throughput by supporting higher
concurrent user loads while meeting the SLA at the same time. This is in line with the results shown in
Figure 5.
The baseline configuration without Data Progression supports 1600 concurrent users when it meets the
SLA of around 1 second response time. At the 1600 concurrent user load, the response time of the
baseline configuration is 0.819 second; the response time of the tiered configuration is 0.469 second.
0
1
2
3
4
100 300 500 700 900 1100 1300 1500 1700 1900 2100 2300 2500 2700 2900
Av
g.
Respo
n
se
T
ime
(s
)
User Load
Oracle TPC-C Response Time Comparison
Baseline
configuration
Tiered storage
configuration