Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 5pcs. IBM System x3650(7979 - ex. ESX/VMWare, planned EOL) now with baremetal Win2012 DataCenter, every machine has the same HW and SW (inc policy).

I want to create two clusters (MS SQL), for testing purposes. I can see three possible configurations:

  1. Create two separate Failover Cluster: 3 nodes for primary environment, 2 nodes for secondary environment

  2. Create two separate Failover Cluster: 2 nodes for primary, 2 nodes for secondary, last (switched off) as a substitute

  3. Create one Failover Cluster (5 nodes / 4+1) and create one/two virtual(s) for primary/secondary environment

Would it be better to separate the environment to two farm or to create one farm with virtualization, my intended use is only MS SQL Clustering


migration rejected from Jun 19 '13 at 18:30

This question came from our site for system and network administrators. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too localized by Jon Seigel, Thomas Stringer, StanleyJohns, Kin, RolandoMySQLDBA Jun 19 '13 at 18:30

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

This is a really tough question for anyone outside your environment to answer, without knowing your requirements, the purposes of the testing, etc. I also have a hard time understanding how a specific answer here could be beneficial to other users, unless their scenario matched yours identically... – Aaron Bertrand Jun 19 '13 at 17:02
I agree with Aaron. It may be worthwhile to parachute in a consultant for a day to go over everything in your environment, and come to a conclusion based on your requirements. – Jon Seigel Jun 19 '13 at 17:12
@Aaron Bertrand testing purposes could be development, stress_test, (by default always) I have two three planned events, now I want to change own internall bad rulles, remove all mess (nothing for) from production VMware, after SLA will be moved to production enviroment – mKorbel Jun 19 '13 at 17:30
I can't to decide, question is about to create two quite stonger SQL failovers or create one WSFC and to create two virtual enviroments – mKorbel Jun 19 '13 at 17:38