RE: Performance Issues
What version are you running? when given onstat -p its good to know
how long it has been since statistics were zeroed (or if they havent
when the server came up)
Comments embedded.
>===== Original Message From yener@my-deja.com =====
>Hi,
>
>We are currently running informix on E5000 system which 4 CPUs and 2 MB
>of RAM. We have got some performance problems on this system.
>
>The performance of the application running on this system is not
>comparable what we had expected. The system is a batch processing
>system.
>
>We analys the system and unable to find any suitable solution to
>improve performance.
>
>The listing below shows the output of onstat -p.
>================================================
>
>dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
>4043750739 59853281 604861800 0.00 122732622 70823866 1106184833
>88.90
This states you have more dskreads than you have pagreads and that you
have more dskwrits than pagwrits, thatt is a bit confusing to me, you might
zero statistics, let it run for a day and the post the results along with
how long it has been since statistics have been zeroed.
>
>isamtot open start read write rewrite delete commit
>rollbk
>1018217434 2365010653 400986740 1380105727 152884987 127463044 8803283
>39620880
> 366903
>
>gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
>0 0 0 0 0 0 0
>
>ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
>0 0 0 2000759.78 364288.72 8828 18200
>
>bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
>179603434 0 3227542476 0 0 18465 9537417
>11416813
>
>ixda-RA idx-RA da-RA RA-pgsused lchwaits
>1492613204 3357525 1959151075 3444017014 21784573
>
>and the following listing shows our onconfig file
While turning TBLSPACE_STATS to 0 will get you some improvement,
you might look at the statistics from it to find your most heavily
hit tables, so you might look at ways to make hitting those tables faster.
onstat -g iof
onstat -D
onstat -P | tail
onstat -m
all might be helpful.
Will
------------------------------------------------------------
This e-mail has been sent to you courtesy of OperaMail, as a free service from
Opera Software, makers of the award-winning Web Browser, Opera. Visit us at
http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail
account is waiting at: http://www.operamail.com/
------------------------------------------------------------