Re: Bad performance
You need to look at your SQL and how it is being optimised. Without
that there is nothing useful about the diagnostics you posted.
Andy
"R'diger M'hl" <ruediger.maehl@web.de> wrote in message news:<Xns939D664E7CD70ruedigermaehlwebde@193.101.67.2>...
> Hi folks,
>
> we have three servers running Linux (SLES7) and
> Informix 9.30 (2x) and 9.21 (1x). A developer
> has run a script against 9.21 and it worked
> fine and performantly. Now running it against
> the 9.30ies shows a very bad performance.
>
> Has somebody perhaps an idea of what is the problem?
>
> Checkpoints are ok at 0 secs.
>
> One thing that I remarked was the the syscpu
> time for the adm vp in onstat -g glo:
>
> at 15:00h, before the script started, everything ok.
> ------------------------------------------------------------
> Informix Dynamic Server Version 9.30.UC2 -- On-Line -- Up 8 days
> 06:05:56 --
>
> MT global info:
> sessions threads vps lngspins
> 0 60 40 7251
>
> sched calls thread switches yield 0 yield n yield
> forever
> total: 144106883 101185476 43085549 5878004 13642155
> per sec: 4 4 0 2 0
>
> Virtual processor summary:
> class vps usercpu syscpu total
> cpu 3 16688.20 1230.46 17918.66
> aio 32 278.96 1521.65 1800.61
> lio 1 4.09 21.07 25.16
> pio 1 2.60 23.30 25.90
> adm 1 10.08 32.21 42.29
> soc 1 288.89 1586.73 1875.62
> msc 1 0.55 0.58 1.13
> total 40 17273.37 4416.00 21689.37
> ------------------------------------------------------------
>
> made an onstat -z
> at 16:00h, the script is running for about 45 mins, adm very high.
>
> ------------------------------------------------------------
> Informix Dynamic Server Version 9.30.UC2 -- On-Line -- Up 8 days
> 07:05:55 --
>
> MT global info:
> sessions threads vps lngspins
> 1 61 40 0
>
> sched calls thread switches yield 0 yield n yield
> forever
> total: 154699 151170 3464 3411 72882
> per sec: 326 321 5 8 155
>
> Virtual processor summary:
> class vps usercpu syscpu total
> cpu 3 10.35 0.99 11.34
> aio 32 0.24 0.81 1.05
> lio 1 0.07 0.16 0.23
> pio 1 0.01 0.03 0.04
> adm 1 2.60 631.13 633.73
> soc 1 0.02 0.00 0.02
> msc 1 0.00 0.00 0.00
> total 40 13.29 633.12 646.41
> ------------------------------------------------------------
>
> at 17:00h, script is still running, adm still using more power.
>
> ------------------------------------------------------------
> Informix Dynamic Server Version 9.30.UC2 -- On-Line -- Up 8 days
> 08:05:55 --
>
> MT global info:
> sessions threads vps lngspins
> 1 61 40 0
>
> sched calls thread switches yield 0 yield n yield
> forever
> total: 571660 557884 13572 12492 268611
> per sec: 302 297 5 8 142
>
> Virtual processor summary:
> class vps usercpu syscpu total
> cpu 3 37.82 3.56 41.38
> aio 32 0.93 2.94 3.87
> lio 1 0.18 0.97 1.15
> pio 1 0.03 0.06 0.09
> adm 1 9.55 2317.79 2327.34
> soc 1 0.09 0.13 0.22
> msc 1 0.00 0.00 0.00
> total 40 48.60 2325.45 2374.05