Server Fault is a question and answer site for system and network administrators. 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 need to run a website (with database) in a virtualized environment, all MS. There will be one primary server with one available for failover. We are expecting a pretty managable load, maybe 25 users although the queries may be big.

How would you recommend setting up the virtual servers on the primary physical server?

For example: -only 1 virtual server running IIS and SQL Server? -separate IIS and SQL server into 2 virtual servers? -separate IIS and SQL server and duplicate them, for 4 virtual servers, which isn't necessary for load but might make it easier to upgrade since we could take one off line? - or something else?


share|improve this question
Why hypervisor? what hardware? what versions of code? – Chopper3 Aug 17 '09 at 11:15
How long is a piece of string? – Mark Henderson Aug 18 '09 at 21:04
...and how big is a big query? – John Gardeniers Sep 2 '09 at 2:13

I'd suggest separating the Web Server and the Database server since it will be much easier to scale to a separate machine when you need to.

share|improve this answer

I just worked on this, see my question.

I think reading through that will help you.

IMHO, after playing around with it, I think you should just create 2 virtual servers one for IIS and the other for SQL Server, you can make backups of those VM/VHD and then use those if you need to run tests/upgrade or whatever.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.