Yak Posting Veteran
Posted - 04/12/2012 : 11:37:28
| Hi all
here is the situation, i have three main db engineering, ERP and contractors. these servers are between 3-6 years old.
we have several C# webtools and ssis reports that can pull massive data from all three servers.
i have used indexing and remote procedure calls to make them bearable.
MY QUESTION IS:
I am planning to get Two or Three massive new servers, cluster them with windows 2008 r2 and setup virtulization.
given all the other server i must virtualize only one of the two/three servers will be used to host virtual sql servers.
Is it better to setup three seperate virtual DB servers on one of the new machine
setup ONE DB server Vitrual containing the databases from all 3 physical db
setup ONE DB server Vitrual, containing three instances of sql server for the 3 physical db
Any thoughts would be appreciated..