Find the name of the TM1 instance from the process ID
-
- 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
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.
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.
-
- 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
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.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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
Hi
Another option would be to use a tool like 'Process Explorer' available from MS website.
Cheers
Another option would be to use a tool like 'Process Explorer' available from MS website.
Cheers
-
- 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
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
Thanks Alan and Gregor

Thanks Alan and Gregor

-
- 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
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!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![]()
Thanks Alan and Gregor

"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
LOL!! That's a good idea 

-
- 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
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
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
Re: Find the name of the TM1 instance from the process ID
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.
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.
- 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
Just slight tweak to the bit above, we tend to use
tasklist /svc | find “tm1sd.exeâ€
from cmd prompt to narrow it down.
tasklist /svc | find “tm1sd.exeâ€
from cmd prompt to narrow it down.
Re: Find the name of the TM1 instance from the process ID
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
-
- 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
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?
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?