White Paper

Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP

Workloads

minutes with the same cost per GB. By enabling Compellent Data progression on the tiered storage, you

can achieve the same performance with a reduced cost per GB of 0.55$. By enabling the Compellent

auto-tiering, you can achieve lower cost per GB with improved performance.

From Figure 12, it is clear that by enabling Data Instant Replay, the total storage cost went down by 46

percent by moving the read-only data to the space efficient RAID 5 optimized for read operation. In

addition, by applying Data Progression on the tiered storage helped to reduce the total cost by 64

percent with sub-LUN tiering.

The above study concluded that Configuring Oracle OLAP database, with Dell Compellent Automated

Storage Tiering, the following benefits were achieved:

 With Fast Track enabled, there is a 23 percent improvement in performance.

 Compellent Auto Tiering helped to save disk space by 27 percent by moving read-only/inactive data

to a cost efficient RAID5-9 and RAID6-6 from RAID10.

 Compellent Auto Tiering helped to reduce the Tier 1 storage space by 70 percent by moving

infrequent accessed data to the lower tiers.

 Compellent Auto Tiering with data progression helped to reduced cost per GB by 51 percent

without compromising performance.

References

1. The Architectural Advantages of Compellent Automated Tiered Storage

http://www.compellent.com/~/media/www/Files/White_Papers/Dell_ATS_RR.ashx

2. Compellent Storage Center with Oracle Database

http://kc.compellent.com/Pages/Download.aspx?DocID=790

3. Oracle Best Practices on Compellent Storage Center, a Dell Technical whitepaper

Appendix

Below are the approximate costs used for calculating costs.

Type

Size(GB)

Usable Capacity(GB)

Price($)

15K RPM SAS

(3.5”)

450

419.19

475

10K RPM SAS

(2.5”)

450

419.19

350

7.2K RPM SAS

(2.5”)

1024

931.51

150