I am about to setup a new 2008R2 64bit Server w/8 500GB physical Hard Drives. The host will be used for SQL 2008R2. I will also have 1 Virtual 2003R2 32bit server/VHD for running sonic (Because Sonic does not work on 2008 or 64bit).
SQL DB Size about 18GB, Users = 60
My question is, what would be the best Raid Configurations and where should each function live? II know more drives would be better but this is what I have.....
OS - ??
SQLDB - ??
SQLLOGS - ??
VHD - ??
Thanks for any suggestions