Dell Compellent SC8000 Controller - Manual (Page 4)

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage
Page 1
Contents
Executive summary ....................................................................................................... 2
Introduction ................................................................................................................ 3
Dell solutions for Oracle database ..................................................................................... 4
Technology overview ..................................................................................................... 5
Dell Compellent Automated Tiered Storage – Data Progression ................................................ 5
Dell 12 th Generation PowerEdge Servers ........................................................................... 7
Oracle Databases with Dell Compellent Data Progression ......................................................... 8
Test tools and configurations ........................................................................................... 8
Baseline configuration without Data Progression ............................................................... 10
Enabling Data Progression and simulating read-only workload ............................................... 12
Tiered storage configuration with Data Progression ........................................................... 12
Test Results............................................................................................................... 14
Summary .................................................................................................................. 18
References ................................................................................................................ 18
Figures
Figure 1. Architecture of the tiered storage infrastructure .................................................... 3
Figure 2. Dell Compellent Automated Tiered Storage - Data Progression ................................... 6
Figure 3. Configuration architecture of Oracle RAC database and Dell Compellent storage system ... 9
Figure 4. Volume distribution of the baseline configuration without Data Progression ................. 11
Figure 5. Volume distribution of the tiered storage configuration created by Data Progression ...... 13
Figure 6. Oracle TPC-C Transaction per second (TPS) vs. user load ....................................... 15
Figure 7. Oracle TPC-C average response time (second) vs. user load ..................................... 16
Figure 8. Dell Compellent Data Progression reduces transaction response time of Oracle OLTP
workload ............................................................................................................ 17
Figure 9. Dell Compellent Data Progression improves application throughput in TPS of Oracle OLTP
workload ............................................................................................................ 18
Tables
Table 1. Hardware and software configurations for Benchmark factory test ............................ 10
Table 2. Oracle volume placement with Data Progression .................................................. 12