Troubleshooting performance problem
Posted in 2003
Hi everybody 1) Does Informix-Online Ver 5.11.HC1 supports multi-threading ? 2) With the above version which has limited tools/utility, how can I go about to troubleshoot slow respond from SELECT command ? This Informix is running under HP-UX 11. 3) What does the output below tells us ? Why there are so many of sharers waiting for 1 piece of buffer ? Where went wrong ? Thank you. Buffers (Access) address owner flags pagenum memaddr nslots pgflgs sharers waiter c2e4d604 0 100 3072f5 c3c4c800 1 90 c23184f4 0 c2e4ec94 0 100 30704b c3c72800 1 90 c23192d4 0 c2e51a98 0 100 322967 c3cc0000 39 b0 c23183cc 0 c2e6315c 0 0 307053 c3e95800 6 2001 0 0 c2e695b4 0 100 307b6e c3f3e800 52 90 c231df24 0 c2e88efc 0 0 307bdc c4291800 41 90 0 0 c2e8e728 0 100 307b39 c4326000 39 90 c2318054 0 c2ee4304 0 100 30839a c4c2c800 46 90 c2319aec 0 c2f554c4 0 0 307b4f c5814800 39 90 0 0 c3067634 0 100 307b72 c74ee800 52 90 c2317f2c 0 c3076154 0 100 307b3a c767a800 36 90 c23184f4 0 c307832c 0 100 308301 c76b3800 39 30 c2319aec 0 c307d3a0 0 0 307b66 c773b000 50 90 0 0 c3172ab0 0 0 307bb0 c9111000 48 90 0 0 c3174600 0 0 307bcd c913f000 64 90 0 0 c3195080 0 100 307b30 c94af000 45 30 c23177a8 0 c23179f8 0 c2317b20 0 c2317c48 0 c2317cdc 0 c2318054 0 c23180e8 0 c2318460 0 c231861c 0 c23187d8 0 c231a1dc 0 c231b3c8 0 c231ba24 0 c231bd9c 0 c231ce60 0 c231dcd4 0 c231de90 0 c231df24 0 c231dfb8 0 c231e0e0 0 c231e580 0 c231e614 0 c31b96f8 0 0 30be54 c9884000 30 1 0 0 1356 modified, 60000 total, 65536 hash buckets, 2048 buffer size