Size and RAM of TM1

Post Reply
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Size and RAM of TM1

Post by dilip »

I need to know what is the maximum volume of data TM1 can hold..
Is it directly dependent on RAM..I mean if your cube estimated size is > 10 GB
Them in this case we need to have ram of atleast 15 GB..
OR How RAM and size of cube is interrelated...

why we need paging for our tm1server? Is it necessary for a good performance for TM1?
failurehappening
Posts: 78
Joined: Tue Nov 30, 2010 1:18 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Size and RAM of TM1

Post by failurehappening »

that question makes no sense at all... TM1 can hold lots of data, however much memory you think you need, double it .. and probably add a 0
RHR
User avatar
qml
MVP
Posts: 1096
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Size and RAM of TM1

Post by qml »

dilip wrote:I need to know what is the maximum volume of data TM1 can hold..
The theoretical upper limit is in the vicinity of 16.8 million tebibytes like with any other 64-bit application.
dilip wrote:Is it directly dependent on RAM..
Naturally, this is where TM1 stores its data and you need enough RAM to fit your model with enough buffer for the OS, future growth etc.
dilip wrote:I mean if your cube estimated size is > 10 GB
Them in this case we need to have ram of atleast 15 GB..
A 50% buffer space is a reasonable minimum, but of course the bigger, the better/safer.
dilip wrote:why we need paging for our tm1server? Is it necessary for a good performance for TM1?
No, we don't and no, it isn't. Paging is used by the OS if you run out of RAM. In that case another storage, usually a hard drive, is used as a logical extension of RAM. As it is much, much slower than RAM it affects performance big time. So you want to avoid paging by having enough RAM to hold your TM1 model and everything else running on that machine.
Kamil Arendt
dilip
Posts: 128
Joined: Thu Dec 15, 2011 8:22 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: Size and RAM of TM1

Post by dilip »

Thanks Kamal or qml...for your reply...
Post Reply