Re: sizing an sqlturbo process

In article <1lrk7fINNab9@emory.mathcs.emory.edu>, pete@wvus.org (Pete Gregory) writes: > hi... we're running Informix 4.10 on Unisys/Sequent/PTX systems. I'm > conducting a study of how much memory each informix user requires. > > It's easy enough to measure the RSS (resident set size) of each process. > What's not easy is, for sqlturbo in particular, how much of that size > (they are observed to be anywhere from 900KB to 10MB) is 'owned' solely by > that sqlturbo process and not part of the Informix page buffer (shared > memory) or shared by other sqlturbo processes. > > Anyone have the inside on this? 10MB - that sounds pretty bad!!! I don't believe ANY of the memory is shared - it's ALL process space. Too much of this, and you start to see thrashing. [not a performance enhancement, by any means]. We've been working with Informix support for 6 months to resolve this problem. Our servers are up for weeks/months, and continue to grow. The latest Online 4.10 release is UG2 - it has some bug fixes in it that resolve problems, although WE'RE STILL SEEING GROWTH. Our only current work-around is to monitor the total memory used, compare to our swap space, and when we get too close, we start killing processes. UGLY, to say the least. Hope this helps, Standard discalimers apply. Ihor Kinal att!trumpet!ijk