where to install the new warehouse SQL Server?

  • I’m starting to build the DM design for BI data warehouse; I have two SQL server 2008 databases that will create the ETL to read from them what is the best physical structure I should consider? Should I create the new database warehouse on the same source database server? or should I install new SQL server instance for the warehouse database ? Or should I install MS SQL Server 2008 on the same server where my BI server is and create the database there? Which choice will be better for ETL best performance?

  • Your question isn't entirely clear for me.

    How many servers do you have?

    What is the "BI server"?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

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