Troubleshooting

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage
Page 17
As illustrated in Figure 8, using Data Progression to move active data sets in OLTP applications from SAS
disks to SSD disks can reduce transaction response time by 43 percent.
Figure 1. Dell Compellent Data Progression reduces transaction response time
of Oracle OLTP workload
While meeting the SLA of around 1 second response time, the baseline configuration is able to deliver
TPS of 80.96; the tiered configuration delivers TPS of 115.96. Based on these data, we can conclude
that Dell Compellent Data Progression improves throughput in TPS of OLTP applications by 43 percent
as compared to the baseline configuration, by moving active data set to tier 1 SSD drives. This is
illustrated in the Figure 9 below.
0.819
0.469
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
Baseline configuration Tiered storage configuration
Response Time (s)
Response Time Reduction
43%
Figure 8. Dell Compellent Data Progression reduces transaction response time of
Oracle OLTP workload