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 |
|
zaty2405
Yak Posting Veteran
58 Posts |
 Posted - 2010-07-13 : 04:36:51
|
| Hi,Currently our production database having some performance issue due to the low performance SAN storage. Now the plan is to move luns to faster disk group.I need to capture the current storage configuration using sqlio . Once we move to the faster storage, I need to do the same thing so that we can compare the before and after result.I need some help on whether my current sqlio script is sufficient/correct :sqlio -kW -t8 -s120 -dE -o8 -frandom -b8 -BH -LS Testfile.datsqlio -kW -t8 -s120 -dE -o8 -frandom -b64 -BH -LS Testfile.datsqlio -kR -t8 -s120 -dE -o8 -frandom -b8 -BH -LS Testfile.datsqlio -kR -t8 -s120 -dE -o8 -frandom -b64 -BH -LS Testfile.datsqlio -kW -t8 -s120 -dE -o8 -fsequential -b8 -BH -LS Testfile.datsqlio -kW -t8 -s120 -dE -o8 -fsequential -b64 -BH -LS Testfile.datsqlio -kR -t8 -s120 -dE -o8 -fsequential -b8 -BH -LS Testfile.datsqlio -kR -t8 -s120 -dE -o8 -fsequential -b64 -BH -LS Testfile.datAppreciate your help.Thank you |
|
|
|
|
|
to perform storage test