Cluster Vs Individual

  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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