Export or email memory usage

Post Reply
ravi
Posts: 138
Joined: Mon Apr 26, 2010 12:39 pm
OLAP Product: cognos
Version: tm1 9.5
Excel Version: 2007

Export or email memory usage

Post by ravi »

Hi All,

We are currently monitoring the tm1 server memory usage for our tm1 model.
In this regard, I would like to have tm1 cube memory size and dimension size and data directory size etc.....
generated in CSV file or email alerts to know current memory usage in tm1 model in server.
Currently memory size of cubes and dim- I am manually checking it in tm1 perspective server explorer to know memory usage.

Is there way you can suggest to write IT proces.......?

Thanks and Regards,
Ravi
declanr
MVP
Posts: 1831
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: Export or email memory usage

Post by declanr »

ravi wrote:Hi All,

We are currently monitoring the tm1 server memory usage for our tm1 model.
In this regard, I would like to have tm1 cube memory size and dimension size and data directory size etc.....
generated in CSV file or email alerts to know current memory usage in tm1 model in server.
Currently memory size of cubes and dim- I am manually checking it in tm1 perspective server explorer to know memory usage.

Is there way you can suggest to write IT proces.......?

Thanks and Regards,
Ravi
As long as you already know which cubes the data you wish to view is held in why can't you just use asciioutput to create your CSV file within a TI and then something like sendemail.exe within another TI (described extensively on this forum) to pick up that CSV file and send it as an attachment?

If there is a specific part of the process you are struggling with, then I'm sure we will be able to point you in the right direction.
Declan Rodger
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: Export or email memory usage

Post by Darkhorse »

Do you have an email system pearl script configured to use Ravi?
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: Export or email memory usage

Post by PlanningDev »

If you don't want to create your own take a look at Blat.exe command line smtp emailer.

It takes care of attachments, HTML emails, etc. super easy to use. We built a standard process for sending emails. That intakes parameters and builds the command line call dynamically so anyone can send emails from TM1.
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Export or email memory usage

Post by macsir »

I think gathering server physical memory uasge info is more practical to prevent server crash. As long as your cubes can live with current server's memory, it is meanless to check them all the time. Unless you use up all your server memory, it is time to re-order or clean up tm1 objects.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply