IBM SAN Volume Controller Performance (SVC) Configuration Guidelines for Implementing Oracle Databases with Automatic Storage Management (ASM)Posted: 05/01/2011
This paper discusses some performance configuration guidelines that can be used when deploying IBM® System Storage™ SAN Volume Controller (SVC) for use in an Oracle Automatic Storage Management environment.
It attempts to answer some fundamental configuration questions that System Administrators, Storage Administrators, or Oracle DBAs will have when deploying an SVC for Oracle with ASM. The backend storage used with SVC will be an IBM® System Storage™ DS8000®.
Therefore the white paper “IBM DS8000 Performance Configuration Guidelines for Implementing Oracle Databases with Automatic Storage Management” (item 5 in the References) should be considered a companion piece to this white paper and will be referenced throughout.
The load generator used to arrive at the configuration guidelines is ORION – the Oracle I/O Numbers Calibration tool.
This tool generates I/O using the same I/O software stack used by the Oracle server software without having to install the server software and create a database. It can simulate various workload types at different load levels to arrive at performance metrics for I/Os per second (IOPS), Latency (Response Time) and Megabytes per second (throughput).
It can also simulate the effect of striping performed by ASM. This paper is not meant as a statement of maximum possible I/O benchmark numbers for SVC. Those numbers are stated in the Storage Performance Council SPC-1 and SPC-2 results posted by IBM on the SPC Web site. Rather, this paper runs controlled experiments on a given set of hardware where only one variable is changed at a time; for example, change the RAID arrays from RAID-5 to RAID-10 while the rest of the SAN configuration stays constant.
Thus conclusions can be drawn regarding the effect that changing one configuration item has on performance.