Find the name of the TM1 instance from the process ID

Post Reply
Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

Find the name of the TM1 instance from the process ID

Post by Sandhya Kumar »

Hi all,

Is there some way to find which Process ID corresponds to which TM1 instance running on a particular server? The version is 9.1

We have two TM1 instances running in our Production server. We got the screen-shot of the task manager from our IT team which just gives info about two tm1sd.exe processes. i want to find out which tm1sd.exe corresponds to which TM1 instance. I have their process ID's.

I checked in server logs, TM1 client etc., I do not find this info. Please help.
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Find the name of the TM1 instance from the process ID

Post by Alan Kirk »

Sandhya Kumar wrote:Hi all,

Is there some way to find which Process ID corresponds to which TM1 instance running on a particular server? The version is 9.1

We have two TM1 instances running in our Production server. We got the screen-shot of the task manager from our IT team which just gives info about two tm1sd.exe processes. i want to find out which tm1sd.exe corresponds to which TM1 instance. I have their process ID's.

I checked in server logs, TM1 client etc., I do not find this info. Please help.
The best way is to make copies of the tm1sd executable files, naming them differently of course, and install the services separately using those two .exes. In that way the Process manager shows two different names. This is discussed in more detail in my post Introductory "How To" guide for installing TM1 Servers. It's about half way down; just search for the text "where xxx is a code that allows me to tell which TM1 server it's referring to" in the post.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: Find the name of the TM1 instance from the process ID

Post by Gregor Koch »

Hi
Another option would be to use a tool like 'Process Explorer' available from MS website.
Cheers
Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

Re: Find the name of the TM1 instance from the process ID

Post by Sandhya Kumar »

Oh.. I will keep that in mind when we set up a server next time. I was hoping there will be some easy way to find this out :shock:

Thanks Alan and Gregor :)
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Find the name of the TM1 instance from the process ID

Post by Alan Kirk »

Sandhya Kumar wrote:Oh.. I will keep that in mind when we set up a server next time. I was hoping there will be some easy way to find this out :shock:

Thanks Alan and Gregor :)
Well in as a short term quick & dirty fix... run a honking great calculation or a TI that loops for about 5 minutes on one of them and watch to see which process' CPU usage spikes! :D
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

Re: Find the name of the TM1 instance from the process ID

Post by Sandhya Kumar »

LOL!! That's a good idea :)
Neil Watson
Posts: 32
Joined: Wed May 28, 2008 11:41 am
OLAP Product: TM1
Version: 6 and 2.5 to 10.2.2
Excel Version: 2007 2010
Location: Northern England
Contact:

Re: Find the name of the TM1 instance from the process ID

Post by Neil Watson »

Hey there,

When you've created multiple instances running on the same server you still won't , in task manager, be able to see which is which, as they will all show as tm1sd.exe in the service list.

However, you can get task manager to show the PID as a column in the display, (View select columns) then run "tasklist /svc" from a command prompt.

Matching the two PID's together shows which service is which.

You can use this to find out how much RAM each instance is using, which service is hogging the processors etc.

Cheers
Neil
dludwig
Posts: 15
Joined: Sat Mar 21, 2009 6:59 pm
Version: 9.4
Excel Version: 2007

Re: Find the name of the TM1 instance from the process ID

Post by dludwig »

you can execute this from the cmd prompt and it will give you the PID:

sc \\servername queryex tm1servicename

so if your TM1 service is called 'planning' and it is running on a server called \\server1 the command would look like this:

sc \\server1 queryex planning

you can run this from your computer...it does not have to be executed from the command prompt on the server.
User avatar
garry cook
Community Contributor
Posts: 209
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: Find the name of the TM1 instance from the process ID

Post by garry cook »

Just slight tweak to the bit above, we tend to use

tasklist /svc | find “tm1sd.exe”

from cmd prompt to narrow it down.
dubs
Posts: 131
Joined: Fri May 22, 2009 10:43 am
Version: 9.4
Excel Version: 2003

Re: Find the name of the TM1 instance from the process ID

Post by dubs »

I have linked a TM1 service to a process before in VB.NET, will try and dig out my code when i get a mo but if i remember rightly the only way i could do it was to use the processId that i got using the service object in WMI
Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

Re: Find the name of the TM1 instance from the process ID

Post by Sandhya Kumar »

Thanks guys.

I tried out the commands and they get me the exact tm1 instance name. :)

But for production boxes for which I do not have access, I don't think I can use these commands. Any ideas?
Post Reply