Topology question across 3 servers (MS BI incl SSRS, SSIS, SSAS & SP)

[eo]

Hi,

We want to deploy a BI solution and have 3 environments:

A large database server (DB Server), a SharePoint environment (MOSS2007) and another unused server (Additional). Looking for some guidance/ validation:

Current:
DB Server - SQL Server databases including the data warehouse, MOSS2007 catalogue databases, ReportServer DB and Temp DB
MOSS2007 - central admin, web application

Proposed future:
DBServer - SQL Server databases including the data warehouse, MOSS2007 catalogue databases, ReportServer DB and Temp DB
- New: SSAS
MOSS2007 - central admin, web application
- New: ReportingServices Add in
AdditionalServer - (all new): SSRS Report Server, SharePoint Object Model, SSIS

Rationale for the Proposed future state:
1) SSIS and SSRS Report Server to be co-located so that the former can run its loads outside office hours, and SSRS Report Server will take the load during office hours when reports are run
2) SSAS to be co-located with other SQL Server databases as it is afterall a type of a database

Does this type of architecture make sense?





EO
Hertfordshire, England