Dell Compellent SC8000 Controller - Manual (Page 17)

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage
Page 14
The volume distribution of the DATA volume shows that Data Progression effectively redistributes its
data pages to span on all three tiers. Data pages that are moved to tier 1 represent the most active
data pages that can benefit from the high performing SSD drives in the tier 1 storage. Data pages that
are moved to tier 3 represent less active data pages. Moving less frequently accessed data pages to
lower cost disk drives in tier 3 helps reduce the storage space in higher tiers and lower the total cost of
storage. Similarly, the volume distribution of the FRA volume shows that Data Progression redistributes
its data pages to tier 2 and tier 3 as defined in the storage profile.
Benchmark Factory TPC-C test, which consists of approximately 70% of read IOs and 30% of write IOs,
was conducted again on the tiered storage configuration after the redistributions of data pages by Data
Progression. The test simulated workloads from 100 to 3,000 concurrent users in an increment of 100.
The test result is compared with the baseline test result in the following section.
Test Results
Figure 6 shows the comparison of TPS between the baseline configuration and the tiered storage
configuration as user load increases. Figure 7 shows the comparison of average response time (second)
of each configuration as user load increases.