SQLIO help decipher output

Posted by SQL Learner on Server Fault See other posts from Server Fault or by SQL Learner
Published on 2012-11-02T16:52:25Z Indexed on 2012/11/02 17:05 UTC
Read the original article Hit count: 237

Filed under:

When load testing on a SQL Server Box, using following (testfile is 25 GB)

sqlio -kW -t8 -s360 -o8 -frandom -b8 -BH -LS  g:\testfile.dat > result.txt
sqlio -kW -t8 -s360 -o8 -frandom -b64 -BH -LS g:\testfile.dat >> result.txt
sqlio -kW -t8 -s360 -o8 -frandom -b128 -BH -LS g:\testfile.dat >> result.txt
sqlio -kW -t8 -s360 -o8 -frandom -b256 -BH -LS g:\testfile.dat >> result.txt

Can anyone help me decipher output.. I do not understand latency min and average....? What does this number means

IOs/sec: 10968.80
MBs/sec:   685.55
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 5
Max_Latency(ms): 21

© Server Fault or respective owner

Related posts about sql-server-2008