Determining the Optimal Number and Placement of Servers
When you’re planning for new servers, you have many things to consider. These can include the following:
Source systems. If your source systems are RDBMSs, such as an earlier version of SQL Server or some other vendor’s RDBMS (Informix, Sybase, and so on), you might want to upgrade source data systems to SQL Server 2008 to take advantage of BI-related and non-BI-related enhancements. For more information about enhancements to the relational engine of SQL Server 2008, go to http://download.microsoft.com/download/C/8/4/C8470F54-D6D2-423D-8E5B-95CA4A90149A/SQLServer2008_OLTP_Datasheet.pdf.
Analysis Services. Where will you install this core service for BI? We find that for smaller BI projects, ...