RE: "Slow System" Problem
Are you sure you are bottlenecked on CPU? Check sar when this happens to
make sure.
If that's the case, you can track the most active sessions by looking at
which ones show up on the active queue(onstat -g act) most often. That can
be a problem if you have a lot of users and several CPU virtual processors.
I've got a script I can send you that runs "onstat -g act -r 1" in the
background and then will output all sessions rstcb sorted by how often they
were on the active queue. It will then prompt you for the rstcb you want to
investigate and map it to the session and process. Let me know if you want
a copy.
Regards,
Bill Dare
> -----Original Message-----
> From: Zev Berezin [SMTP:zevb@bhphotovideo.com]
> Sent: Wednesday, May 14, 2003 11:20 AM
> To: informix-list@iiug.org
> Subject: "Slow System" Problem
>
> Hi All,
>
> Tech Specs:
> IDS: 7.31.UD5W5 - O.S: Solaris 6 - 10 CPU 248 MHZ
>
> I have a situation where the OLTP system usually hums along
> great but at times slows down drastically.
> This can happen at any time of the day (so forget the crons).
> It would be great to be able to pinpoint the sessions causing the
> problem or to be able to track CPU usage by session.
> At times I would kill the sessions where onstat -u showed the most
> reads and/or writes but that wouldn't help.
> Any help is greatly appreciated.
>
> TIA,
> Zev Berezin