Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

VM and Performance Isolation Expand / Collapse
Author
Message
Posted Thursday, November 1, 2012 2:43 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 3:46 PM
Points: 598, Visits: 3,821
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
Post #1380036
Posted Monday, November 5, 2012 10:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 11:15 AM
Points: 257, Visits: 1,594
The two machines can be well isolated, but it greatly depends on your configuration.

Post #1381178
Posted Monday, November 5, 2012 11:56 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 3:46 PM
Points: 598, Visits: 3,821
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
Post #1381229
Posted Monday, November 5, 2012 12:19 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 11:15 AM
Points: 257, Visits: 1,594
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/



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

Post #1381235
Posted Tuesday, November 25, 2014 7:56 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:23 PM
Points: 417, Visits: 1,365
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.
Post #1638961
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse