Identify Users Cosuming lots of CPU

dreseco

New Member
Hi DBAs!


Sometimes I have long CPU peeks, with taks Administrator, I get the Proc ID. I think this is a progress database broker, so behind should be a group of progress users.

Is there any way to relationate an intensive CPU NT-process, with progress user work?



Progress 8.3c
Windows NT 4.0 Sp 4.0
MFG 8.6e

daniel.reseco@bicworld.com
 

dreseco

New Member
Identify users consuming lots of CPU

Well I answer myselft... finally I got the solution!
Hope will be usefull for anyone else.

Using Promon go to the next menus.
R&D, 1, 4, 7
to get the relation between NT-Process ID and Progress Servers

R&D, 1, 4, 6
to get the relation between Progress Servers and Progress User.

So here you are!
NT-Process ID->Progress Server->Progress User...

I've made a small VB Application to process this info...

If anyone is interested , do not hesitate contact me !
 
Top