Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ys.dm_io_virtual_file_stats and IO_STALL Expand / Collapse
Author
Message
Posted Friday, July 5, 2013 9:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:29 AM
Points: 598, Visits: 1,651
Hi all

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?
Post #1470804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse