I have been collecting information in regards to IO_STALLS for my DB files and collecting the information every 5mins.
I am comparing the values from one to the next to work out the IO_STALL in ms that occurred in that 5mins.
The query looks to be working ok however something strange has happened in that every now and again I can see consistently high IO_STALL deltas. When I say high I mean the ms is greater than 5mins.
Is this possible?