Page 1 of 1

RAM Usage much larger than Cubes

Posted: Fri Jul 12, 2019 9:42 pm
by Mark2007
Hi there,
I've a question regarding RAM-Usage. My Application is running Planning Analytics 2.0, Windows Server 2016

Task Manager shows it's RAM usage ~25 GB
}Stats by Server also shows total RAM of 25 GB, Garbage ~11 MB
}Stats by Cubes shows total RAM for all Cubes ~ 5GB
Dimensions size in Total is ~ 6 GB

So, Cube 5 GB + Dimensions 6 GB => where can I find the difference between 25 GB RAM in Total?

Thanks in advance!

Mark

Re: RAM Usage much larger than Cubes

Posted: Sat Jul 13, 2019 10:59 am
by paulsimon
Hi Mark

Have you recently upgraded to PA? If so, it is probably due to MUNs. From memory the topic that I raised on this was called something like Planning Analytics using twice the memory. Do a search and you should find it. Unfortunately there is nothing you can do about it other than buy more RAM.

Regards

Paul Simon

Re: RAM Usage much larger than Cubes

Posted: Mon Jul 15, 2019 4:56 am
by Alan Kirk
paulsimon wrote: Sat Jul 13, 2019 10:59 am Hi Mark

Have you recently upgraded to PA? If so, it is probably due to MUNs. From memory the topic that I raised on this was called something like Planning Analytics using twice the memory. Do a search and you should find it.
It can be found here, in fact. I've also added it to Miss Havisham's favourite thread, the FAQ one. When I have a moment I think I shall don a hazmat suit and go in and clean that thing out. I'm not sure that anyone cares overly much about 8.4 any longer. I don't want to dump the older entries but I think they need to be archived somewhere, with some fresh blood flushed into the thing.

Re: RAM Usage much larger than Cubes

Posted: Mon Jul 15, 2019 5:56 am
by Mark2007
Thanks, specially to Paul. It was the right hint and your tool to derive number of elements an number of Member Unique Names (MUN) was a great help!

I modified it a little bit:
a) it gave errrors when a dimension had no elements
b) it had problems with special signs (that should not be used, I know ) as ä, ü, ö

might be it helps someone else, too.

Mark