15 pts.
 RAID stripe and cluster size configuration
Does anyone know some way of testing/ tuning the best performance out of a DAS RAID. ie. Different Stripes and formatted clusters for the different types of raid.

Software/Hardware used:
ASKED: April 22, 2009  11:21 PM
UPDATED: May 14, 2009  6:33 PM

Answer Wiki:
The only way to test would be to rebuild the array and try again.
Last Wiki Answer Submitted:  April 26, 2009  4:29 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

I meant some software that would test the different performances under different conditions, a sort of ramping tests to show max performance, saturation bandwidth, maximum throughput, etc .usual stats

 15 pts.

 

Microsoft has some software which you can download which will push a ton of IO to the disks. It’s called SQLIOSim. It’s a free download. You give it the parameters you want, and it will flood the disk with IO. Make sure that you select the correct settings to mimic your actual workload.

 64,520 pts.