Re: Performance Problems after Upgrade to 7.23UC6

Hi John, unfortunately, i am not very familiar with HPUX, but nevertheless i have a suggestions for you: I think the problem has to do with memory. A point that supports this suggestion is the fact that the problems occur with 30 users and more. The reason could be that the oninit processes of version 7.23.UC6 need more memory than those of 7.14.UD1. You can calculate the memory needed with a formula published by Elisabeth Suto (see ISBN at the end of this posting): 1. Calculate the size of text and data for one oninit process Therefore, execute the command size $INFORMIXDIR/bin/oninit. Use the first part of the output as size of the text segment, while the other part is the size of the data segment. All oninit processes running on your system are sharing the text segment. The data segment is allocated for each oninit process. So, the complete memory comsumption of the oninit process is text segment + n * data segment, where n is the number of oninits 2. Get the currently allocated shared memory size. Execute onstat -. 3. Add all the values you computed before. Another indicator for memory problems is the number of page faults per second. You can figure out this value by executing sar -p. Check for other shared memory segments allocated on your system. You get a list of all currently allocated segments and their size by executing ipcs - am. This output contains the size of each segment. Hope this helps, Dirk ================================================================ Dirk Schmidtpott Q.4 IBS GmbH Fon : 0049-5251-893-212 A Baan Company Fax : 0049-5251-893-300 Riemekestra'e 160 Mail: dschmidt@baan.com D-33106 Paderborn ================================================================ P.S.: Elisabeth Suto, INFORMIX Performance Tuning, Prentice Hall ISBN 0-13-239237-2 In article <6fqviv$nbl$1@news.xmission.com>, John DeSilva <jads@mcs.bm> wrote: > > > ??????????? All suggestions greatly appreciated ??????????????? > > We have just recently upgrade a client machine from HPUX 9.04 / Online = > 7.14UD1 > to HPUX 10.20 Online 7.23UC6 and have suffered an incredible performance = > drop in the process. > The machine is a uniprocessor HP9000 G50 with 384 MB Ram. We were able = > to run 40 - 44 users at very acceptable speeds under 7.14 but at around = > 30 users under 7.23 the machine takes a serious nose dive ( 5 -10 times = > slower ). > We have contacted infomix tech support who had us dbexport/dbimport the = > entire DB and run an update statistics. > We also contacted HP who had us change the DBC_MAX_PCT kernal parameter = > from 50% to 15% ( something to do with pseudoswap ). > None of these have had any significant impact although the kernal = > parameter did appear to have some affect. > The primary bottleneck apears to be the CPU. Under sar -u the system and = > user cpu usage are about equal at 50% with 0% appearing in wio and idle. > Swapinfo shows us no swapping to the two swap devices that we have but a = > new memory line showing 50% swapped ( again something to do with = > pseudoswap according to HP ). > All Online parameters were left the same as under 7.14. > I have check those parameters which the 7.2 performance tuning guide say = > affect CPU usage and all appear to be correct. > The client has a new D370 2-way on order but it is not expected to = > arrive for another 3 weeks with installation not due till the first week = > of May. > > Has anyone had similar experiences with Online 7.23 and HPUX 10.20 ??? > Any suggestions on what might be causing this and any possible solutions = > ??? > > John DeSilva > MCS Limited > jads@mcs.bm > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading