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 |
|
phoeneous
Starting Member
9 Posts |
 Posted - 2012-04-25 : 16:08:53
|
| Just got a new box that I need to setup as a database server. It has 2 xeon 5500's, 6 600GB SAS2 drives, and 64GB ddr3 registered. Plenty of power for one database. Since it is a dell server, I'm using the old school openmanage server builder disc to configure the raid and install the os. Here is how I plan to setup the discs:2x600 in Raid 1 for OS and logs4x600 in Raid 10 for DataMy question is, how should I setup the read and write policies for the raid? It is a perc6 controller so I have the read options of default, read ahead, adaptive read ahead, and no read ahead. For the write options I have default, write back, and write through. Based on documentation that I have read, I think I should use adaptive read ahead and write back. Thoughts? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-25 : 16:35:50
|
| I'd recommend write through instead of write back, even if you have a battery backed cache on the controller. If you can, run some tests using both settings with the SQLIO utility. There's a good writeup on how to use it here:http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIOUnless you see a serious drop in performance with write through, it's safer to use it instead of write back.. You can also test each of the read ahead settings with that utility. |
 |
|
|
|
|
|
|
|
Configuring raid read and write policy for sql ser