VM and Performance Isolation

  • To what extent can performance be isolated on the same VM for different SQL Server servers? So if I have a SQL server called Quantum and one called Particle, if one is extremely spiking, will the other necessarily be affected?

    Thanks for your time.

    Mark

    [Edit for English]

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • The two machines can be well isolated, but it greatly depends on your configuration.

  • benjamin.reyes (11/5/2012)


    The two machines can be well isolated, but it greatly depends on your configuration.

    Thanks Benjamin. I am wondering about this VM. I don't know if they're experts at that or not, or have even focused on trying to isolate them. I wonder if you have to be really an expert at that, or is it a fairly routine operation.

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • As with most things if you require expert results you probably need an expert.

    Here are some helpful links to get you started.

    http://www.vmware.com/files/pdf/sql_server_best_practices_guide.pdf

    http://www.brentozar.com/archive/2011/05/keys-deploying-sql-server-on-vmware/%5B/url%5D

    http://technet.microsoft.com/en-us/sqlserver/gg429826

  • mtillman-921105 (11/1/2012)


    To what extent can performance be isolated on the same VM for different SQL Server servers? So if I have a SQL server called Quantum and one called Particle, if one is extremely spiking, will the other necessarily be affected?

    Thanks for your time.

    Mark

    [Edit for English]

    Few things ...

    On Vmware world you usually install MS-SQL on its own virtual machine or single Windows Os. That gives you more flexibility and the ability to isolate performance.

    Now, going back to your initial question, if I have VMware machine A, and another one called B, each running its own instance of MS-SQL, they should NOT "fight" for resources or affect the others performance; that's one of the virtualizations premises. But that is only true if the VMware admin properly configure the Hypervisor that hosts those virtual machines. If there is not enough hardware (enough hosts, RAM, CPU, slow SAN, etc) machine A will start having issues because machine B needs some vCPU or RAM in order to process a query.

    Above is the main reason to get a VMware expert that also posses some MS-SQL expertise.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply