We are a development team with over 10 developers. We used to have SQL Server (2005) on two different servers (32bits), one for development and one for QA. Now the corporation IT updates the SQL2005 to SQL2008 and OS to 64 bits Win2K8. In the same time,
they want to consolidate the SQL servers. When we get SQL server 2008, we will only get one virtual server (64bits) for both development and QA. In fact, our team are doing multiple projects at the same time, We still prefer to have one server for all development
work (may be in one named instance or many named instance), another server for QA with parallel configuration.
As far as I understand, with different virtual servers, we can reduce the interference between development and QA work, and allocate CPU and memory to these two virtual servers accordingly.Technically, what is the better solution? Or any comments on this
configuration? what are pros and cons for these two options.
View Complete Post