AIO and Buffer Waits

Posted in 2011

Habichtsberg, Reinhard — Wed, 13 Jul 2011 08:49:07 +0200 — source: Usenet: comp.databases.informix

We see the following waitstates on one of our Informix 11.50FC7W3 servers. He is running OLTP but also Decision Support. (sum) 81125424549,00 reason aio (sum) 62105207794,00 reason buffer (sum) 61713678094,10 reason mt yield n (sum) 61561288458,60 reason mt yield (sum) 29339327941,19 reason mt ready (sum) 15649570039,20 reason running (sum) 3340893922,100 reason log i/o (sum) 1550362515,000 reason mt yield 0 (sum) 1439244418,300 reason checkpoint (sum) 162272243,0000 reason lock (sum) 157356745,3000 reason mutex (sum) 21639138,60000 reason full Q What do you suggest to reduce IO and Bufferwaits. My idea is to increase the buffers. TIA, Reinhard.