November 1, 2012 at 2:43 pm
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
November 5, 2012 at 10:00 am
The two machines can be well isolated, but it greatly depends on your configuration.
November 5, 2012 at 11:56 am
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
November 5, 2012 at 12:20 pm
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
November 25, 2014 at 7:56 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy