I'm wondering if there's the optimal Cache setting for the following Raid controllers and raid setups. (OS: windows 2008 R2, App: II7, DB: SQL Server 2008 R2 Enterprise)
(The default setting seems to be: No Read Ahead/Write-back)
2 Disks Raid 1 contains OS, IIS installation as web host
2 Disks Raid 1 contains OS, SQL Server installation and Transaction logs
4 Disks Raid 10 contains only SQL Data file
What would be the optimal cache setting for the above three Raid configs with respect to their usage?