woensdag 16 maart 2011

Tips / Links for working with SQLIO

SQLIO is a tool provided by Microsoft which can also be used to determine the I/O capacity of a given configuration.
It can be downloaded here.

Brent Ozar has a nice introduction about its features and a walkthrough on how to use it here.

SQLIO's output comes in a textfile which isnt ordered nicely yet.
I found a powershell script to directly import it into Excel.
Its from
jonathan kehayias and can be found/downloaded here.

A few sqlio parameters for my own reference below:

Creating:
sqlio -kW -s10 -fsequential -o8 -b8 -LS -Fparam.txt timeout /T 10

Generating output, example/baseline set:
sqlio -kW -t2 -s120 -dH -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dH -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dH -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dH -o1 -fsequential -b64 -BH -LS Testfile.dat

sqlio -kW -t8 -s120 -dH -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dH -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dH -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dH -o1 -fsequential -b64 -BH -LS Testfile.dat

sqlio -kW -t32 -s120 -dH -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dH -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dH -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dH -o1 -fsequential -b64 -BH -LS Testfile.dat

sqlio -kW -t64 -s120 -dH -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dH -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dH -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dH -o1 -fsequential -b64 -BH -LS Testfile.dat

Geen opmerkingen:

Een reactie posten