• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 793
  • Last Modified:

sql server 2008 vmware fault tolerance

I just did a p2v conversion of our sql server witch had dual processors each with 4 cores.  This gives me 8 logical processors.  when i did the conversion i did not change the processors, so now i have a Virtual machine with 2 procs 4 cores each = 8vCPU.  I want to use fault tolerance but i know i can only use one processor if i go that route.  Is there any way to estimate how many processors my sql server VM needs?

Right now i am looking at the perfomance tab in vshpere client and i have an average usage in MHz for the last five days as 815 and maximum of 2137.  To me this looks as though i have too much processor however i do not want performance to suffer in order to use Fault tolerance.  Any advice is appreciated.  Thanks experts!
0
IKtech
Asked:
IKtech
  • 6
  • 6
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I would start off with 1 or 2 vCPUs, and check performance in the future, and see if you need to add more.

P2V is rather dumb, and it's hardware detection, thinks it's detecting 8 Physical Processors, so creates a VM with 8 Processors (virtual).

HOW TO:  Performance Monitor vSphere 4.x or 5.0

Many vCPU can have the side effect of slowing a VM, down with vSMP, because to the CPU Scheduler.

VMware vSphere 5.1 may have changes in the future to help you.....
0
 
IKtechAuthor Commented:
So maybe try with 1 socket with one core and see how it performs?  i would love to do fault tolerance.  It seems pretty cool.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Correct, always add sockets = 1 Processor.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
IKtechAuthor Commented:
Is there any performance monitoring i can do that will give me an idea of how the server will behave with only 1vCPU?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
See my Article, all the metrics and stats arevavailable under Performance.
0
 
IKtechAuthor Commented:
i only have 1gbps network speeds.  Everything is ethernet.  Does fault tolerance work with these kinds of network speeds?  My hope is that i can use fault tolerance for my web servers (which are already using only one processor) and my sql server.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Yes, 1GBps can work successfully. Do you have Enterprise or Enterprise Plus licensing for FT ?
0
 
IKtechAuthor Commented:
essentials plus is what we bought
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
okay, so no FT!
0
 
IKtechAuthor Commented:
do you know what i would need to spend to get FT going?  is there a kit i can purchase to do FT?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
You would need to purchase an Upgrade kit, an Acceleration Kit to VMware vSphere Enterprise
0
 
IKtechAuthor Commented:
thank you sir
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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