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
sql-server-2008
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