What might be the reason to have big proportion of the allocated memory to TM1 is in Garbage and not used by any of the cubes even just after restarting the TM1 service?
Using multithreaded feeder loading (MaximumCubeLoadThreads>1).
Bear in mind that the calculation cache (and probably the stargate caches) will make use of the garbage. NB the TM1 instance never hands memory back to Windows.
Shame TM1 makes so little use of modern multi core technology. You can buy lots of servers, of course - that works well - but then the server to server integration is hardly there (replication - hah!).
Data updates and report queries can obviously utilize multi core as far as locking issues are handled properly. Obviously there a lot to be done on the locking area.
Calculation is still single threaded - and when data is changed, the calculation cache is cleared for the cube in question and all dependent cubes. Multi user locking is better than it used to be but for modelling apps with little input and lots of calculation, the architecture could be a lot better.
|手机版|小黑屋|企业绩效管理网
( 京ICP备14007298号 ) 
发表于 2014-3-16 05:10:38
