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