Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.
Sign up to join this community
We're setting up a SQL2008 system with the following virtual disks (not including the OS/Apps volume):
RAID10 Data
RAID1 Logs
RAID1 TempDB
Any recommendations as to how we should setup the RAID controller cache settings for each of these three VDs? The options are:
Write: write-back(WB) / write through(WT)
Read: read ahead(RA) / adaptive read ahead(ARA) / No Read ahead(NRA)
The RAID controller (512MB cache) has a battery backup unit.
Definitely use write cache for transaction logs; they're always written and almost never read.
And, if they get actually read, this is done sequentially, so a read cache would be completely pointless.
I'd say.
Logs: NRA & WB
Database: (ARA or NRA) & WB
tempdb: (ARA or NRA) & WB
I'd be tempted to switch off write caching altogether but use 100% of your cache for ARA - but then again I'm quite paranoid about transactional integrity and don't fully trust BBWC - you may have more faith.
