White Papers

43 Sizing and Best Practices for Online Transaction Processing Applications with Oracle 11g R2 using Dell PS Series | BP1003
8 Conclusion
Based on the tests explained in sections 5.1 through 5.4, the key findings while comparing performance of
PS6010S and 6010XV arrays are summarized in the following.
 A 7x IOPS performance increase was measured for the PS6010S over the PS6010XV for 100% read
8K block I/O.
 The PS6010S can sustain a 4x IOPS performance increase over the PS6010XV at the 20ms disk
latency threshold (16,000 compared to 4,000) for 70/30 read/write workloads.
 For block sizes as large as 64K, the single PS6010S array still provided a 3.3x performance increase
over the PS6010XV.
The ORION I/O simulation tests and the TPC-E tests using Quest Benchmark Factory (executed with different
array capacity utilization) illustrated the benefits of having both SSDs and 10K SAS HDDs. providing
performance and as well as sufficient capacity needed by typical OLTP database applications. The Vdbench
test results clearly demonstrated how the built-in internal tiering intelligence can help improve the database
performance over time.
Optimal database performance can be achieved when the applicable best practices laid out in this paper are
adhered to. It must be ensured that the entire ecosystem, including server resources and network switches,
are sized and configured appropriately to meet the workload performance requirements. It also must be
ensured that the operating system and databases are configured with the optimal settings and design
recommendations mentioned in this paper.