SQLIO

MICROSOFT SQL SERVER I/O GENERATION PROGRAM (SQLIO)

Sqlio is a disk workload generator that is designed to simulate some aspects of the I/O workload of Microsoft SQL Server.

The syntax of sqlio (which can be produced by executing “sqlio -?”) is:
Usage: obj\i386\sqlio [options] [...]

[options] may include any of the following:
-k<R|W>                 kind of IO (R=reads, W=writes)
-t<threads>             number of threads
-s<secs>                number of seconds to run
-d<drive1>..<driveN>    use same filename on each drive letter given
-R<drive1>,,<driveN>    raw drive letters/number on which to run
-f<stripe factor>       stripe size in blocks, random, or sequential
-p[I]<cpu affinity>     cpu number for affinity (0 based)(I=ideal)
-a[R[I]]<cpu mask>      cpu mask for (R=roundrobin (I=ideal)) affinity
-o<#outstanding>        depth to use for completion routines
-b<io size(KB)>         IO block size in KB
-i<#IOs/run>            number of IOs per IO run
-m<[C|S]><#sub-blks>    do multi blk IO (C=copy, S=scatter/gather)
-L<[S|P][i|]>           latencies from (S=system, P=processor) timer
-U[p]                   report system (p=per processor) utilization
-B<[N|Y|H|S]>           set buffering (N=none, Y=all, H=hdwr, S=sfwr)
-S<#blocks>             start I/Os #blocks into file
-v1.1.1                 I/Os runs use same blocks, as in version 1.1.1
-64                     use 64 bit memory operations
-F<paramfile>           read parameters from <paramfile>

Defaults:
-kR -t1 -s30 -f64 -b2 -i64 -BN testfile.dat

Maximums:
-t (threads):                   256
no. of files, includes -d & -R: 256
filename length:                256