Hey all...Forgive me, as I am not up to speed on my server administration abilities. I'm currently looking at specifications for a new server that I need to build. The server will need to serve multiple duties such as:
- web server
- hosting SQL Server 2008
- possible development staging server
I am planning on installing Windows Server 2008, but was needing to know whether it would be more efficient to install multiple independent virtual servers on the same box; one for the web server, one for the database server, etc, or to just install Windows Server and SQL Server on the same OS instance. What are the advantages and disadvantages of these approaches, and at what point would I need to consider moving to a multi-server architecture.
I understand that the performance has a lot to do with it, so for the sake of discussion, lets say the server will have Dual-QC Xeon (approx. 2.66 GHz) and 16-32 GB (memory is just too cheap). Thanks.