I have a BW 3.5 production system on Windows SQL platform. We will be migrate to a new hardware 64-bit physcal server, and upgrade to BI 7.0 ABAP/ SQL Server 2005. The new server has 32GB memory and we plan to install DB, CI and DI on the same box. My question to you is how do I allocate this 32 GB memory? My plan is:
SQL Server Database: 12GB
Central Instance: 10GB
Dialog Instance: 10GB
Is this configuration ok or something I should do differently? How big page file I should give?
Thanks for your input.
Yujun Ran