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
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vikas GargBusiness Intelligence DeveloperCommented:
HI,

You can download SQLIO from Here

also there is one good link showing how this can be utilized SQLIO
0
dbaSQLCommented:
I actually had to write up the use of SQLIO for one of my customers.  We were having performance problems with a system on NetApp, so we used SQLIO in an attempt to diagnose the problem(s).  Hopefully this will be helpful to you as well.

See the attached doc file for the overall that I gave to them, as well as the attached sqlio.txt file for the actual execution that we ran.  It is a bat file, but renamed as txt for the posting.  I have also attached the sqlio readme.  It is an older release.
readme.txt
SQLIO-Walk-thru.docx
sqlio.txt
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
dbaSQL,

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?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

marrowyungSenior Technical architecture (Data)Author Commented:
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 ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
"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 ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
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 ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
I modify it a bit and it works very well I think.
0
dbaSQLCommented:
My apologies, marrowyung.  I did not see your posts until now.   I am very glad you got it working.
0
marrowyungSenior Technical architecture (Data)Author Commented:
I think you can also reply my last question. tks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.