Oninit cdi / Archive
Talk to an expert →

100% Disk utilization

Posted in 2004

Topics: General Discussion

casey — — source: Usenet: comp.databases.informix

RSAM Version 5.05.UC2 -- On-Line -- Up 11 days 21:17:56 -- 30944 Kbytes Can you spot why I see at OS level 100% Disk ? Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 13650367 19452123 1757997773 99.22 647795 2658829 144121943 99.55 isamtot open start read write rewrite delete commit rollbk 1085291621 9035411 70243722 476132825 38499036 4037589 1251898 19002272 176 ovtbls ovlock ovuser ovbuff usercpu syscpu numckpts flushes 0 0 73 0 42907.59 3372.75 6522 16895 bufwaits lokwaits lockreqs deadlks dltouts lchwaits ckpwaits compress 95966 135 1614122389 1 0 2063 5962 8418822

↪ replying to casey
Paul Watson — — source: Usenet: comp.databases.informix

It might be legit. Have a look at tbstat -u for users with large disk activity casey wrote: > > RSAM Version 5.05.UC2 -- On-Line -- Up 11 days 21:17:56 -- > 30944 Kbytes > > Can you spot why I see at OS level 100% Disk ? > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits > bufwrits %cached > 13650367 19452123 1757997773 99.22 647795 2658829 > 144121943 99.55 > > isamtot open start read write rewrite delete > commit rollbk > 1085291621 9035411 70243722 476132825 38499036 4037589 > 1251898 19002272 176 > > ovtbls ovlock ovuser ovbuff usercpu syscpu > numckpts flushes > 0 0 73 0 42907.59 3372.75 6522 > 16895 > > bufwaits lokwaits lockreqs deadlks dltouts lchwaits > ckpwaits compress > 95966 135 1614122389 1 0 2063 5962 > 8418822 -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #

↪ replying to Paul Watson
casey — — source: Usenet: comp.databases.informix

By far, the highest I/O are report queries. "Paul Watson" <paul@oninit.com> wrote in message news:406486CA.AD35F862@oninit.com... > It might be legit. > > Have a look at tbstat -u for users with large disk activity > > casey wrote: > > > > RSAM Version 5.05.UC2 -- On-Line -- Up 11 days 21:17:56 -- > > 30944 Kbytes > > > > Can you spot why I see at OS level 100% Disk ? > > > > Profile > > dskreads pagreads bufreads %cached dskwrits pagwrits > > bufwrits %cached > > 13650367 19452123 1757997773 99.22 647795 2658829 > > 144121943 99.55 > > > > isamtot open start read write rewrite delete > > commit rollbk > > 1085291621 9035411 70243722 476132825 38499036 4037589 > > 1251898 19002272 176 > > > > ovtbls ovlock ovuser ovbuff usercpu syscpu > > numckpts flushes > > 0 0 73 0 42907.59 3372.75 6522 > > 16895 > > > > bufwaits lokwaits lockreqs deadlks dltouts lchwaits > > ckpwaits compress > > 95966 135 1614122389 1 0 2063 5962 > > 8418822 > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com #

↪ replying to casey
Paul Watson — — source: Usenet: comp.databases.informix

I'd suspect a missing index, set explain on and look for sequential scans casey wrote: > > By far, the highest I/O are report queries. > > "Paul Watson" <paul@oninit.com> wrote in message > news:406486CA.AD35F862@oninit.com... > > It might be legit. > > > > Have a look at tbstat -u for users with large disk > activity > > > > casey wrote: > > > > > > RSAM Version 5.05.UC2 -- On-Line -- Up 11 days > 21:17:56 -- > > > 30944 Kbytes > > > > > > Can you spot why I see at OS level 100% Disk ? > > > > > > Profile > > > dskreads pagreads bufreads %cached dskwrits pagwrits > > > bufwrits %cached > > > 13650367 19452123 1757997773 99.22 647795 2658829 > > > 144121943 99.55 > > > > > > isamtot open start read write rewrite > delete > > > commit rollbk > > > 1085291621 9035411 70243722 476132825 38499036 4037589 > > > 1251898 19002272 176 > > > > > > ovtbls ovlock ovuser ovbuff usercpu syscpu > > > numckpts flushes > > > 0 0 73 0 42907.59 3372.75 > 6522 > > > 16895 > > > > > > bufwaits lokwaits lockreqs deadlks dltouts lchwaits > > > ckpwaits compress > > > 95966 135 1614122389 1 0 2063 > 5962 > > > 8418822 > > > > -- > > Paul Watson # > > Oninit Ltd # Growing old is mandatory > > Tel: +44 1436 672201 # Growing up is optional > > Fax: +44 1436 678693 # > > Mob: +44 7818 003457 # > > www.oninit.com # -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #