Performance Problem.Help!!!

[VaSC_LYN]

I got a tough customer who is running Informix
Application on our HPUX platform.they complained the application ran quite slow,and he already let his vendor check the database,no better solution.now cu came back.
wanna us prove ours is fine.I collect some data form the issued boxes,no obvious bottleneck.the attached file is the data.could me give me some little light on it how to prove ours is fine?thx very much.

[Hein van den Heuvel]

Based on the output provided, I would suspect the IO subsystem. The ioscan output mentions: BF07258243 that itself is an 72GB, 15Krpm drive for an EVA.
How is that exactly connected?

If you grep the sar -d output for c8t3d0 | c7t3d0 then you see nice/normal response times of about 4ms as long as they each stay below 180 IO/sec. As they go above that, the avserv jumps to 15ms or even 20ms.
A typical application would feel that as a slow-down.

Are those luns carved from the same group? How many drives in the group?


Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting


16:59:36 device %busy avque r+w/s blks/s avwait avserv
Average c7t3d0 77.44 0.76 201 829 6.15 6.76
Average c8t3d0 59.89 0.81 147 609 6.60 7.13