Dell Compellent SC8000 Controller- User Manual

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 3 Introduction Today’s storage devices come in many choices ranging from high performance and high cost storage devices such as the flash memory-based Solid State Drives (SSD), to slower performance and less expensive s...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 4 expensive SATA drives in tier 3. However, assigning data to a particular storage tier may be an ongoing and complex activity which may take a lot of time and effort from the administrators if it is done manually. Auto...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 5 For more information concerning Dell Solutions for Oracle Database, visit www.dell.com/oracle . Technology overview Dell Compellent Automated Tiered Storage – Data Progression The Dell Compellent Storage Center Storag...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 6 Figure 2. Dell Compellent Automated Tiered Storage - Data Progression Unlike many newcomers to the storage tiering market, Dell Compellent Data Progression is built right into the virtualized storage platform. It real...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 7 Data migration occurs automatically at a set time or on demand. The migration process does not affect data availability or application performance. Dell 12 th Generation PowerEdge Servers Dell 12 th Generation PowerEd...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 8 Oracle Databases with Dell Compellent Data Progression Dell Compellent Data Progression is configured by assigning Storage Profiles to volumes. Storage Profiles define the RAID level and storage tiers on which data bl...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 9 users. The database configuration used in the tests was a 2-node Oracle 11 g R2 (11.2.0.3) Real Application Cluster (RAC). The database schema was populated by Benchmark Factory. The TPC-C test runs conducted simulate...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 10 Table 1. Hardware and software configurations for Benchmark factory test HARDWARE AND SOFTWARE CONFIGURATIONS FOR BENCHMARK FACTORY TEST Server Two PowerEdge R720 servers, each with: • Two Intel Xeon 8-core 2.20 GHz ...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 12 2,200 concurrent users in an increment of 100. Test metrics include transaction per second (TPS) and average transaction response time in seconds. Test results are discussed in the Test Results section below. Enablin...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 13 levels. Figure 5 shows the new volume distribution of the same database volumes illustrated in Figure 4. Figure 5. Volume distribution of the tiered storage configuration created by Data Progression

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 16 Figure 7. Oracle TPC-C average response time (second) vs. user load The blue lines in Figures 6 and 7 represent the results from the baseline configuration, in which no storage tiering is implemented and all Oracle v...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 17 As illustrated in Figure 8, using Data Progression to move active data sets in OLTP applications from SAS disks to SSD disks can reduce transaction response time by 43 percent. Figure 1. Dell Compellent Data Progress...

Optimizing an Oracle Database with Dell Compellent Automated Tiered Storage Page 18 Figure 9. Dell Compellent Data Progression improves application throughput in TPS of Oracle OLTP workload From this study of configuring Oracle databases with Dell Compellent Data Progression, we may conclude the fol...