I am looking to build a new 2 node clustered SQL 2008 R2 setup to support SharePoint 2010 and Project server 2010. I have two 48 core servers with 128gb ram and 2 drive
shelves, one drive shelf has 24 x 1500rpm 146GB drives and one backup drive shelf has
14 2TB drives. I am trying to figure out what is the best way to setup the 1500rpm drives particularly for the temp DB data files. My databases for SharePoint and Project server will be on two Raid 10 arrays and
their logs will be on 2 separate RAID 1 arrays, all on 1500RPM drives. That leaves me with five 1500RM disks left. One of those disks will be hot spare drive waiting for a failure of any drive in the shelf. That gives me 4
drives left for the Temb DB files. To be safe I could build two raid 1 arrays and put some of the temp db files on the one array and some on the other array.
But, what I am considering and looking for advice on is if I do not RAID the 4 drives and just use them as 4 individual drives knowing that if any of them fail the hot spare
drive will kick in and become
View Complete Post