Deploying SSAS 2005 project in Server

Hi,

I Need to deploy all the three SSIS , SSAS and SSRS 2005 in One server. will it be fine to keep like this.

I have a doubt like, will it effect performance because SSIS have incremental load, SSAS also having incremental load then what will happen while accessing the reports while incremental process is going on

Can you please help me out

Thanks

Dinesh.

Hello Dinesh,

We installed SSIS, SSAS, SSRS and SharePoint Portal Server 2007 on one machine.

The system performs good with 4 GB of internal memory.

Later on the best installation is to have a farm with multiple servers, but in the beginning you can use just one.

Regards

Hessel

|||

Hi Dinesh Murali,

Incremental load is helpful indeed. But in general the following might turn into bottleneck if you do not have:

1) Hardware configuration (RAM, IO Controllers) required for the server to run at expected speed.

2) Network bandwidth for the Data transfer (Incase of SSIS and SSRS).

3) Try a quick test using task manager determine the following during peak time as well as off-peak time:

a) Memory consumed by Sql Server Manament Studio with all services (SSRS, SSIS, SSAS) enabled.

b) Time taken to load the report, complete the execution of SSIS Packages, or Processing a Cube or SSAS database.

Thanks

Subhash Subramanyam