Performance issue on Solaris 8 -Has informix database running on it
Posted in 2006
Topics: Performance & Tuning, Platform-Specific Issues
Hello, We have this Solaris machine indicating high device busy times whenever the Informix application folks does a refresh operation. To my knowledge, they are copying data from one server to another. Here are the details: Server A: Active production server with single instance Server B: secondary machine with 3 instances Server A's /pdd02 is nfs mounted on server B( /GUMINFX). During the refresh operation, the data is copied from Server A to Server B(On /pdd03). >Here are the stats of Server B: > df -k Filesystem kbytes used avail capacity Mounted on /dev/md/dsk/d0 2053605 1689566 302431 85% / /dev/md/dsk/d1 4129290 1185053 2902945 29% /usr /proc 0 0 0 0% /proc fd 0 0 0 0% /dev/fd mnttab 0 0 0 0% /etc/mnttab /dev/md/dsk/d2 2053605 337978 1654019 17% /var swap 9318504 24 9318480 1% /var/run swap 9318504 24 9318480 1% /tmp /dev/dsk/c2t5d0s6 21676105 17069670 4389674 80% /pdd01 /dev/dsk/c2t5d1s6 52651120 32941520 19183089 64% /pdd02 /dev/md/dsk/d3 11355757 3867071 7375129 35% /extra /dev/dsk/c2t5d2s6 275497271 230024939 42717360 85% /pdd03 /dev/md/dsk/d4 11263304 3889401 7261270 35% /harris eureka:/pdd01 141174851 104163533 35599570 75% /eursp01 gum:/pdd02 85175557 35746634 48577168 43% /GUMINFX IOSTAT: >iostat -xn extended device statistics cpu device r/s w/s kr/s kw/s wait actv svc_t %w %b us sy wt id md0 0.0 0.1 0.0 1.0 0.0 0.0 27.8 0 0 0 3 23 74 md1 0.0 0.5 0.3 4.1 0.0 0.0 28.0 1 1 md2 0.0 0.2 0.0 1.4 0.0 0.0 25.0 0 0 md3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 md4 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 md5 0.0 0.1 0.0 1.0 0.0 0.0 15.5 0 0 md6 0.0 0.1 0.0 1.0 0.0 0.0 14.9 0 0 md7 0.0 0.5 0.1 4.1 0.0 0.0 16.4 0 1 md8 0.0 0.5 0.2 4.1 0.0 0.0 15.8 0 1 md9 0.0 0.2 0.0 1.4 0.0 0.0 9.8 0 0 md10 0.0 0.2 0.0 1.4 0.0 0.0 8.6 0 0 md11 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 md12 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 md13 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 md14 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 sd0 0.0 1.5 0.1 6.7 0.0 0.0 15.5 0 1 sd1 0.0 1.5 0.2 6.7 0.0 0.0 14.6 0 1 sd6 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 sd35 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 sd95 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 sd96 3.4 113.3 27.2 906.5 0.0 0.9 8.0 0 93 --------- (/pdd03) nfs1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 nfs2 26.7 0.0 853.3 0.0 0.0 0.3 9.5 0 9 nfs3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 IF you notice, the device busy time reached 93% at one time. Today I checked it but it was around 50%. Since it is test machine, I went ahead and rebooted. The busy time dropped to 1%. I can't figure how to troubleshoot this issue. Please help. Thank you Sylvia
Not sure why you think there is a problem here. You have a hot disk during a 'major' transfer. There are no wait times for disk IO