| Author |
How to get Windows Process ID (PID)
|
|
| David Kerber 2005-12-19, 8:24 pm |
| If I have multiple instances of the ASA engine running on a machine, how
can I get the PID (as shown in the Windows Task Manager) of a specific
engine or database? I need to figure out which instance is using all my
CPU time...
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| Pavel Karady 2005-12-20, 3:23 am |
| "David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
news:MPG. 1e10f8096ba157a59897
c3@forums.sybase.com...
> If I have multiple instances of the ASA engine running on a machine, how
> can I get the PID (as shown in the Windows Task Manager) of a specific
> engine or database? I need to figure out which instance is using all my
> CPU time...
Shutting the servers down one-by-one doesn't help on this?
Pavel
| |
| David Kerber 2005-12-20, 7:23 am |
| In article <43a7c60f@forums-1-dub>, pavel_ns. ns_karady@ns_kogerus
a.com
says...
> "David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
> news:MPG. 1e10f8096ba157a59897
c3@forums.sybase.com...
>
> Shutting the servers down one-by-one doesn't help on this?
Yes, but then I'm shutting down apps which aren't having any problems,
just to find out which one is having problems.
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-12-20, 11:23 am |
| Open all the engine windows so they show in your task bar as opposed to the
system tray. Open the Task Manager and go to the applications tab. In this
tab you can see the names of all the engines that are running. One by one,
right-click on the engine and select "Go to process". You'll now be in the
process list, and you can see if the engine name you just selected from the
applications list is the one that is eating up your CPU. If you really need
the process ID, under the view menu, choose "select columns..." and make
sure you've checked off "PID".
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"
"David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
news:MPG. 1e10f8096ba157a59897
c3@forums.sybase.com...
> If I have multiple instances of the ASA engine running on a machine, how
> can I get the PID (as shown in the Windows Task Manager) of a specific
> engine or database? I need to figure out which instance is using all my
> CPU time...
>
> --
> Remove the ns_ from if replying by e-mail (but keep posts in the
> newsgroups if possible).
| |
| David Kerber 2005-12-20, 1:23 pm |
| In article <43a8351e$1@forums-1-dub>, FirstName.LastName@ianywhere.com
says...
> Open all the engine windows so they show in your task bar as opposed to the
> system tray. Open the Task Manager and go to the applications tab. In this
> tab you can see the names of all the engines that are running. One by one,
> right-click on the engine and select "Go to process". You'll now be in the
> process list, and you can see if the engine name you just selected from the
> applications list is the one that is eating up your CPU. If you really need
> the process ID, under the view menu, choose "select columns..." and make
> sure you've checked off "PID".
Unfortunately, that requires the services to be running in "allow
service to interact with the desktop" mode, which mine aren't.
I guess I'll post an enhancement request for the PID to be shown in the
server properties display in scjview.
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| Scott Holman 2005-12-20, 1:23 pm |
| In 9.0.2 you can monitor cpu usage via dbConsole server properties. This
might help you isolate the specific server.
| |
| Bruce Hay 2005-12-20, 1:23 pm |
| You might try TLIST.EXE or TASKLIST.EXE. For example, on XP:
tasklist /FI "imagename eq dbsrv9.exe" /V
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
news:MPG. 1e120909c178bf9a9897
c5@forums.sybase.com...
> In article <43a8351e$1@forums-1-dub>, FirstName.LastName@ianywhere.com
> says...
the[color=darkred]
this[color=darkred]
one,[color=darkred]
the[color=darkred]
the[color=darkred]
need[color=darkred]
>
> Unfortunately, that requires the services to be running in "allow
> service to interact with the desktop" mode, which mine aren't.
>
> I guess I'll post an enhancement request for the PID to be shown in the
> server properties display in scjview.
>
> --
> Remove the ns_ from if replying by e-mail (but keep posts in the
> newsgroups if possible).
| |
| David Kerber 2005-12-20, 1:23 pm |
| In article <43a84a1c@forums-1-dub>, sholman@micros.com says...
> In 9.0.2 you can monitor cpu usage via dbConsole server properties. This
> might help you isolate the specific server.
Can you tell me how to get that to show? I can't find that
option/setting/item in dbConsole...
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| David Kerber 2005-12-20, 1:23 pm |
| In article <43a84ce6@forums-1-dub>, "Bruce Hay"
< h_a_y~a_t~i_a_n_y_w_
h_e_r_e~d_o_t~c_o_m> says...
> You might try TLIST.EXE or TASKLIST.EXE. For example, on XP:
> tasklist /FI "imagename eq dbsrv9.exe" /V
Do you know what it might be on Win2000 server? It doesn't find
tasklist.exe, nor tlist.exe.
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
> "David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
> news:MPG. 1e120909c178bf9a9897
c5@forums.sybase.com...
> the
> this
> one,
> the
> the
> need
>
>
>
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| Bruce Hay 2005-12-20, 8:24 pm |
| No, sorry. There is a ProcessExplorer at www.sysinternals.com that might do.
Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
news:MPG. 1e1223c2728d12a99897
c8@forums.sybase.com...
> In article <43a84ce6@forums-1-dub>, "Bruce Hay"
> < h_a_y~a_t~i_a_n_y_w_
h_e_r_e~d_o_t~c_o_m> says...
>
> Do you know what it might be on Win2000 server? It doesn't find
> tasklist.exe, nor tlist.exe.
>
>
to[color=darkred]
In[color=darkred]
by[color=darkred]
in[color=darkred]
from[color=darkred]
really[color=darkred
]
make[color=darkred]
the[color=darkred]
>
> --
> Remove the ns_ from if replying by e-mail (but keep posts in the
> newsgroups if possible).
| |
| Scott Holman 2005-12-20, 8:24 pm |
| Select File|Options from the dropdown menu
Select 'Property Viewer' from the Options dialog
Select 'Server Properties' tab; scroll down to ProcessCpu and enable
Set the refresh rate
Close the dialog
Select the 'Server' tab on properties window. You should now see the
property value.
"David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
news:MPG. 1e1222f51e83a9bf9897
c7@forums.sybase.com...
> In article <43a84a1c@forums-1-dub>, sholman@micros.com says...
>
> Can you tell me how to get that to show? I can't find that
> option/setting/item in dbConsole...
>
> --
> Remove the ns_ from if replying by e-mail (but keep posts in the
> newsgroups if possible).
| |
| David Kerber 2005-12-20, 8:24 pm |
| In article <43a87012$1@forums-1-dub>, sholman@micros.com says...
> Select File|Options from the dropdown menu
> Select 'Property Viewer' from the Options dialog
> Select 'Server Properties' tab; scroll down to ProcessCpu and enable
> Set the refresh rate
> Close the dialog
> Select the 'Server' tab on properties window. You should now see the
> property value.
Ahhhh, there it is!! I had missed the separate tab for the server
properties when I was looking before...
It doesn't show the CPU percentage like task manager does, but it should
be enough for what I need; I'll just look for which engine's values are
incrementing faster than the others.
Thanks for the help!
>
> "David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
> news:MPG. 1e1222f51e83a9bf9897
c7@forums.sybase.com...
>
>
>
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| Scott Holman 2005-12-20, 8:24 pm |
| ProcessExplorer by SysInternals will show you the command line used to
launch dbsrv9.exe. Presumably each instance of dbsrv9 was started with a
distinct server name on the command line.
"David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
news:MPG. 1e123a83a3350279897c
a@forums.sybase.com...
> In article <43a87012$1@forums-1-dub>, sholman@micros.com says...
>
> Ahhhh, there it is!! I had missed the separate tab for the server
> properties when I was looking before...
>
> It doesn't show the CPU percentage like task manager does, but it should
> be enough for what I need; I'll just look for which engine's values are
> incrementing faster than the others.
>
> Thanks for the help!
>
>
>
>
> --
> Remove the ns_ from if replying by e-mail (but keep posts in the
> newsgroups if possible).
| |
| David Kerber 2005-12-22, 9:23 am |
| In article <43a87630$1@forums-2-dub>, sholman@micros.com says...
> ProcessExplorer by SysInternals will show you the command line used to
> launch dbsrv9.exe. Presumably each instance of dbsrv9 was started with a
> distinct server name on the command line.
Yes, they were.
>
> "David Kerber" < ns_dkerber@ns_wraenv
iro.com> wrote in message
> news:MPG. 1e123a83a3350279897c
a@forums.sybase.com...
>
>
>
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
|
|
|
|