My Window 2008 R2 + SQL 2008R2 has the following configuration.
OS : 2 x 300GB (RAID-1)
SQL TempDB : 4 x 300GB (RAID-10)
SQL Log : 4 x 300GB (RAID-10)
SQL Data : 4 x 800GB (RAID-10)
Due to the limitation of the hardware, I can't configure more RAID. The server will be plugged with 192GB RAM. However, my concern is the pagefile size and program size on the OS partition.
Can the 300GB be cope with the size of SQL program + pagefile + OS ? What will be the best way to handle this in my current configuration ? Should I install SQL Program on SQL Data partition to save some space on OS partition ?