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 |
|
esnkumar
Starting Member
2 Posts |
 Posted - 2009-11-06 : 04:51:33
|
| Our corporate currently has a medium sized (approx 500 GB) data warehouse in SQL SERVER 2005 and all SQL Server’s components database server, SSIS and SSAS are deployed to the single physical server. Considering the current performance and future growth management, we are in the process of re-architecting this BI infrastructure using SQL SERVER technologies. Could you please share your ideas/experiences/expertise on selecting the following design choices for designing a BI infrastructure for an optimal performance: 1. System Configuration : Monolithic (run all SQL Servers components in single physical server) OR Distributed (run all SQL Servers components to different physical servers)2. Data Storage: SAN or DASThanks in Advance. |
|
|
|
|
|
Need an advise on designing BI infrastructure