White Paper

Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP
Workloads
iii
Contents
Executive summary ..................................................................................................... 5
Introduction .............................................................................................................. 5
Technology Overview................................................................................................... 6
Dell Compellent Fluid Data Architecture – feature description ............................................... 6
Built-in virtualization ............................................................................................... 6
Block-level data management ..................................................................................... 6
Data Progression ..................................................................................................... 7
Data Instant Replays................................................................................................. 8
Fast Track ............................................................................................................. 8
Test configuration ...................................................................................................... 9
Test methodology ..................................................................................................... 10
Test results and analysis ............................................................................................. 12
Summary ................................................................................................................ 15
References ............................................................................................................. 17
Appendix................................................................................................................ 17
Tables
Table 1. Hardware and software configurations ................................................................. 9
Table 2. Volume distribution in multiple tiers ................................................................. 11
Table 3. Results summary: performance, cost, and disk space usage ..................................... 16
Figures
Figure 1. Fluid Data Architecture ................................................................................... 6
Figure 2. Identifying very small data blocks that are eligible for movement ............................... 7
Figure 3. A Built-in migration engine provides hands-free management through tiering profiles ....... 7
Figure 4. Snapshot blocks are periodically moved to the lower tiers......................................... 8
Figure 5. Delivers optimal placement of data on each individual disk ....................................... 9
Figure 6. Test configuration architecture ....................................................................... 10
Figure 7. Average response time: Baseline vs. Fast Track enabled ......................................... 12
Figure 8. Average response time: Baseline vs. Fast Track enabled vs. Replay enabled ................. 13
Figure 9. Baseline disk space consumed vs. Replay enabled ................................................. 13
Figure 10. Average response time: Baseline vs. Auto-tiering features enabled ............................ 14