RE: "Slow System" Problem
you check te output from onstat -m? see the checkpoint duration o some other
info in the .log file. (longs tx, etc.)
-----Mensaje original-----
De: Zev Berezin [mailto:zevb@bhphotovideo.com]
Enviado el: Mi'rcoles, 14 de Mayo de 2003 12:20 p.m.
Para: informix-list@iiug.org
Asunto: "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