RAM SIZE Details

Post Reply
manchala
Posts: 17
Joined: Tue Feb 26, 2013 1:32 pm
OLAP Product: Cognos BI,Cognos TM1
Version: Cognos TM1 5.1
Excel Version: 2007

RAM SIZE Details

Post by manchala »

Hi

Could any body tell that how much ram size is required for Cognos TM1 9.5.2 + 2008r2 OS

Currently we are using 12 GB RAM for 64 bit server is that enough?

Thank you
--Kumar
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: RAM SIZE Details

Post by declanr »

You can run tm1 on that but whether you can run YOUR model depends enirely on your model; how much data there is, how rule heavy it is, whether you can write efficient rules and feeders, how many people will concurrently be using websheets etc.
Declan Rodger
lotsaram
MVP
Posts: 3703
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: RAM SIZE Details

Post by lotsaram »

To further what Declan said; TM1 is an in-memory database. The whole database content is loaded in RAM so how much memory you need depends entirely on how much data you have and how it is organised.

Other than that there really is no answer to your question.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
manchala
Posts: 17
Joined: Tue Feb 26, 2013 1:32 pm
OLAP Product: Cognos BI,Cognos TM1
Version: Cognos TM1 5.1
Excel Version: 2007

Re: RAM SIZE Details

Post by manchala »

Hi

Thank you for your response.

The concurent users are 60
--Kumar
lotsaram
MVP
Posts: 3703
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: RAM SIZE Details

Post by lotsaram »

manchala wrote:Hi

Thank you for your response.

The concurent users are 60
:lol:
Brick wall .... like .... talking to.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: RAM SIZE Details

Post by TrevorGoss »

Manchala,

if I were you I would set up some sort of automatic system that monitors your RAM usage for your server/servers. A system that monitors the RAM usage of each TM1 service as well as the RAM usage as a whole.

As the others have said, TM1 is an in-memory database, and if you run out of RAM suddenly, your system will be in trouble.

12GB may well be enough but checking the usage of each service will help you decide if you need more RAM or not. It will also help you find out what services are taking up more RAM and why.

Be careful with Persistant Feeders, some of them can get quite big.
User avatar
mattgoff
MVP
Posts: 516
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: RAM SIZE Details

Post by mattgoff »

TrevorGoss wrote:Be careful with Persistant Feeders, some of them can get quite big.
Why would persistent feeders affect RAM usage? In my (relatively small/new) experience with them, RAM usage is actually substantially lower since the garbage memory allocated at startup with MaximumCubeLoadThreads seems to be eliminated if a valid .feeders file is available at server start.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
TrevorGoss
Community Contributor
Posts: 217
Joined: Thu Aug 15, 2013 9:05 am
OLAP Product: TM1
Version: 10.2.1.1
Excel Version: 14.0.6129.5000

Re: RAM SIZE Details

Post by TrevorGoss »

Why would persistent feeders affect RAM usage?
I was referring to the FEEDERS when loaded into memory. the .FEEDER files can give a good indication of your FEEDER usage, but you are right, the .FEEDER files themselves would not effect RAM.
In my (relatively small/new) experience with them, RAM usage is actually substantially lower since the garbage memory allocated at startup with MaximumCubeLoadThreads seems to be eliminated if a valid .feeders file is available at server start.
It is possible that this parameter is left out of someones TM1 setup. With conditional FEEDERS, it is recommended that this be the case.

Thanks for the response.

Trevor.
Post Reply