marrowyung
asked on
how to use SQLIO
dear all,
I head that SQLIO is a tools to measure from SQL server box to the disk which store data on how many ms is the disk latency, right?
May I know the correct link to download it and how to make use of it
I head that SQLIO is a tools to measure from SQL server box to the disk which store data on how many ms is the disk latency, right?
May I know the correct link to download it and how to make use of it
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this will check the IO disk latency before checking SAN reporting tools, right?
and MS suggest for any non cached SQL disk, the latency should be below 8ms and 1ms for cached one ?
and MS suggest for any non cached SQL disk, the latency should be below 8ms and 1ms for cached one ?
ASKER
"sqlio -kR -t2 -s120 -o1 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o2 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o4 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o8 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o16 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o16 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o32 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o32 -frandom -b8 -BH -LS -dO Testfile.dat"
so the -0 here tell SQLIO simulate the allocation unit about 32kbypes ?
timeout /t 30
sqlio -kR -t2 -s120 -o2 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o4 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o8 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o16 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o16 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o32 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o32 -frandom -b8 -BH -LS -dO Testfile.dat"
so the -0 here tell SQLIO simulate the allocation unit about 32kbypes ?
ASKER
dbaSQL,
"Go to the server we are going to test, open a command prompt and type this in:
sqlio -kW -s10 -fsequential -o8 -b8 -LS -Fparam.txt testfile.bat > results.txt
"
so this means we need to install sqlio on the SQL server box or we can't run it to test the SQL server storage, right? what if I am not allow to install anything on the SQL server itself ?
so the file containing:
"sqlio -kR -t2 -s120 -o1 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o2 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o4 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o8 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o16 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o16 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o32 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o32 -frandom -b8 -BH -LS -dO Testfile.dat"
is the sqlio.bat ?
so I don't see this tools is for use of testing disk latency but IOPS ? and from your doc we only need to Look at IOs/sec and MBs/sec ?
by finding the ceiling value of that, then there are no hints on it is good/bad, or any MS suggestion on what should be the IOs/sec ?
"Go to the server we are going to test, open a command prompt and type this in:
sqlio -kW -s10 -fsequential -o8 -b8 -LS -Fparam.txt testfile.bat > results.txt
"
so this means we need to install sqlio on the SQL server box or we can't run it to test the SQL server storage, right? what if I am not allow to install anything on the SQL server itself ?
so the file containing:
"sqlio -kR -t2 -s120 -o1 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o2 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o4 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o8 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o16 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o16 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o32 -frandom -b8 -BH -LS -dO Testfile.dat
timeout /t 30
sqlio -kR -t2 -s120 -o32 -frandom -b8 -BH -LS -dO Testfile.dat"
is the sqlio.bat ?
so I don't see this tools is for use of testing disk latency but IOPS ? and from your doc we only need to Look at IOs/sec and MBs/sec ?
by finding the ceiling value of that, then there are no hints on it is good/bad, or any MS suggestion on what should be the IOs/sec ?
ASKER
I modify it a bit and it works very well I think.
My apologies, marrowyung. I did not see your posts until now. I am very glad you got it working.
ASKER
I think you can also reply my last question. tks.
ASKER
hi, tks for your help on this but one thing, is SQLIO is a one stop tools to help us to check out if disk IO now is ONE of the problem, SQLIO don't help us to check out anything else?