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, ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.