Dell Compellent Series 40 - Manual (Page 11)

Cost and Performance benefits of Dell™ Compellent™ Automated Tiered Storage for Oracle® OLAP
Workloads
11
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. To simulate the traditional SAN storage, we configured a single tier ( 12 X 15K SAS drives ) on
the Dell Compellent storage and deployed Oracle database volumes such as OCRVOTE, DATA,
FRA , Control file, and Redo logs . We used Benchmark Factory to load 500GB of data and
stressed the database using TPC-H to gather the query response time and the disk space usage
on the storage.
2. To obtain the benefits of the Compellent Fast Track feature, we enabled Fast Track by
applying the license on the Storage Center. We performed multiple Quest Benchmark Factory
TPC-H runs to move the frequently accessed blocks to the outer sector of the disk to get the
optimum performance. We then gathered the query response times and the disk space usage on
the storage.
3. We applied the Data Instant Reply profile (Daily once expires in 3 days) for the database
volumes and performed multiple Quest Benchmark factory TPC-H runs to find out the cost
savings and performance benefits by moving the read only data to the RAID 5-9, and gathered
the query response time, and the disk space usage on the storage.
4. We introduced additional two tiers, Tier 2 Storage (5 X SAS 10K disks) and Tier 3 storage (6 X
SAS 7.2 K Disks) to the existing system and applied the below mentioned storage profiles to the
database volumes.
Storage Profile1 (Tier1 RAID10, Tier1 RAID5-9): For OCR, Redo logs and control files
Storage Profile2 (Tier1 RAID10, Tier1 RAID5-5 and Tier2 RAID5-5): For DATA
Storage Profile3 (Tier1 RAID10, Tier3 RAID6-6): For FRA
Volume distribution in multiple tiers Table 2.
We performed multiple Quest Benchmark factory TPC-H runs to find out how Compellent Auto-tiering
helps to distribute the database volumes across different tiers based on the IO pattern and observed
how it helps to reduce cost and improve performance.
Writeable Data Replay Data
Tier1 RAID 10 OCR, Redo logs, Control files,
DATA and FRA
RAID 5-9 OCR, Redo logs, Control
files and DATA
Tier2 RAID 10
RIAD 5-5 DATA
Tier3 RAID 10
RIAD 6-6 FRA