Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1015
  • Last Modified:

how many processors should I assign to my DB VMs

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
ndidomenico
Asked:
ndidomenico
2 Solutions
 
PatricckCommented:
Your option should be good.

Regards
Patrik
0
 
coolsport00Commented:
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
 
coolsport00Commented:
BTW, your RAM allocation is fine.
0
Automating Your MSP Business

The road to profitability.
Delivering superior services is key to ensuring customer satisfaction and the consequent long-term relationships that enable MSPs to lock in predictable, recurring revenue. What's the best way to deliver superior service? One word: automation.

 
Luciano PatrãoICT Senior Infraestructure Engineer Commented:
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
 
bgoeringCommented:
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
 
ndidomenicoAuthor Commented:
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
 
bgoeringCommented:
That applies if you need to assign more than 4 vcpu to any particular vm
0

Featured Post

Threat Trends for MSPs to Watch

See the findings.
Despite its humble beginnings, phishing has come a long way since those first crudely constructed emails. Today, phishing sites can appear and disappear in the length of a coffee break, and it takes more than a little know-how to keep your clients secure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now