Memory Usage grows on server restart

Post Reply
dubs
Posts: 131
Joined: Fri May 22, 2009 10:43 am
Version: 9.4
Excel Version: 2003

Memory Usage grows on server restart

Post by dubs »

Hi All,

Can anyone tell me why my Memory Usage grows when i restart my TM1 Server.

It was 824,180K and then i saved all data and restarted the service, the memory usage is now 1414180K so it has grown by almost 600000K!! Nothing has been changed or added so i can't work out why there is such a difference.

Any Ideas?

Cheers

Dubs
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Memory Usage grows on server restart

Post by rkaif »

You must have loaded large amounts of data in the cube and now your TM1 Cube size have increased this may be the reason it is now consuming more memory. You are now consuming 1.34Gb which is not much (depends upon your Hardware)
Cheers!
Rizwan Kaif
dubs
Posts: 131
Joined: Fri May 22, 2009 10:43 am
Version: 9.4
Excel Version: 2003

Re: Memory Usage grows on server restart

Post by dubs »

I haven't loaded any data into the cubes- i literally just restarted the service and watch the memory usage grow...

anybody else have a suggestion as to what has caused this?
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

Re: Memory Usage grows on server restart

Post by Kyro »

The only time I've seen that is when the data changes weren't saved, so it calulates/loads the cubes or something when re-importing the TM1 transaction log (what was not committed). But you did say that you saved the server before restarting it so I'm stumped.
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Memory Usage grows on server restart

Post by Steve Rowe »

If you have changed nothing on the server then this would be a mystery.

A possible candidate would be a change in feeder behaviour.

For example if you have a consolidation on the right of a feeder. If you increase the number of elements in the consolidation then this would create more fed cells. Crucially the extra fed cells would not appear until the rules are saved or the server restarted.

If you can rule out changes to data then this implies either a rule or feeder change (or a bug...). For me a change in feeders as described above is more likely since a rule change would probably have an immediate effect.
HTH
Technical Director
www.infocat.co.uk
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Memory Usage grows on server restart

Post by lotsaram »

Steve Rowe wrote:A possible candidate would be a change in feeder behaviour.
One possible thing I can think of is that if the server previously loaded in single threaded mode and you changed to multi-threaded loading by implementing MaximumCubeLoadThreads in the tm1s.cfg file then this would cause feeders to be processed more than once (as each thread doesn't know what the others are doing). This would cause the server to load with more "memory in garbage". If you have spare memory it's harmless enough and could be worth it for the reduction in load time (... but in some instances the load time is actually faster single threaded due to greater efficiency in processing feeders! It depends on whether your model is data heavy or calculation heavy.)

This exception aside, I agree with everyone else. More memory = more data somewhere.
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: Memory Usage grows on server restart

Post by stephen waters »

Dubs,
How are you measuring the memory useage of the TM1 server? if you are you using the "Mem Useage" column in task manager you can get this behaviour. If so, look at the "VM Size" column instead.
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: Memory Usage grows on server restart

Post by Martin Erlmoser »

dubs wrote:Hi All,

Can anyone tell me why my Memory Usage grows when i restart my TM1 Server.

It was 824,180K and then i saved all data and restarted the service, the memory usage is now 1414180K so it has grown by almost 600000K!! Nothing has been changed or added so i can't work out why there is such a difference.

Any Ideas?

Cheers

Dubs
how much garbage memory do you have after restarting?
dubs
Posts: 131
Joined: Fri May 22, 2009 10:43 am
Version: 9.4
Excel Version: 2003

Re: Memory Usage grows on server restart

Post by dubs »

Hi All,

Sorry I've been away for a few days.

I think it is to do with Multi-threaded mode as Lotaram suggested, I changed the setting in the cfg file to 0 and now it only uses 670,732K

Background:

Basically it is feeders im messing about with, im using sysinternals Process Explorer to monitor mem usage and looking at the 'Working Set' column. I definitely have not been adding data so the 'data' must come from the changes in feeders (even though to make a change to a feeder you have to save the rule file and that should prompt the extra fed cells to consume more memory).

What I've been doing is starting with a blank rules file and adding my rules and feeders in groups and logging how much memory that group used. I've managed to isolate a group that consumed too much memory this way. What was happening was that after adding all rules and feeders back in i'd have a memory usage of say 824,180K. I'd then do a saveDataAll and restart the service, it was when it was restarted the mem usage grew so rapidly.


@ Martin Erlmoser

I don't know how to check fro Garbage Memory, could you tell me? this would be useful because i could work out what the actual memory usage was when using multi-threaded mode on start up.

Thanks for everyones comments- it's definitely helped me understand what was happening.

Dubs
Post Reply