TM1 64-bit memory usage?

[vfhc2003]

Hi,

I have Windows 2003 R2 Server (64-bit) and TM1 9.4 64-bit installed.
The server has 8 gb ram, 1 Quad process.

I can see the 8 gb ram in the Task Manager (available physical memory is over 5 gb).
The TM1 cube is 148 mb, it contains 3,3 million cells (all with values). The TM1sd.exe process uses 1,4 gb ram.
We used the demo database (PDData) that is installed with the 64-bit TM1 software (and created our database in the PDdata database)

If I try to do a "relative proportional spread" from the top value to populate the cube with a new budget it takes 3 minutes.
When we had this installed in a 32-bit environment it also took 3 minutes.

The task manager does not exceed 25 % during the spread (probably only uses one of the cores?!?)
The TM1sd.exe doesn't get any bigger and the "available physical memory doesn't change.

Why doesn't my TM1 application use the 64 bit environment = use all available RAM?
Could it be a setting in the TM1 enviroment that I have missed?

Thanks in advance

[Steve Rowe]

Hi vfhc2003 (if that's your real name ), welcome to the forum,

The simple answer is because it does not need too.

Your cube is 148mB your server has 8gB of RAM, the Tm1 server is already using as much memory as it needs to store your data. There is no need for it to grab more RAM to process the spread since (I'm guessing) your replacing one value with another.

As to why it doesn't process the spread faster, unless the individual processor cores are higher rated than your 32 bit ones then the processing of a single thread is not going to happen faster.

Your new server should be able to handle multiple users better than a 32 bit one but a test of single user in 32 bit and in 64 bit is unlikely to show much difference (given similar processors).

Cheers,

[mattgoff]

64-bit doesn't make TM1 run any faster, it just allows you to have a larger model. TM1 calculations are single-threaded-- multiple users may be assigned to different cores, however, to increase aggregate performance (assuming you don't run into locking issues).

Matt

[frosterrj]

TM1 calculations are single-threaded-- multiple users may be assigned to different cores, however, to increase aggregate performance (assuming you don't run into locking issues).

Matt

How do you assign people to different cores? Never heard that one before.

[mattgoff]

How do you assign people to different cores?

You don't have any control over core assignment-- TM1 (and Windows) manage it internally.