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
RAM Usage much larger than Cubes
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: RAM Usage much larger than Cubes
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
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
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: RAM Usage much larger than Cubes
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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Posts: 45
- Joined: Tue Jan 07, 2014 12:07 pm
- OLAP Product: Cognos TM1
- Version: PA 2
- Excel Version: office 365
Re: RAM Usage much larger than Cubes
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
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
- Attachments
-
- TM1DimElemAndMUNCountLister_004.zip
- (34.55 KiB) Downloaded 211 times