I'm setting up a new database server.
It's running Win 2K8 Standard (SP2) with MS SQL 2008 (64-bit) Standard (SP1)
The E: drive (where the Database will reside), is a RAID5 array with 10 - 146 GB 15k rpm SAS drives.
My question is regarding the specific RAID settings. The RAID controller allows me to configure these options:
- Read Policy: No Read Ahead / Adaptive Read Ahead / Always Read Ahead
- Write Policy: Write Through / Always Write Back
- IO Policy: Direct IO / Cached IO
- Disk Cache Policy: Enabled / Disabled
Can someone comment on those options? When would it be beneficial to choose one setting as opposed to another?