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.
ASKED: Apr 22, 2009  11:21 PM GMT
UPDATED: May 14, 2009  6:33:42 PM GMT
63,630 pts.

Answer Wiki:
The only way to test would be to rebuild the array and try again.
Last Wiki Answer Submitted:  Apr 26, 2009  4:29 AM (GMT)  by  Mrdenny   63,630 pts.
To see other 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.

 63,630 pts.