Hi All,
Our TM1 application is very slow in loading up. Also when 2 users open cubes simultaneously, they end up with "hanged" sessions. One more issue is that when TI processes run, the cube starts responding slow.
I noticed something - the tm1sd.exe is holding up 19 GB of memory when the total is 21 GB.
Any idea why this is taking up so much memory?
Suggestions are most welcome.
TM1 Version - 9.5
Excel - 2003 version - 32 bit
TM1 loading very slow.
-
- Posts: 29
- Joined: Tue Jun 22, 2010 4:01 pm
- OLAP Product: IBM TM1
- Version: 9.5
- Excel Version: 2007
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TM1 loading very slow.
This is your key clue as to why the response is slow. You need to go back to your developer and have them do a re-analysis of your system to see whether or not using 19GB makes sense given your data. If that number makes sense (i.e., it's not some sort of design mistake) then you'll need to allocate more RAM to your TM1 service.deepu_sree wrote:I noticed something - the tm1sd.exe is holding up 19 GB of memory when the total is 21 GB.
- 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: TM1 loading very slow.
As you said your model is about 19Gb in size and loading this large amount of data into the RAM will definatly take some timedeepu_sree wrote:Our TM1 application is very slow in loading up.
Make sure you are using the MaximumCubeLoadThread in your TM1S.CFG file. This will help you to use multiple core while loading the model initially.
Not sure what your TI Process is doing and what your requirements are. But generally we run the TI Processes over-nigtly (using Chores) so that Users will not get performance issues during the day.deepu_sree wrote:when TI processes run, the cube starts responding slow.
As mentioned by tomok, you either have to fine tune your model or add more RAM to your TM1 Server. If possible get some decent RAM size around 35-40Gb.deepu_sree wrote:tm1sd.exe is holding up 19 GB of memory when the total is 21 GB.
Cheers!
Rizwan Kaif
Rizwan Kaif
-
- Posts: 29
- Joined: Tue Jun 22, 2010 4:01 pm
- OLAP Product: IBM TM1
- Version: 9.5
- Excel Version: 2007
Re: TM1 loading very slow.
Folks,
Thanks for your replies..
The total size of our data directory is only 5 GB. Why is that the admin server needs so much space? Our total RAM size is 20 GB.
Regards,
Deepu.
Thanks for your replies..
The total size of our data directory is only 5 GB. Why is that the admin server needs so much space? Our total RAM size is 20 GB.
Regards,
Deepu.
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1 loading very slow.
There is not necessarily a direct relationship between the size on disk of the data directory versus the size in memory of the database when fully loaded. Size in memory will depend on ordering of dimensions in cubes, the amount of rule calculated values and feeders and the size of the calculation cache for each cube. There are already a number of posts on these topics which you should look at.
- Michel Zijlema
- Site Admin
- Posts: 712
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: TM1 loading very slow.
Please note that using MaximumCubeLoadThread to do a multi-threaded dataload will increase the amount of RAM needed by the server and looking at the situation this will make the server run out of RAM.rkaif wrote:As you said your model is about 19Gb in size and loading this large amount of data into the RAM will definatly take some timedeepu_sree wrote:Our TM1 application is very slow in loading up.
Make sure you are using the MaximumCubeLoadThread in your TM1S.CFG file. This will help you to use multiple core while loading the model initially.
Michel
-
- Posts: 3
- Joined: Sat Feb 13, 2010 12:04 am
- OLAP Product: TM1
- Version: 9.4.1 FP3
- Excel Version: 2007
Re: TM1 loading very slow.
Hi,
the reason for the slow load is very simple. You have set many feeder declarations. All of the feeder will be allocated on each server start. Please review the cube rules esp. the feeder definitions. In most of the cases the model is over fed, that means each physical value produces too many feeder marks depending on some imprecise feeder declarations. May be You splash feeders to top sum elements even tough You need one element only.
In 9.5.1 is a nice feature: You can set a new parameter in the tm1s.cfg, PersistentFeeders = T (see reference manual or the thread http://forums.olapforums.com/viewtopic.php?f=3&t=3061). The System should much faster start now, so all of the feeders are stored/cached in a .feeder file which is directly loaded to the memory on startup. Attention! If You decide to use the persistent feeders You may have some funny effects if You change Rules and feeder definitions. You have to switch off the parameter during development on rules.
HTH
Klopse
the reason for the slow load is very simple. You have set many feeder declarations. All of the feeder will be allocated on each server start. Please review the cube rules esp. the feeder definitions. In most of the cases the model is over fed, that means each physical value produces too many feeder marks depending on some imprecise feeder declarations. May be You splash feeders to top sum elements even tough You need one element only.
In 9.5.1 is a nice feature: You can set a new parameter in the tm1s.cfg, PersistentFeeders = T (see reference manual or the thread http://forums.olapforums.com/viewtopic.php?f=3&t=3061). The System should much faster start now, so all of the feeders are stored/cached in a .feeder file which is directly loaded to the memory on startup. Attention! If You decide to use the persistent feeders You may have some funny effects if You change Rules and feeder definitions. You have to switch off the parameter during development on rules.
HTH
Klopse