How do I free up memory space?

Post Reply
joannetheodore
Posts: 9
Joined: Thu Mar 25, 2010 10:55 am
OLAP Product: TM1
Version: 9.1 sp2
Excel Version: 2003

How do I free up memory space?

Post by joannetheodore »

Hi there,

My client has just about run out of memory on their TM1 server.

I think I need to get rid of all the old transaction logs to free up some space...

Where do I find / delete these transaction logs??

Many thanks in advance!

Jo
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: How do I free up memory space?

Post by stephen waters »

Jo,
I assume you mean the server is running out of hard disk space rather than RAM. If so, look at the "LoggingDirectory" parameter in the tm1.cfg file
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: How do I free up memory space?

Post by lotsaram »

joannetheodore wrote:My client has just about run out of memory on their TM1 server.
I think I need to get rid of all the old transaction logs to free up some space...
Where do I find / delete these transaction logs??
Your client? Does one at least read the available manuals before offering one's services as a consultant these days or is that no longer necessary?
User avatar
Steve Rowe
Site Admin
Posts: 2456
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: How do I free up memory space?

Post by Steve Rowe »

Hi Joanne,
I'm going to assume that when you talk about memory you are talking about RAM. The log files are stored on the hard drive and have no impact on the RAM usage of the server, of course these can be deleted from time to time to free up space on the hard drive as required. They would normally be stored in the LoggingDirectory or DataDirectory and this can be found by looking in the config file or the message log of the server (it's buried in the stream of messages when the server starts).

If they are running out of RAM then I'm guessing it is a 32 bit environment. There are a few options.
1. If they have not applied the "3G switch" and their OS supports it then apply it, this will extend the RAM available to the server from 2G to 3G.
2. Upgrade to 64 bit hardware and software.
3. If you can't change TM1s operating environment then you will have to change the TM1 application to reduce the RAM usage. Typically this is done by reducing the functionality of the application (i.e. by removing cubes that use a lot of RAM but are not used, or splitting the application into two halves across different servers) or clearing historical data from cubes. You can also look at efficiency gains by improving any rules and feeders in the system, depending on the level of competency of the person who built the system this can either lead to massive savings or minimal ones.

HTH
Cheers
Technical Director
www.infocat.co.uk
Post Reply