Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM This technical whitepaper describes how the Dell PowerEdge R820 server can be used for consolidating Oracle databases. The Dell PowerEdge 12th generation R820 is a 2U server supporting 4 sockets and 1.5 TB of memory which makes it a best fit for virtualization environments.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM This document is for informational purposes only and may contain typographical errors and technical inaccuracies. The content is provided as is, without express or implied warranties of any kind. © 2013 Dell Inc. All rights reserved. Dell and its affiliates cannot be responsible for errors or omissions in typography or photography. Dell, the Dell logo, and PowerEdge are trademarks of Dell Inc.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Contents Executive summary ..................................................................................................... 5 Introduction ............................................................................................................. 5 Technology overview ................................................................................................... 6 Dell PowerEdge R820 architecture....................
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Figure 11. TPS Comparison of legacy vs R820 .................................................................... 17 Figure 12. Supported Userload comparison of legacy vs R820 ................................................. 18 Figure 13. CPU utilization comparison of legacy vs R820 ...................................................... 18 Figure 14. Power Consumption vs Userload ................................................
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Executive summary The Dell™ enterprise portfolio is evolving to incorporate better-performing, more energy-efficient, and more highly-available products. With the introduction of Dell’s 12th generation server product line, customers have an opportunity to improve their total cost of ownership by consolidating distributed legacy environments.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 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 terms of server consolidation. Storage infrastructure is equally important when compared to server infrastructure. An intelligent, feature rich storage solution compliments server infrastructure.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM The PowerEdge R820 is a 2U rack mount server includes support for the Intel® Xeon® Processor E5-2600 family (Sandy Bridge-EP architecture). This family of 6/8 core processors includes an integrated memory controller (IMC) and integrated IO (IIO) on a single silicon die. This new server supports PCIe generation 7 slots for peripherals and two internal raid controller cards, and can host up to 1.5TB of memory.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Figure 1. Oracle VM architecture (Source: Oracle, Oracle VM documentation) In the context of this whitepaper we have considered Dell PowerEdge R820 for server consolidation. Dell Compellent3 SC8000 is used as backend storage subsystem. Using Oracle VM technology we have created multiple virtual machines in a Dell PowerEdge R820. Oracle databases are installed in each of these virtual machines.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 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 that the average query response time always stayed below 2 seconds. Throughout the lab performance testing we made sure that storage disks were not a bottleneck at any time.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 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. Table 1. Hardware and Software configuration details Component Systems Legacy Production Environment Two PowerEdge 2950 III,2U servers Processors Two Intel Xeon X5460, 3.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 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 is scaling and delivering for an increasing load. This data is useful when monitoring a system for performance bottlenecks from a server point of view.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM The test methodology for the legacy production environment used was as follows: 1. To simulate the legacy production environment, we configured a two node Oracle 10g R2 RAC cluster comprising of a PowerEdge 2950 III with quad-core, dual socket 3.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 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 analysis userload supported is determined. Results of the R820 VM infrastructure are compared against the results of legacy production environment. 10.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 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 CPU utilization of legacy production system at 4800 userload. As explained earlier, CPU utilization >= 90% is considered as saturation.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM PowerEdge R820 results Figure 6. AQRT of R820 test environment AQRT vs Userload of all VMs 5 4.5 4 3.5 3 2.5 2 1.5 1 0.5 0 VM1 VM2 VM3 VM4 400 800 1200 1600 2000 2400 2800 3200 3600 4000 4400 4800 5200 5600 Figure 7. CPU Utilization of R820 test environment Avg.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Figure 8. TPS of R820 test environment TPS vs Userload of all VMs 300 250 200 VM1 150 VM2 VM3 100 VM4 50 0 400 800 1200 1600 2000 2400 2800 3200 3600 4000 4400 4800 5200 5600 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 means that there is improved performance across all VMs.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Figure 10. Consolidated userload on R820 at 70% utilization Consolidated Userload at 70% utilization VM1 + VM2 + VM3 + VM4 VM1 VM1 + VM2 + VM3 VM1 + VM2 VM1 + VM2 + VM3 VM1 + VM2 VM1 + VM2 + VM3 + VM4 VM1 0 5000 10000150002000025000 Figure 9 show that all the VMs are supporting 5200 userloads.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Performance of 70% of R820 vs 2 x 2950 = ~4X Figure 12.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM 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 generation PowerEdge 2950 III servers. 10:1 to 12:1 Consolidation at full Utilization.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM Summary Any server consolidation project must be preceded by a well-planned effort to predict the energy consumption and performance capacity of the new platform as compared to the legacy environment. In this study, we showed that the new PowerEdge R820 is an ideal platform for consolidation from legacy PowerEdge 2950 environments.
Consolidating Oracle Databases on the Dell PowerEdge R820 Server Using Oracle VM databases are designed to meet the challenges faced by IT professionals of all skill levels - working with multiple database servers, complex data environments, and reporting needs. Dell’s software tools bring greater operational efficiencies by combining automation of administrative and management tasks, performance optimization, boosting productivity for database and data professionals.