Hello Experts,
We are having a BPC Microsoft multi server environment.
The application server and database server are 2 seperated servers.
The version for BPC is SP7 and for SQL Server 2008 SP1 cumulative update 6
Each time we are running reports or performing actions on BPC, we see onthe database server in the task manager that the MSMDSRV.EXE
applicationstarts to increase in memory use. It starts with 1,5GB of memory use andit ends 10 minutes later (when the report is don
e running) with almost
4GB. For some heavy reports, the memory use grows till 12-13GB.
Is this normal? There is 32GB in this server, would the server crash if
there was less then 32GB? Because due to this memory use of the OLAP
server, the server uses up to 28GB of RAM.
Is it usefull to use a fixed memory allocation for the Analysis Server?
And how can we calculate how much we have to allocate?
Do we have to modify the MSMDSRV.INI file? And isn't this Analysis Server
using a cache, because it seems that when the report is done running, all
the memory used by the OLAP server is free again.
Are there any parameters we can change to increase the performance of the
Analysis Server?
Thanks in advance,
Arjun.