CPUs spike

Hi all, We have IDS 11.50.FC8GE runs in HP-UX 11.11. The server has four CPUs and it has been running quite well for the last few years. The server has only IDS installed and nothing else. Few days ago, users reported that they are having performance issue. We look around in the server, and from top utility we see three of the four CPUs in the server are always max to 90 plus percent by Informix user. Do you know what’s causing the CPUs spike or how to catch what causing the spike?

That's a multistep process: - onstat -g cpu or onstat -g glo in combo with your top display to determine which CPU VPs are spinning the processors - onstat -g act to identify active threads, what they are doing, which CPU VP they are running on, and what the rstcb key for the thread is. - onstat -u to map the rstcb key to the 'user thread address' to find the session id. - onstat -g <session id> to see who the user is, its pid, and the query(s) it's running. If the rstcb is 0 then it is an internal thread and the thread name will identify what it is (ie aio, kaio, listener, soctcppoll, sm_poll, etc.). It might be a hung thread that once belonged to a session opened from a windows based client. Windows apps are notiriously bad at properly closing TCP connections especially if the user clicks the big red eXit button and that can leave a thread spinning trying to return a buffer to a client who's no longer there. If that's the case, the only solution will be to bounce the server. If you can't track this down or it keeps coming back and it's still causing performance problems, ping me privately and I can consult. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Sep 11, 2013 at 10:20 AM, TRI TRINH <tri_trinh@hotmail.com> wrote: > Hi all, > We have IDS 11.50.FC8GE runs in HP-UX 11.11. The server has four CPUs and > it > has been running quite well for the last few years. The server has only IDS > installed and nothing else. Few days ago, users reported that they are > having > performance issue. We look around in the server, and from top utility we > see > three of the four CPUs in the server are always max to 90 plus percent by > Informix user. Do you know what’s causing the CPUs spike or how to catch > what > causing the spike? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01160938bede1d04e61cabda

Thank you very much for the advice.