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.
Calculate Time taken for a TM1 server between start and be ready
-
- Posts: 80
- Joined: Tue Jun 04, 2013 3:35 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
-
- 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
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.
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
-
- 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
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.
-
- 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
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
- 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
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.
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
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.