Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads This Dell technical white paper discusses performance and cost benefits achieved with Dell™ Compellent™ Automated Tiering technology for Oracle® OLAP workloads.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads This document 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. © 2012 Dell Inc. All rights reserved. Dell and its affiliates cannot be responsible for errors or omissions in typography or photography. Dell, the Dell logo, and PowerEdge are trademarks of Dell Inc.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Contents Executive summary ..................................................................................................... 5 Introduction .............................................................................................................. 5 Technology Overview...................................................................................................
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Figure 11. Disk Space Consumed Tier wise distribution ........................................................ 15 Figure 12. Total storage cost comparison .........................................................................
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Executive summary Data growth in the Enterprise world is enormous. In the traditional system, to achieve high performance needs, all the data must reside in the high performing disks irrespective of the access pattern. However, all the data residing in these disks may not be accessible all the time as a result high performing disks are used inefficiently.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Technology Overview Dell Compellent Fluid Data Architecture – feature description Dell Compellent created an enterprise storage solution that automates the movement and management of data throughout its life cycle with Fluid Data Architecture. Fluid Data Architecture enables true storage virtualization, providing a single pool of storage resources that spans across all disks and RAID levels.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Figure 2. Identifying very small data blocks that are eligible for movement Data Progression Data Progression automatically classifies and migrates data to the optimum tier of storage, retaining frequently accessed data on high performance storage and storing infrequently accessed data on lower cost storage.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Data Instant Replays Dell Compellent Data Instant Replay technology plays a key role in delivering outstanding performance in an automated tiered storage environment. Data Instant Replay protects data without wasting capacity. You create space-efficient snapshots (Replays) of changes in data for continuous protection from loss or corruption.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Figure 5. Delivers optimal placement of data on each individual disk Test configuration A two-node Oracle 11gR2 Real Application Cluster (RAC) was deployed for the database configuration in this paper. The following hardware and software components were used for the cluster setup. Table 1.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Component Details Volume Configuration 3 X OCRVOTE - 2GB Control files - 3GB Online Redo log - 4GB DATA - 700GB FRA - 700GB The architecture overview of the test configuration is shown in Figure 6 Figure 6.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Replay, and Data Progression to find how the Compellent Fluid Architecture helps in auto-tiering resulting in performance improvements and cost benefits. The test methodology used is as follows: 1.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Test results and analysis As explained in the test methodology, we used the Quest benchmark TPC-H tool with 500 GB of data loaded. After loading the data, the total size of all database volumes was around 950GB including FRA. Initially, we started testing the OLAP database on a single tier (SAS15K RPM) with Data Progression, Data Instant Replay, and Fast Track disabled.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Figure 8. Average response time: Baseline vs. Fast Track enabled vs.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads In the above graph we observed that after enabling Data Instant Replay, the data migrated to RAID 5-9 from RAID 10. Moving this read-only data from RAID 10 to RAID 5-9 within the same tier enables to maintain the same read performance and frees up space on the RAID level. In the Baseline test, without enabling Replay, the disk space consumed for all volumes is 1.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Figure 11. Disk Space Consumed Tier wise distribution Disk Space Consumed Disk Space Consumed(TB) 2 1.8 1.6 1.4 1.2 Tier3(7.2K SAS) 1 Tier2(10K SAS) 0.8 Tier1(15K SAS) 0.6 0.4 0.
Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP Workloads Table 3. Results summary: performance, cost, and disk space usage Disk space saved in Tier1 Total cost($) Cost per GB($) Aver. response time (min) All in T1 -NA- 2147 1.13 448 1.85 TB All in T1 -NA- 2147 1.13 345 1.13 TB All in T1 737 GB 1312 1.13 344 1.60 TB 770 0.
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.