TM1 Forum

Morning all,

I'm currently testing a TM1 model in CX 10.2.1 (64 bit) vs CX 10.1 (32 bit).

I have a chores which sets off a number of TI's to export data from cubes into a number of flat files splitting the data into a separate file for each year. In version 10.1 when the processes are ran the model grows to a size of 1.4Gig of RAM. In 10.2.1 it is wildly different, the model grows to over 5gig of RAM. I expect the memory to increase when its exporting the data however to be 3.5 times different doesn't seem quite right.

Has anyone come across anything like this?

Thanks

You are comparing two situations which are different in two respects, server version and pointer size.

A cube is represented in memory by a tree of pointers (numbers pointing to other memory) and the pointers take up most of the memory used. In 32 bit TM1 each of these pointers is 4 bytes. In 64 bit each is 8 bytes. This alone can account for a factor of two in the memory use you are seeing.

If you want to dig deeper into where the memory is going then turn on monitoring in both systems and examine the }StatsByCube and }StatsForServer cubes. This gives a detailed breakdown. One thing that might have an effect is a possible difference in the default value for the VMM parameter in the cube properties. This could affect whether views used for the export get cached for later use.

Thanks for the response Duncan, I will take a look.