May 1, 2012 at 12:55 pm
Hello,
considering same configuration in terms of RAM,Processors and hardware. will it have same performance and the Individual will perform less.
In my organization they have migrated all the Individual to virtual servers, my team stating that performance was good before converting the servers to virtual.
i want experts views in this.
Regards
Durai Nagarajan
May 1, 2012 at 12:58 pm
durai nagarajan (5/1/2012)
Hello,considering same configuration in terms of RAM,Processors and hardware. will it have same performance and the Individual will perform less.
Clustering has nothing to do with performance, it's a HA technology
In my organization they have migrated all the Individual to virtual servers, my team stating that performance was good before converting the servers to virtual.
Now that's not very surprising. There are many ways to set up virtual machines for SQL, and some will result in worse performance,.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 1:02 pm
thanks for information about clustering.
can you give some link or doc on virtual terchnologies.
As far as i know is they are using HP technology to sertup serveral virtual servers on one High capacity server on SAN.
Regards
Durai Nagarajan
May 1, 2012 at 1:07 pm
Go check the 'why is my virtual server slow' video here: http://www.idera.com/Education/SQL-server-Webcasts/ or get a consultant in that's familiar with SQL in virtual machines
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 1, 2012 at 1:11 pm
First off, lets start off with, what Hypervisor are you using? It makes a difference because VMware doesn't do things the same way as HyperV which is then different from Citrix. Unless you can start answering some serious questions about the VMware environment, or you can get the answers, it is going to be impossible to help you diagnose the issue over the forums. Some information you have to know would be:
Hypervisor being used.
Host hardware configuration (CPU Type/Model#, Physical RAM, storage connectivity FC/iSCSI/NAS and path count)
# of vCPUs allocated on the host
Amount of virtual RAM allocated on the host
Storage configuration (# spindles, disk speed, RAID configuration, dedicated or shared volumes, etc)
Without this basic information we can only throw darts at what could be the problem and I'm not going to be willing waste time doing that. If you can provide the above information we can start working through what could be the issue.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply