RE: Which thread consumes the most CPU time?

You have to monitor onstat -g act and see which sessions are active most often. A session is identified by the rstcb column. On a busy system with multiple CPUs this becomes quite a task. I have a shell script I use to monitor active threads and display a sorted list of the most active sessions. I use it when I have CPU usage problems. If you are on unix and want a copy, let me know. Bill > -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Christian Eriksson > Sent: Friday, February 18, 2005 4:56 AM > To: informix-list@iiug.org > Subject: Which thread consumes the most CPU time? > > Hi! > > I'm looking for some diagnostics in situations when the database > server's processes (oninit) starts to consume more CPU time. > > Is it possible to see which thread have consumed the most of the > Database Server's CPU time for, let's say, the last 10 minutes? > > Regards Christian Eriksson sending to informix-list

Onstat -g act is probably the simplest. But you also can use wait statistics. Set "WSTATS 1" in onconfig and use "onstat -g wst" or select from sysmaster:sysseswts. Michael Bill Dare wrote: > You have to monitor onstat -g act and see which sessions are active most > often. A session is identified by the rstcb column. On a busy system > with multiple CPUs this becomes quite a task. I have a shell script I > use to monitor active threads and display a sorted list of the most > active sessions. I use it when I have CPU usage problems. If you are on > unix and want a copy, let me know. > > Bill > > > >>-----Original Message----- >>From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] >>On Behalf Of Christian Eriksson >>Sent: Friday, February 18, 2005 4:56 AM >>To: informix-list@iiug.org >>Subject: Which thread consumes the most CPU time? >> >>Hi! >> >>I'm looking for some diagnostics in situations when the database >>server's processes (oninit) starts to consume more CPU time. >> >>Is it possible to see which thread have consumed the most of the >>Database Server's CPU time for, let's say, the last 10 minutes? >> >>Regards Christian Eriksson > > > sending to informix-list

Hi Bill, Can you email me the script too. Thanks Wayne