Performance Baseline for Deploying Oracle 11g R2-Based Decision Support Systems Using Dell EqualLogic PS6110XV Arrays User Guide
Summary
Optimize your Oracle 11g Decision Support System deployments with Dell EqualLogic PS6110XV arrays. This comprehensive technical report provides essential performance baselines, detailing test results and best practices for integrating large DSS workloads successfully. Covering simulated I/O tasks, throughput scaling, and direct database testing, the guide is designed for system architects and infrastructure engineers planning mission-critical enterprise deployments requiring robust, scalable storage solutions.
Page 1 Text Content
Dell Equal Logic Best Practices Series
Performance Baseline for Deploying Oracle® 11g Release 2 Based Decision Support Systems using Dell™ Equal Logic™ PS6110XV Arrays A Supplemental Test Report
Base White paper: Sizing and Best Practices for Deploying Oracle 11g Release 2 Based Decision Support Systems using Dell Equal Logic PS6110XV Arrays A Dell Technical White paper http://en.community.dell.com/dell-groups/dtcmedia/m/mediagallery/20059328/download.aspx
Storage Infrastructure and Solutions Engineering Dell Product Group May 2012
Page Summary Contents For Performance Baseline for Deploying Oracle 11g R2-Based Decision Support Systems Using Dell EqualLogic PS6110XV Arrays User Guide
Page 1
Dell Equal Logic Best Practices Series Performance Baseline for Deploying Oracle® 11g Release 2 Based Decision Support Systems using Dell™ Equal Logic™ PS6110XV Arrays A Supplemental Test Report Base ...
Page 2
THIS TEST REPORT IS FOR INFORMATIONAL PURPOSES ONLY, AND MAY CONTAIN TYPOGRAPHICAL ERRORS AND TECHNICAL INACCURACIES. THE CONTENT IS PROVIDED AS IS, WITHOUT EXPRESS OR IMPLIED WARRANTIES OF ANY KIND. ...
Page 3
Table of Contents 1 Introduction ..........................................................................................................................................................................
Page 4
Acknowledgements This whitepaper was produced by the PG Storage Infrastructure and Solutions of Dell Inc. The team that created this whitepaper: Chidambara Shashikiran, Chhandomay Mandal, and Camille ...
Page 5
1 Introduction This paper provides a summary of results for tests executed using Equal Logic PS6110XV arrays. These tests were set up the same as and run in addition to the set of test scenarios descr...
Page 6
2 DSS I/O simulation 2.1 Test methodology A subset of I/O simulation tests were executed with large sized I/O block requests simulating a DSS database I/O to understand the read and write I/O throughp...
Page 7
The following chart compares the throughput produced by PS60110XV and PS6110XV arrays in RAID 10 configuration. Figure 1 ORION I/O throughput in RAID10 configuration: PS6010XV versus PS6110XV PS6110XV...
Page 8
2.3.2 PS6010XV and PS6110XV – RAID 50 The four ORION I/O workload scenarios described earlier were executed on a PS6110XV array and the results were compared with a PS6010XV array. The storage arrays ...
Page 9
2.3.3 PS6110XV – RAID 10 versus RAID 50 The four ORION workloads described earlier were executed on a PS6110XV array in RAID 10 and in RAID 50. The I/O throughout reported by ORION for both configurat...
Page 10
2.3.4 PS6110XV scaling studies The four ORION workloads described in section 2.2 were executed on PS6110XV arrays using RAID 50. The storage pool was configured with one array initially and then scale...
Page 11
concat option. Executing the ORION tool with this option is like running any other I/O workload simulator like VDBench or IOMeter. The following chart summarizes the performance scalability results us...
Page 12
3 DSS application simulation 3.1 Simulation tool and workload definition Additional DSS tests were conducted to understand the throughput behavior of the PS6110XV arrays when the Oracle Real Applicati...
Page 13
As seen in the bar graph in Figure 6, both the average and maximum throughput scaled linearly with the number of arrays. The throughput from PS6110XV arrays was significantly higher compared to the PS...
Page 14
Figure 7 Storage I/O throughput – I/O (ORION) and application simulation The following table shows the percentage of increase in throughput on the PS6110XV array configuration when DSS simulation test...
Page 15
The I/O throughput across storage array members, as reported by Equal Logic SAN HQ in the two-array configuration, is shown in Figure 8. Figure 8 Storage I/O throughput – SAN Head Quarters The initial...
Page 16
3.2.1.3 Query Completion Time The end-to-end completion time for all 22 queries submitted by the five simulated users is shown in Figure 10 below. The duration is between the time when the first query...
Page 17
4 Conclusion Equal Logic 10 Gb E i SCSI PS Series arrays provide high levels of I/O throughput warranted by DSS. By adding arrays, PS Series scale not only capacity but also I/O throughput as well. Th...
Page 18
THIS TEST REPORT IS FOR INFORMATIONAL PURPOSES ONLY, AND MAY CONTAIN TYPOGRAPHICAL ERRORS AND TECHNICAL INACCURACIES. THE CONTENT IS PROVIDED AS IS, WITHOUT EXPRESS OR IMPLIED WARRANTIES OF ANY KIND.
Manual Details
| Brand | BASELINE |
|---|---|
| Pages | 18 |
| File Size | 825.14 KB |
| Published | May 16, 2026 |
81 views
Enter the captcha to get the download link:
Frequently Asked Questions
How does PS6110XV perform versus older models like PS6010XV?
On PS6110XV arrays, the I/O throughput was significantly higher than a PS6010XV setup, resulting in over a 30% decrease in query completion time.
Is horizontal and vertical scaling possible for DSS databases?
Yes, both horizontal and vertical scaling were observed when adding additional array members or increasing servers in the RAC database configuration.
What simulation setting ensures linear throughput for ASM striping?
To ensure that large sequential read/write throughput scales linearly when simulating Oracle ASM striping behavior using ORION, you must use the 'concat' option, not the RAID 0 option.