IBM SAN Volume Controller Performance (SVC) Configuration Guidelines for Implementing Oracle Databases with Automatic Storage Management (ASM)

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.

SVC_Config_Guidelines_for_Oracle_ASM

Enjoy

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s