Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2010-02-08 : 16:49:24
|
| If you have TWO servers with equal specs and you're going to build a data warehouse how would you configure the machines?Would you put SSAS and SSRS on one machine and the ETL SQL Server on another. Would you put the ETL SQL Server and SSRS on one machine and the SSAS instance on the other orWould you put SSAS and the ETL SQL Server on one machine and SSRS all by itself?I'm thinking the middle option is best.Anyone have an opinion? Or better yet, does anyone have experience or facts to bear on this?An infinite universe is the ultimate cartesian product. |
|
|
|
|
|
Load balancing