White Papers

17 Sizing and Best Practices for Online Transaction Processing Applications with Oracle 11g R2 using Dell PS Series | BP1003
Key findings from the test results are summarized as follows:
 For 100% read I/O with an 8K block size, the PS6010S array sustained a maximum of approximately
34,000 IOPS.
 For 70/30 read/write I/O with an 8K block size, the PS6010S array sustained a maximum of
approximately 16,000 IOPS.
 At the maximum IOPS level measured for the PS6010XV array before exceeding the 20 ms disk
latency threshold (4,047), the disk latency for the PS6010S array at the same IOPS level was < 2 ms.
5.3 PS6110XS hybrid array test
PS6110XS arrays offer high performance and large usable capacity due to the unique combination of SSD
and 10K SAS drives within the same chassis. The array performance in a specific OLTP environment
depends on a number of factors including amount of data stored on the array, frequency of access, and most
importantly, the locality of data reference.
First, I/O profiling tests were run using ORION to establish baseline I/O performance characteristics of the
storage array under test at different capacity configurations.
Next, the Vdbench I/O generation tool was used for simulating frequently accessed data with a specific
locality as observed in a typical database environment. The ORION tool was not appropriate for this study
because it does not provide an option to specify locality of data reference.
The tests listed in Table 2 were run with an 8K I/O block size and at increasing queue depths (number of
outstanding I/Os) to determine the maximum IOPS the storage array would sustain within the 20 ms latency
(read and write latencies were measured separately).
The configuration parameters for the tests are shown in Table 2.
Test parameters: I/O workload studies
Configuration parameters
PS Series SAN
PS6110XS (7 x 400GB SSD, 17 x 600GB 10K SAS drives)
Test configuration #1
ORION (1TB array capacity utilization, 100% random I/O locality)
I/O mix: 8K 70/30 read/write (simulate TPC-C)
Test configuration #2
ORION (2TB array capacity, 100% random I/O locality)
I/O mix: 8K 70/30 read/write (simulate TPC-C)
Test configuration #3
ORION (4TB array capacity,100% random I/O locality)
I/O mix: 8K 92/8 read/write (simulate TPC-E)
Test configuration #4
Vdbench (2TB array capacity, 20% random I/O locality)
I/O mix: 70/30 read/write (simulate I/O with 20% I/O locality)
RAID type
RAID 6 Accelerated