Consolidating distributed environments offers less cluster overhead, simplifies management and IT, and reduces complexity in data centers. Learn about tools and efficient practices that can help you consolidate an Oracle® database running online transaction processing (OLTP) workloads on energy-intensive Real Application Cluster (RAC) nodes to fewer, faster and more efficient nodes using the Dell™ PowerEdge™ R720 server. Learn how to choose an appropriate database solution that can help optimize total cost of ownership (TCO) according to the database workloads you run.
Twelfth-generation PowerEdge R720 rack servers enable you to consolidate distributed legacy environments, which can help maximize the efficiency of server resources, thus minimizing the infrastructure, associated power and cooling, rack footprint, and licensing costs.
The performance of legacy systems processing OLTP workloads on PowerEdge 2950 III was compared with results of processing on PowerEdge R720. Workloads were established using Quest Software® Benchmark Factory®, a load-generating utility that simulates OLTP environment and transactions on a database for a given number of users. The simulation focused on the following parameters:
- Transaction per second (TPS)
- Average query response time (AQRT)
- Processor utilization
- Memory utilization
- Power consumption
Review results of the performance testing and comparative analysis, including the following options possible for consolidating Oracle workloads on RAC nodes running on 9th-generation PowerEdge 2950 III legacy servers onto a single PowerEdge R720 server:
- 2:1 consolidation — two workloads on a single-node Oracle Database 11g R2 RAC running on a PowerEdge R720 server populated with one socket at 42 percent utilization
- 4:1 consolidation — three to four workloads on Oracle RAC nodes running on a PowerEdge R720 server at 90 percent utilization (The environments must have sufficient host memory and I/O (input/output) disk subsystems for this consolidation.)
- 8:1 consolidation — six to eight workloads on Oracle RAC nodes running on a PowerEdge R720 server with two sockets
Environments with PowerEdge R720 servers can deliver optimized performance with fewer nodes. The Dell enterprise portfolio integrates better-performing, more energy-efficient and more highly available products.