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? by the way, my company bought Pentaho System for BI