05-06-2010 02:40 PM
I just setup a new HP UX 11.31 (using 3/2010 DVD media) VM 4.2 host (rx2600 server) and created 2 guests (HPUX 11.31 EOE and BOE). My DBA told me that Oracle db creation is 140% - 200% slower on the VM guests vs. a regular physical server (with same 2GB memory, same kernel settings, and same CPU qty 2). How to performance tune on the VM guests so Oracle will run faster? Thank you.
Solved! Go to Solution.
05-06-2010 08:05 PM
On rx2600 you maybe having 4 cores.
How have you done the cpu allocation ? How many cores to which VM and what % entitlement ?
05-07-2010 12:21 AM
certainly you will get slower performance in VM if your configuration & planning is not proper... suppose the guests are using same disks for oracle & both to are accessing the disks simultaniously ... its going hamper the server performance....
You you should plan the gust configuration, in a way that ... boths the gust should not use same physcical resource simultaniously....
Hp Virtual Machines Installation,
Configuration document have some sessions about performance..
05-07-2010 07:25 AM
Here is the hpvmstatus output: Does this setting look OK to you??
Virtual Machine Name VM # #VCPUs Entitlement Maximum Usage Usage
==================== ===== ====== =========== ======= ======= ================
host1 3 1 10.0% 100.0% 1.3% 656126
host2 4 2 10.0% 100.0% 0.0% 0
[Virtual Machine Memory Entitlement]
DynMem Memory DynMem DynMem DynMem Comfort Total Free Avail Mem AMR AMR
Virtual Machine Name VM # Min Entitle Max Target Current Min Memory Memory Memory Press Chunk State
==================== ===== ======= ======= ======= ======= ======= ======= ======= ======= ======= ===== ======= =======
host1 3 512MB 0MB 8GB 8192MB 8192MB 0MB 8GB 0MB 0MB 0 0MB DISABLE
host2 4 512MB 0MB 8GB 8192MB 8192MB 0MB 8GB 0MB 0MB 0 0MB DISABLE
05-07-2010 08:02 AM
Your DBA is reading off a website. If you give the HPVM guest sufficient memory and CPU, there should be negligible change in time to execute commands.
HPVM is a mature virtualization scheme that has very low overhead.
Now its true, if we have a truly high volume, high impact system, we'd prefer to configure it in a vpar, but its pretty much the right tool for the right job.
Comparable performance of oracle in a hpvm guest situation is possible with normal tuning techniques. Kernel in the vm guest, just like you would do in a regular machine.
Owner of ISN Corporation
05-07-2010 08:13 AM
05-07-2010 08:57 AM
Have a great weekend.