Page 1 of 1
tm1s.exe - load time
Posted: Fri Oct 17, 2008 4:04 pm
by yyi
server boot sequence begin fast then once the commit charge reach a few hundred mbs, the rest of the cubes seem to load about 10k p/hr
. does anyone have any tune up tips like multi thread load, mem tweaks or cube/feeder arrangements
spec = win2003svr, 9.1sp3 x86, 8Gbs.
Re: tm1s.exe - load time
Posted: Fri Oct 17, 2008 4:45 pm
by Eric
What is your total load time?
Re: tm1s.exe - load time
Posted: Fri Oct 17, 2008 5:31 pm
by yyi
total is about 12mins, what i don't understand is why the brakes go on after the first 3 seconds when it's already loaded most of the cubes in memory
Re: tm1s.exe - load time
Posted: Fri Oct 17, 2008 5:36 pm
by Eric
12 minutes is not bad. I know someone who has a load time of 6 hours!
potential culprit to load time after data load.
1) Feeders
2) Security
Re: tm1s.exe - load time
Posted: Mon Oct 20, 2008 12:30 am
by ScottW
Yeon,
If you look in the tm1server.log then you can see exactly what is taking the time.
TM1 server loads in the order:
- dimensions + element attribute cubes
- data cubes + process feeders (per cube with feeders in the rule file)
Loading data is extremely fast. The thing that takes the time is processing feeders of large cubes. It's not uncommon for the majority of server load time to be processing feeders for one or two cubes.
12 minutes is a small tm1 model by any stretch, I wouldn't be too concerned either way.
Re: tm1s.exe - load time
Posted: Mon Oct 20, 2008 8:54 am
by David Usherwood
You can multithread feeder loading by setting
MaximumCubeLoadThreads = <x>
in TM1S.CFG
where x should be 1 less than than the cores on your server. This works on 8.4.5 (very well) 9.1 (pretty badly) and in initial testing, 9.4 (rather well). But not on 9.0SP<anything>.
Re: tm1s.exe - load time
Posted: Mon Oct 20, 2008 12:02 pm
by Eric
Didn't know about that, must be because I'm on 9.0
