Advise Needed - Best build practice for SQL 2012 BI environment

  • Hi all!

    I need a bit of advise on what is generally best practice for building SQL BI environments. I have been tasked to do the architecture design for our new SQL 2012 BI environment but my manager and I seem to be having a difference of opinion on what will work best. I have suggested that we have a two server configuration in PROD, 1 SQL server hosts the staging and production DWs and the other server hosts SSAS and SSRS. He however suggests that we should host all on one server.

    I would like to get your thoughts on what would be the better approach and also any links you could share that provides best practice for planning SQL BI environments.

    Thanks

Viewing 0 posts

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