May 20, 2011 at 6:39 am
Hi,
Iam getting performance issue on VMware. VMware configuration are given below
1)VMware version --> Vsphere ESX 4.1 with Update1
2)virtual host running on Windows 2003 64bit
3)IBM X3850 Server with 4 Sockets, 4cores per socket, 128GB RAM"
4)RAM allocated on ESX host is 128 GB
5)Disk IO subsystem --> SAN connected via Fiber. (IBM XIV Storage)
6)There are only 3 VM running with 8VCPU
7)There is no reservation for SQL VM (CPU and memory allocations)
8)VMFS Shared for the underlying SQL Storage?
9)CPU Ready counter for the SQL VM is between 0.60 to 1.50 during the process
When i ran UPDATE STATISTICS on Physical Server it took around 02:45 Hr
to complete.
Physical Server Configuration: 4 cpu, 8 GB RAM.
Whereas in Vmware it takes 03:58 Hr to complete
Virtual Server configuration: 8 VCPU, 8 GB RAM.
We are getting almost 1 hr 15min performance degradation on VMware. All my bulk processing getting delay on VMware, Kindly suggest on the same.
May 20, 2011 at 6:59 am
Virtual database servers suffer a significant performance hit in almost all cases.
There are whole books of information on the subject. There are solutions to speed things up, but you'll probably never get the performance you'd get on real hardware.
I recommend just using your search engine of choice and looking for "virtual SQL server performance". You'll find a ton of information.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 20, 2011 at 9:25 pm
your right but as per Microsoft & VMware they are saying only 10 % performance hit will be there. In my case am getting almost 40- 50 % performance degradation.
May 21, 2011 at 3:19 am
using virtual disks for the VMs SQL Server storage will be the weak point. For the SQL Server data storage drives they are better created as RDM's and ideally the LUNs should be on dedicated physical disks too. Without knowing a lot more about your setup its difficult to advise fully, but i would look at the VMs disk layouts first.
Also if you have hyperthreading enabled on the ESX host, try disabling that and see if the performance is any better
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 22, 2011 at 1:43 am
we are using VMFS Shared for the SQL Storage and hyperthreading was already disabled. would RDMs make any performance impact.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply