many seconds waiting for I/O?

Hi

I have a batch process running and it seems that it's waiting for I/O all
the time, the strange thing is it shows 400 seconds waits!

EVENT                      CONSISTENT_GETS SPID          WAIT_TIME
SECONDS_IN_WAIT STATE                     SEQ#
-------------------------- --------------- ------------ ----------
--------------- ------------------- ----------
db file sequential read             212532 25879
-1             374 WAITED SHORT TIME          892


EVENT                      CONSISTENT_GETS SPID          WAIT_TIME
SECONDS_IN_WAIT STATE                     SEQ#
-------------------------- --------------- ------------ ----------
--------------- ------------------- ----------
db file sequential read             212717 25879
-1             431 WAITED SHORT TIME          892


EVENT                      CONSISTENT_GETS SPID          WAIT_TIME
SECONDS_IN_WAIT STATE                     SEQ#
-------------------------- --------------- ------------ ----------
--------------- ------------------- ----------
db file sequential read             212925 25879
-1             504 WAITED SHORT TIME          892

What can cause this???

Thanks!

Alex

Other related posts: