• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1017
  • 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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
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

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

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