Calculate Time taken for a TM1 server between start and be ready

Post Reply
LutherPaul
Posts: 80
Joined: Tue Jun 04, 2013 3:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Calculate Time taken for a TM1 server between start and be ready

Post by LutherPaul »

Hi All,
We want to create a share point page to display how long it takes to start a TM1 server. As we all know the process (TM1SD.exe) starts but server actually ready after loading all the cubes into memory.
Can anyone suggest a way to record the process start time into a database table? I don't want to read the log file from a TI process as the file grows large, the system gets hung. Server Ready Time can be obtained using startup chore. Ideally, I want a process within TM1 so it gets easy to manage.

Thanks,
Paul.
declanr
MVP
Posts: 1815
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: Calculate Time taken for a TM1 server between start and be ready

Post by declanr »

I can't think of anyway to do that in TM1 itself without reading the log file. In fact the only way I could think of getting that time when someone told the service to start, without using the log file; would be to actually record it as its started e.g. run the net start from a batch file that also records the time somewhere.
TM1 obviously cant do that as it hasn't started yet (unless you used another TM1 service to start it.)

There is also certainly a way you could get the info from windows process logs but I don't know them well enough to provide guidance on that.
Declan Rodger
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Calculate Time taken for a TM1 server between start and be ready

Post by tomok »

It's fairly easy to get the time when the service is ready, just create a process that writes the current time to the database and put in a chore that runs every minute. Once the service is up it will run. Just put a flag in the database to hold the fact that it has already been run so the process can be halted afterwards. It's getting the start time of the server load. The current service cannot do it because it isn't ready. However, you could trigger the service from a different TM1 service and use that service to write to the database. Not the most elegant way but it should work.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: Calculate Time taken for a TM1 server between start and be ready

Post by Paul Segal »

Powershell is your friend here: start the TM1 service using a powershell script which writes a time-stamp to a file, then performs a start-service on your tm1server. Once the server is up read the file with the time-stamp into TM1 as part of the startup chore as outlined by Tom and you have your answer.
Paul
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Calculate Time taken for a TM1 server between start and be ready

Post by jim wood »

You could start the service with a batch file that creates a file containing the current date and time. Then within Tom's chore that runs every miunte check to see if the file exists. If it does load the details then delete the file,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: Calculate Time taken for a TM1 server between start and be ready

Post by BrianL »

You could also try using the StartupChores config option to run your chore as the very last step in server startup. This would eliminate the need to schedule the chore to run every minute.
Post Reply