Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reoaran
Starting Member
20 Posts |
 Posted - 2010-07-29 : 13:21:18
|
| Is installing Cluster in Virtual or in a Physical make any difference. Which would be better, effective\ineffective and if so any reasons behind for the same? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-07-29 : 13:34:49
|
| Physical servers are typically better, but it really depends on your business requirements. If you had two ESX servers, where each VM is on a different server, then you'd have high availability via clustering. If both VMs are on the same ESX server, then you lose HA if anything happens to the ESX server such as a simple reboot. VMs can be very cost effective due to SQL licenses and saving Data Center space.Our business requirements require physical servers for our customers due to the criticality of the data as well as the high performance requirements.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-30 : 06:03:18
|
| We have virtual servers for IIS and SQL - on two machines. If one goes down an additional virtual machine is started on the other - so the one remaining good machine does both jobs, and the site limps along. That is cost effective as far as our client is concerned - its at a data centre where the broken machine can normally be replaced within a couple of hours, ISI + SQL getting maxed out on a single machine would be very bad luck - would have to happen on the busiest day of the year, or thereabouts. |
|
|
|
Jim Beam
Posting Yak Master
137 Posts |
Posted - 2010-12-31 : 09:21:20
|
| Any good articles on Virtualisation in SQL? |
|
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2011-01-10 : 01:23:03
|
| We Have Four ESX Servers with NetApp Storage for our Production.Two VMs with Windows Server 2008 and Sql Server 2005 Enterprise SP3.each VMs are in different ESX Servers.these are Configured with Clustering.beginning we faced some problems in Sql Server Clustering in VM's.After We done below actions.Now it's Running since last 8 Monthswithout warnings and errors.do these actions before configure Clustering in VMs.1. Disable VM HA option for these VM's2. All drives are have a Separate LUN's(for Best Performance)3. Must Quorum drive Have a separate LUN(don't mix Other Drives in this LUN Because Sql Server not show this Quorum LUN)4. give separate LUN for MSDTC Cluster Service5. All drives are Raw LUN Mapping with VM's--Ragu ThangavelJunior SQL Server DBA |
|
|
|
|
|
|
Install cluster in Virtual or Phyiscal?