Development vs Reporting Server

  • We are a smal organization.

    We are curently moving to SQL Server so we are setting up our own evnvironment.

    We decided we needed place for

    Production

    Development

    Reporting

    Data Warehouse

    Its is obv that we need a seperate server for Production and Development.

    So we need two servers.

    Does that mean 2 SS2008 Lisenses with two seperate boxes ?

    Or can they reside on the same box (virtual Server ??)

    How about Reporting and Development ?

    Can Rep and Dev DBs go into same server ?

    Can some one tell me

    1. whats the IDEAL way of setting these up

    2. Whats the best possible assuming limitted resources (In terms of lisensing and machine costs ?)

    Thanks a lot.

    [font="Verdana"]
    Today is the tomorrow you worried about yesterday:-)
    [/font]

  • 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 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply