Troubleshooting

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage
Page 18
Figure 9. Dell Compellent Data Progression improves application throughput in TPS of
Oracle OLTP workload
From this study of configuring Oracle databases with Dell Compellent Data Progression, we may
conclude the following:
 Dell Compellent automated storage tiering Data Progression reduces transaction response time
by 43 percent as compared to a non-tiered configuration in OLTP workload by moving active
data sets to the top tier SSD disk drives.
 Dell Compellent automated storage tiering Data Progression improves TPS by 43 percent as
compared to a non-tiered configuration in OLTP workload by moving active data sets to the top
tier SSD disk drives.
Summary
The Dell Compellent sub-LUN tiering solution Data Progression can cost-effectively address the
explosive data growth of Oracle databases, while delivering more superior performance for OLTP
applications. This paper demonstrates these benefits through lab testing. It also discusses the best
practices for deploying automated storage tiering in an OLTP environment using Data Progression.
To learn more about Dell Oracle solutions, visit www.dell.com/oracle or contact your Dell
representative for up-to-date information on Dell servers, storage, and services for Oracle solutions.
References
1. Oracle Best Practices on Compellent Storage Center, a Dell technical white paper.
80.96
115.96
0
20
40
60
80
100
120
140
Baseline configuration Tiered storage configuration
TPS
TPS Improvement
43%