Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

how many processors should I assign to my DB VMs

Posted on 2011-02-21
7
Medium Priority
?
1,010 Views
Last Modified: 2012-08-14
We are setting up an ESXi 4.1 server that will host 2 vm's for now, maybe 1 or 2 smaller vm's later. The server is a Dell Poweredge T610 with 2 six-core 2.66ghz Xeon processors, 16Gb ram, local storage (4 x 300Gb in Raid 5). One VM will be running an Oracle DB on Windows Server 2008 R2 64 bits, the other will be running also an Oracle DB on Windows Server 2003 R2 32 bits, each serving about 20 users.

How many vcpu's and ram would you recommend to assign to each vm for this kind of usage ? Even though we have 12 vcpu we can assign, I've read that assigning too many vcpu to a VM might cause a drop in performance (cpu contention ?).

We thought of using 6 vcpu / 8 Gb ram for the 2008 R2 server, and 4 vcpu / 4 Gb ram for the 2003 R2 server.

Thanks.

0
Comment
Question by:ndidomenico
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 3

Expert Comment

by:Patricck
ID: 34943044
Your option should be good.

Regards
Patrik
0
 
LVL 40

Expert Comment

by:coolsport00
ID: 34943064
You assign according to specs to install Oracle. You are right...overallocating can cause contention. With so few users I would go with 1 vCPU to start with, 2 at most. You can increase later if needed.

~coolsport00
0
 
LVL 40

Expert Comment

by:coolsport00
ID: 34943078
BTW, your RAM allocation is fine.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 24

Accepted Solution

by:
Luciano Patrão earned 1200 total points
ID: 34943101
Hi

First you need to take attention on the Oracle Licenses.

Take a look at this:
http://www.oracle.com/us/corporate/pricing/partitioning-070609.pdf

http://oraclestorageguy.typepad.com/oraclestorageguy/2010/05/oracle-license-costs-on-the-vmware-vsphere-platform.html

http://communities.vmware.com/message/1613431

Because Cores and CPU is an issue with Oracle licenses.

Regarding how much CPU do you need, it depends on what you are running on that Oracle.

If you have the license, you can star with a number of CPU then check the performance of the VM and if needed, just increase the CPU.

Also good reading for VMware vs Oracle

http://blogs.vmware.com/performance/2007/11/ten-reasons-why.html

Hope this can help

Jail
0
 
LVL 28

Assisted Solution

by:bgoering
bgoering earned 800 total points
ID: 34943319
Start small and slowly go bigger. Note that you need Enterprise Plus licensing on vSphere to go more than 4 vcpu in any event. I would start with 2 vcpu each
0
 

Author Comment

by:ndidomenico
ID: 34943448
Thanks to all. A few questions:

on bgoering comment about 4 vcpu and Enterprise Plus : does this apply if I need to assign more than 4 vcpu to a particular VM ? Or do you mean if I need to use  more than 4 vcpu for all of my VM's

About the Oracle licensing: read through most of the links quickly. There seems to be some confusion whether Oracle Standard and Oracle Standard One is licensed per total number of physical sockets or per total number of cores ?

Enterprise Edition seems definitely per total number of cores (NumberOfSockets x NumberOfCores / 2). And Oracle does not consider cpu affinity in its licensing when used with Vmware's product.
(I should maybe start a new question on this).

0
 
LVL 28

Expert Comment

by:bgoering
ID: 34943521
That applies if you need to assign more than 4 vcpu to any particular vm
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question