Dell PowerEdge R820 User Manual

Page 3 - Contents; Tables

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 3 Contents Executive summary ..................................................................................................... 5 Introduction ............................................................................

Page 6 - Summary of goals; Dell PowerEdge R820 architecture

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 6  Add more database servers by deploying more virtual machines (VM)  Virtualization offers better high availability with the help of VM migration Thus Oracle VM virtualization technology brings more value add in term...

Page 9 - Test configuration; Test environment architectural diagram

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 9 Once the data was populated, we started testing with 200 concurrent users and increased the user load to 5000 in increments of 200 users, randomly running transactions against the legacy database while making sure tha...

Page 10 - Hardware and Software configuration details; Performance metrics

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 10 Table 1 describes the complete software and hardware configuration that was used throughout testing on both the simulated legacy production environment and the 12G test environment. Hardware and Software configuratio...

Page 11 - Performance testing utility; Scale factor; Test methodology

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 11 Along with TPS and AQRT, CPU and memory utilization data were also collected during the testing. CPU utilization data is used to understand the saturation levels of the database server, and indicates how the server i...

Page 13 - Performance results and analysis; Legacy Power Edge 2950 results; AQRT of legacy production environment; Legacy PE 2950 III - AQRT vs Userload

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 13 9. As explained during the tests we collected multiple performance metrics. Following the completion of tests on all virtual machines we analyzed the results in terms of – AQRT, CPU utilization, TPS. Based on the ana...

Page 14 - Legacy PE 2950 III - TPS vs Userload

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 14 Figure 3 gives the snapshot of average query response time of the legacy production environment for different userloads. It can be observed that 4800 is the max userload supported within 2 sec SLA. Figure 4 is the CP...

Page 15 - PowerEdge R820 results; AQRT of R820 test environment; AQRT vs Userload of all VMs

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 15 PowerEdge R820 results AQRT of R820 test environment Figure 6. CPU Utilization of R820 test environment Figure 7. Figure 6demonstrates that all VM are scaling up to 5200 userload simultaneously with SLA below 2 sec. ...

Page 16 - TPS vs Userload of all VMs

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 16 TPS of R820 test environment Figure 8. Figure 8 gives a snapshot of the TPS across all four VMs for various userloads. It can be clearly seen that TPS delivered by all the VMs has been increasing continuously, this m...

Page 17 - Consolidated userload on R820 at 70% utilization; Comparison; TPS Comparison of legacy vs R820; Consolidated Userload at 70% utilization

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 17 Consolidated userload on R820 at 70% utilization Figure 10. Figure 9 show that all the VMs are supporting 5200 userloads. As the user stress tests on VMs are done in parallel, total consolidated userload supported by...

Page 18 - Supported Userload comparison of legacy vs R820; CPU utilization comparison of legacy vs R820; R820 vs legacy saturated Userload

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 18 Performance of 70% of R820 vs 2 x 2950 = ~4X Supported Userload comparison of legacy vs R820 Figure 12. Max userload supported by R820 at 70% utilization = 20800 Max userload supported by legacy Production system (2 ...

Page 19 - Consolidation factor; Power Consumption vs Userload

Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 19 Consolidation factor  8:1 Consolidation at 70% Utilization . Based on the preceding consolidation study, a PowerEdge R820 populated with 4 sockets can consolidate the workload of 8 Oracle RAC nodes running on 9th ge...