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?


  • Why hypervisor? what hardware? what versions of code? – Chopper3 Aug 17 '09 at 11:15
  • 2
    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.


I just worked on this, see my question.

Advice for Hyper-v deployment on windows server

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy