G
George Potemkin
Guest
@Mike Opening a file does not write(). promon/Activity: Summary proves that during the pauses the both reads and writes were blocked. Opening a file reads the disks. @Sauqad What RAID customer is using? To my shame, I do not know. It's not the main application used by customer. @TheMadDBA can you post the iostat output? Does hpux have the -x option for queue depth? The customer (really my dbmon script) run iostat without any options: iostat 2 30 It was supposed that DBAs would adjust the options of OS commands before they will use the dbmon script but it's never happened. Example of iostat at 18:25:55 (?) where I cut off the most disks with zero statistics: device bps sps msps c1t0d1 0 0.0 1.0 c3t0d2 0 0.0 1.0 disk4 1016 124.8 1.0 disk5 0 0.0 1.0 disk190 0 0.0 1.0 disk199 1 1.0 1.0 disk205 4 0.5 1.0 disk206 8 1.0 1.0 disk214 24 3.0 1.0 disk215 121 12.4 1.0 disk216 71 8.9 1.0 disk225 61 7.4 1.0 disk226 44 5.4 1.0 disk228 24 0.5 1.0 disk232 32 0.5 1.0 disk234 8 0.5 1.0 disk237 4 0.5 1.0 disk239 4 0.5 1.0 disk247 32 0.5 1.0 disk253 44 5.4 1.0 disk256 36 1.0 1.0 disk258 4 0.5 1.0 disk268 4 0.5 1.0 disk269 0 0.0 1.0 disk4 shown the highest activity all the time: Time device bps sps msps 18:25:41 disk4 1973 128.1 1.0 18:25:45 disk4 2615 304.8 1.0 18:25:48 disk4 1778 218.8 1.0 18:25:52 disk4 1371 167.2 1.0 18:25:55 disk4 1016 124.8 1.0 18:25:59 disk4 978 122.7 1.0 18:26:02 disk4 1091 130.7 1.0 18:26:06 disk4 1457 181.6 1.0 18:26:09 disk4 1175 143.8 1.0 18:26:13 disk4 1056 131.2 1.0 18:26:16 disk4 1133 137.1 1.0 18:26:20 disk4 1081 131.0 1.0 18:26:23 disk4 1314 248.0 1.0 18:26:27 disk4 1167 140.0 1.0 18:26:31 disk4 1154 141.0 1.0 18:26:35 disk4 1057 130.5 1.0 18:26:38 disk4 1025 124.6 1.0 18:26:42 disk4 995 124.6 1.0 18:26:45 disk4 1132 140.3 1.0 18:26:49 disk4 993 122.4 1.0 18:26:52 disk4 984 123.0 1.0 18:26:56 disk4 1075 126.4 1.0 18:26:59 disk4 958 119.8 1.0 18:27:03 disk4 1094 137.4 1.0 18:27:06 disk4 1045 126.4 1.0 18:27:10 disk4 1080 131.5 1.0 18:27:13 disk4 1130 130.8 1.0 18:27:17 disk4 7992 405.0 1.0 18:27:20 disk4 12493 340.3 1.0 18:27:24 disk4 12453 298.5 1.0 Example of iostat from their main server (I cut off the disks with low bps): device bps sps msps disk762 21828 2560.7 1.0 disk766 9987 1583.1 1.0 disk767 10150 1636.3 1.0 disk801 3590 229.9 1.0 disk802 3463 224.4 1.0 disk803 3536 226.4 1.0 disk918 1218 151.2 1.0 disk919 1179 145.8 1.0 disk920 1320 161.7 1.0 disk940 3713 194.5 1.0 disk941 3656 183.1 1.0 disk942 3797 214.9 1.0 bps Kilobytes transferred per second sps Number of seeks per second msps Milliseconds per average seek
Continue reading...
Continue reading...