SQLIO Disk Subsystem Benchmark Tool

C:\Program Files (x86) \sqlio>sqlio-?Sqlio v1.5. SG-?: Invalid Optionusage:sqlio [options] [<filename>...] [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<drv_a><drv_b>.. Use same filename on each drive letter given-r<drv_a/0>,<drv_b/1&gt, .... Raw Drive Letters/number fori/O- F<stripe factor> Stripe sizeinchblocks, random, or sequential-P[I]&LT;CPU affinity> CPU Number forAffinity (0 based) (i=ideal)-A[R[I]]&LT;CPU mask> CPU Mask for(R=roundrobin (i=ideal)) Affinity-o<#outstanding> Depth to use for completion routines-b<io size (KB) > IO block sizeinchKB-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-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, asinchVersion 1.1.1- F<paramfile> read parameters from <paramfile>Defaults:-kr-t1-s30-f64-b2-i64-BN testfile.datmaximums:-T (threads): 256No. of files, includes-D &-r:256filename Length:256C:\Program Files (x86) \sqlio>

The parameter –kw indicates the case of the simulated write, and if it is-KR, it is written;
Parameter –t2 represents two threads
Parameter –s120 means test 2 minutes
The parameter –DM represents the specific drive letter
Parameter –O1 indicates the number of outstanding IO
The parameter –frandom represents a random pattern, whereas the sequential sequence pattern
The parameter –b64 indicates that each IO size is 64K

1 sqlio-kw-t2-s120-dm-o1-frandom-b64-bh-LS Testfile.dat2 Sqlio-kw-t2-s120-dm-o2- FRANDOM-B64-BH-ls Testfile.dat3 sqlio-kw-t2-s120-dm-o4-frandom-b64-bh-ls testfile.dat4 sqlio-kw-t2-s120-dm-o8-frandom-b64-bh-ls Testfile.dat

Need to download to the following address

http://www.microsoft.com/en-us/download/details.aspx?id=20163

I/O characteristics

operation	random / order	read / write	size range
create   Database		write	512KB
Backup Database	Order	Read / write	multiples of KB (up to 4MB)
Restore Database	Order	Read / write	multiples of KB (up to 4MB)
dbcc-checkdb		read	8KB~64KB
alter   index-on-rebuild (read phase)		read
alter   index-on-rebuild (write phase)		write	8kb endorsement, up to 128kb
sys.dm_db_index_phyical_stats http://technet.microsoft.com/zh-cn/library/ms181929.aspx		read	8KB~64KB
insert/update/delete		write	64KB~512KB
select		read	51KB~5124KB
tempdb		read / write	8KB~64KB
Transaction log	Order	Write	KB

Http://technet.microsoft.com/en-us/library/cc966412.aspx

SQLIO Disk Subsystem Benchmark Tool