Calculate exact Memory Consumption of Cube

[crash0verride]

I need to calculate the memory consumption of each cube on server. I see the memory consumption on Cube Properties but its different when I monitored its activity on Task Manager. Is there an exact formula for this? help is greatly appreciated.

[Martin Ryan]

If you right click on the server name then you'll see an option called "Start Performance Monitor". This will create a bunch of control cubes, one of which will give you information about the size of the cubes.

The reason that the service on the task manager will give you a different figure is because the service includes all the memory being used, including all the dimensions, which can sometimes add up to quite a lot.

Martin

[Alan Kirk]

If you right click on the server name then you'll see an option called "Start Performance Monitor". This will create a bunch of control cubes, one of which will give you information about the size of the cubes.

The reason that the service on the task manager will give you a different figure is because the service includes all the memory being used, including all the dimensions, which can sometimes add up to quite a lot.

Also, just adding up the cube memory consumption and comparing it to Task Manager doesn't factor in so-called "Memory In Garbage"; memory that the server is not currently actively using but hasn't released back to the system. You'll find that in the Performance Monitor that Martin referred to as well.

One important thing to remember before starting Performance Monitor, though; make sure that cube logging is OFF for the four "}Stats" cubes before you turn Performance Monitor on. (Right click on the Cubes list and select Security Assignments, then disable Logging on those four cubes.)

Otherwise you'll have transaction log files which, I kid you not, will run into gigabytes before you know it.

[Steve Rowe]

Also if you are in 32bit world make sure that you are not close to the memory limits of your environment or you could crash your TM1 server.
Cheers,

[crash0verride]

Thanks a lot for your help Steve, Allan, and Martin...you are really TM1 Guru guys! More power.

[Martyn Lawson]

Does anyone know what info is being recorded in this cube i.e. Bits, bytes, kilobytes?

[David Usherwood]

Suggest you start them and look. If you are responsible for a TM1 server they'll probably make sense to you.

[lotsaram]

Does anyone know what info is being recorded in this cube i.e. Bits, bytes, kilobytes?

Bytes