I/O response time of a multi-block reads
Date: Mon, 31 Mar 2008 14:44:34 -0700 (PDT)
How to measure the I/O response time of a multi-block reads from SQL trace file or OWI?
nam='direct path read temp' ela= 9291 file number=9999 first dba=28977 block cnt=15
Should elapsed time(ela) be devided by number of blocks (cnt) to derive the i/o response time ( to match w/ iostat service time )? I know "ela" needs to be converted to ms (ela/1000) .. my gut feeling tells me that it should not be as it's being passed to OS as one request but got challenged by few folks..
What should be the typical i/o response time value for such multiblock i/os[ on a standard SAN HDS/IBM/EMC ] ? does <20ms i/o response time standard apply here?
Thanks Received on Mon Mar 31 2008 - 16:44:34 CDT