I’m fairly new to SQL and my company is going over to a new software package that requires SQL. We are a small company, at first we will only have 3 users.
I tried finding a “best practice” or installation guide and could not find much. I originally configured the Dell PE2900 with two RAID 1’s, The first RAID 1 would be for the OS and support files, (146GB x 2, drives 0,1) and the second RAID 1, (146GBx2, drives 2,3) for the SQL and Data base, with a global hot spare (drive 4, 146GB). All drives are SCSI.
However, where I seem to have an issue is knowing where to install the SQL program and database. Originally I wanted to install it on the second RAID set, seperate from the C drive, however SQL wants to install itself on the C drive, therefore making me think that the database will install there as well.
In addition I’ve read that a RAID 10 is optimal for SQL, should I go ahead and configure my 5 hard drives in a RAID 10 with a hot spare? if so, how do I partition the SQL…or is it designed to be installed only on the C drive?
Any wisdom would help.
thanks.
Phill
