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 |
|
kennyunger
Starting Member
2 Posts |
 Posted - 2010-05-03 : 13:43:24
|
| Hello, In order to improve performance on our database, we've moved the data files from a 3 SAS disk RAID 5 to a 4 SAS disk RAID 10. My IT Manager read somewhere that SQL 2000 performs better on a strip size of 128KB, so that's what we set the RAID 10 up as. During this process we also installed a new SAS RAID controller. Today is the first day that the new array is under a full load. It is performing very badly, with average read queues of 40 - 50. Any suggestions? Thanks! Kenny |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kennyunger
Starting Member
2 Posts |
Posted - 2010-05-05 : 11:21:53
|
| Under load, the Avg. Disk Sec/Read counter averages at 40ms with spikes in the 230s... Not good. We are staying late tonight. We are going to reconfigure with the array as a RAID 10 with a 64K stripe. The partition will be NTFS with a cluster size of 64K and an offset of 64K. Hopefully we see similar results as this person. [url]http://kendalvandyke.blogspot.com/2009/02/disk-performance-hands-on-part-2-raid.html[/url] |
 |
|
|
|
|
|
High Average Read Queue on 4 Disk RAID 10