September 5, 2007 at 12:21 pm
We are about to do some bench marks.
All our data is on a SAN X, O, M etc
I have the following SQL IO tests
::Test randmon IO's of 8Kcall sqlio -kW -s600 -frandom -o32 -b8 -LS -Fparam.txtcall sqlio -kR -s600 -frandom -o32 -b8 -LS -Fparam.txt::Test small sequential writes call sqlio -kW -s60 -fsequential -o1 -b4 -LS -Fparam.txtcall sqlio -kW -s60 -fsequential -o1 -b8 -LS -Fparam.txtcall sqlio -kW -s60 -fsequential -o1 -b16 -LS -Fparam.txtcall sqlio -kW -s60 -fsequential -o1 -b32 -LS -Fparam.txtcall sqlio -kW -s60 -fsequential -o1 -b64 -LS -Fparam.txt::Test large sequential read/writecall sqlio -kR -s60 -fsequential -o8 –b8 -LS -Fparam.txtcall sqlio -kR -s60 -fsequential -o8 -b64 -LS -Fparam.txtcall sqlio -kR -s60 -fsequential -o8 -b128 -LS -Fparam.txtcall sqlio -kR -s60 -fsequential -o8 -b256 -LS -Fparam.txtcall sqlio -kW -s60 -fsequential -o8 –b8 -LS -Fparam.txtcall sqlio -kW -s60 -fsequential -o8 -b64 -LS -Fparam.txtcall sqlio -kW -s60 -fsequential -o8 -b128 -LS -Fparam.txtcall sqlio -kW -s60 -fsequential -o8 -b256 -LS -Fparam.txt
From this thread
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
I was wondering how it knows which disk to run these on.
September 6, 2007 at 2:20 am
my guess is an entry in the param.txt file
microsoft released an update of SQLIOStress called sqliosim: http://support.microsoft.com/kb/231619
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply