Table of Contents
Configuration and Test details
Host System - Windows 8.1 - CPU i7-4710-HQ 2,5 GHz - 1 socket, 4 Physical CPus, 8 Logical CPUs - 16 Gbyte RAM Testcase - VirtualBox System I running : OEL 6.6, Wildfly 8.2 , 50 Threads ( using Jmeter ) - VirtualBox System II running : OEL 6.6, Oracle RAC 12.1.0.2.0 , running Instance bankA1 - VirtualBox System III running : OEL 6.6, Oracle RAC 12.1.0.2.0 , running Instance bankA2 What we exe expecting - As the testcase is CPU bound ( very little DB actions) we expect a Host CPU utilization of 100 % .
Single Core Testing – Using only a single physical CPUs
Guest System VirtualBox System I [ OEL 6.6 ] CPU details : [oracle@wls1 Desktop]$ nproc 1 [oracle@wls1 Desktop]$ lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 1 On-line CPU(s) list: 0 Thread(s) per core: 1 Core(s) per socket: 1 Socket(s): 1 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family: 6 Model: 60 Stepping: 3 CPU MHz: 2496.669 BogoMIPS: 4993.33 L1d cache: 32K L1d cache: 32K L2d cache: 6144K NUMA node0 CPU(s): 0 -> Only a Single CPU is active for our OEL 6.6 guest system! TaskManager Output : -> Complete CPU utiliztion is only 40 % Resource Manager Output: -> VirtualBox processes are multi-threaded [ this should be helpful for mulitple Testing ] JMeter Output : -> The Single CPU test is able to run at a rate of 20 TPS
Single CPU Test Summary:
- Single CPU test utilizes only 40 % of our Host CPU
- VirtualBox processes are using up to 50 threads
- The current test system runs a rate of 20 TPS
- If we can make happen a CPU utilization of 100 % we should see a rate of 50 TPS
Multiple Cores Testing – Using all 4 physical CPUs
Guest VirtualBox SystemI [ OEL 6.6 ] details : [oracle@wls1 Desktop]$ nproc 4 [oracle@wls1 Desktop]$ lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 4 On-line CPU(s) list: 0-3 Thread(s) per core: 1 Core(s) per socket: 4 Socket(s): 1 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family: 6 Model: 60 Stepping: 3 CPU MHz: 2494.114 BogoMIPS: 4988.22 L1d cache: 32K L1d cache: 32K L2d cache: 6144K NUMA node0 CPU(s): 0-3 --> All 4 physical processors are available at our Guest OS Test results : Task Manager Output : -> All 8 virtual CPUs are running at 100 % utilization JMeter Output: -> The whole System runs now at 50 TPS
4-CPU Test Summary
- Using all CPUs increase the the TPS rate to over 51 TPS
- For Performance Testing using configuring Virtualbox to use all physical CPUs may be a good advice.
- In the above test the VirtualBox systems running the RAC instances only uses a single phy. CPU.
- Our Virtualbox RAC system are not yet CPU bound and a single phy. CPU is sufficient
- As we expected we can increase the TPS rate by factor 2.5 when we increase the initial HOST CPU utilization from 40 % to 100 %