Re: Fw: Fw: bad performance on irix

I've done some meditions with timex, it uses sar(System activity register)
to take workloads, it's not very relliable, but it allow us to see how it is
been doing, it has been taken during an execution of a like tpc-h
benchmark, it performs inserts, deletes(about 5% of the time of the
execution) and a set of 8 continous streams of 22 read only queries, notice
that it only gives idle time (not the cause of idle), notice semafores/sec
is up to 2700!!!!!!!
Regards
12:27:08 %usr %sys %intr %wio %idle %sbrk %wfs %wswp %wphy %wgsw %wfif
12:55:39 32 3 0 9 56 0 100 0
0 0 0 9% waiting for I/O which is
100% file system

12:27:08 device %busy avque r+w/s blks/s w/s wblks/s avwait
avserv
12:55:39 dks0d5 0 0.0 0.0 0 0.0 0 0.0
0.0
dks1d1 1 3.1 0.7 19 0.7 16 27.8
15.0
dks1d2 0 1.0 0.0 0 0.0 0 0.0
13.3
dks1d3 0 0.0 0.0 0 0.0 0 0.0
0.0
dks1d4 23 15.3 9.1 1705 7.8 1553 519.7
24.8

12:27:08 bread/s lread/s %rcach bwrit/s lwrit/s wcncl/s %wcach pread/s
pwrit/s
12:55:39 158 2372 93 1549 9072 1 83 0
0 93% of read cache hits and 83% of write chache hits

12:27:08 scall/s sread/s swrit/s fork/s exec/s rchar/s wchar/s
12:55:39 4618 181 126 0.18 0.06 648854 580354
syscalls averages

12:27:08 msg/s sema/s
12:55:39 0.00 2704.28

12:27:08 vflt/s dfill/s cache/s pgswp/s pgfil/s pflt/s cpyw/s
steal/s rclm/s notice that there aren't page swaps, so idle is not
waiting for paging
12:55:39 862.58 58.31 804.24 0.00 0.04 5.70 3.11 60.90
0.00

12:27:08 CPU %usr %sys %intr %wio %idle %sbrk %wfs %wswp %wphy %wgsw
%wfif
12:55:39 0 25 3 0 8 63 0 100 0 0
0 0 per CPU usage
1 25 3 0 9 62 0 100 0
0 0 0
2 24 3 0 9 64 0 100 0 0
0 0
3 30 3 0 8 59 0 100 0 0
0 0
4 30 3 0 8 59 0 100 0 0
0 0
5 39 3 0 8 50 0 100 0 0
0 0
6 54 3 0 8 34 0 100 0 0
0 0
7 33 3 0 8 55 0 100 0 0
0 0