Most DW/BI solutions require a reporting database that is mostly read-only and only occassionally updated (typically by an ETL process). As the number of users increase, there is typically a need to scale out the solution across multiple servers. Scalable Shared Databases (SSD) in SQL Server 2005 is a good option to consider. New and up-to-date documentation has been added to help you configure this correctly in your environment.