Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ptimmerm
Starting Member
4 Posts |
 Posted - 2007-03-12 : 13:23:47
|
| I am testing some new hardware and and running SQLIO against it. I ran:sqlio -kW -s360 -frandom -o8 -b8 -LS -Fparam.txt >> B8Output.txt I got:3373.25 IOs/sec26.35 MBs/sec8ms Avg Latency The current system which will be moving to this hardware does not do 3373.25 IO/sec (writes). When stressed, it may do 400 writes/sec. Is there an easy way to "convert" the output from SQLIO to determine what I should see with my expected load or is there a tool that will allow me to test a specific number of I/O? TIA |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-03-13 : 06:47:49
|
| Would there be an opportunity for you to run the same SQLIO on your existing system, and then just scale/compare the results, rather than look for absolute numbers. |
 |
|
|
|
|
|
SQLIO Output Interpretation