November 1, 2010 at 5:31 pm
The ideal solution would be to separate all of these services on separate servers for performance but as with most things it really depends on what you are trying to achieve and what your budget is.
If the database is fairly small then you could put the production DB, warehouse and reporting on a single server until such a time that they grow to a size that requires more server resources and need to be split up.
The development environment ought to be on a different server to the production environment.
However if things are tight and the system is small you could put the whole lot on a single server via two virtual machines or if you don't have that, via two instances.
You'd need to licence each server that runs a component of SQL server; so if you had the db, reporting and data warehouse on separate servers then you'd need three licences
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply