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 |
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
 Posted - 2004-05-24 : 02:12:26
|
| Has anyone used the SQLIO tool from microsoft?I found that the best configuration for io highest mb/s for one of my servers issqlio.exe -kR -t25 -s30 -f25 -b1024 -i128 -BN testfile.dat25 threads, 25 stripe size in blocks, 1024 blocks, 128 ios per run.How would I make sure sqlserver is tuned with this?What are the default settings for the above in sql server?Should I make any changes at the OS level and if so where?Should I make any changes to drivers?Should I make any changes to array controller?Thank you ahead. |
|
|
|
|
|
SQLIO Tool