Re: CPU usage

In <1vaodqINNndm@emory.mathcs.emory.edu> eric@carsinfo.com (Eric E. Bardes) writes: >> Recently another group joined us on our development platform and >> brought with them an Ingres engine. Performance on the box >> immediately degraded. Just now I looked out there and discovered the >> Ingres engine had been up for 36 days - in that time it had racked up >> 1448:40 of cpu time! Comparatively our FOUR Online engines have been >> up for 115 days and have racked up a total of :58 - now I don't know >> what they are doing up there but this seems like quite a disparity. >Much of the real work done by OnLine is done by the sqlturbo processes. >They do the parsing, optimizing, disk reads and writes. The Tbinit >processes simply coordinate this effort among all the other sqlturbo's >so that no two processes duplicate work. Remember that the usercpu and syscpu counts in the tbstat -p profile reputedly reflect the sum of the cpu resources used by all user processes (which I have always interpreted to mean sqlturbos). What's the total cpu for all four sets of daemons plus all four profiles Jack? We're still on dodgy ground as I don't know if Informix's definition of "user processes" includes the daemons or not. Maybe davek, jleffler or cortesi could tell us? Anybody know if the cpu stats in the profile are reliable? graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.