| Re: SQL 2000 recomended drive configuration |
|
 |
|
 |
|
 |
|
 |
Group: microsoft.public.sqlserver.setup · Group Profile
Author: Hank ArnoldHank Arnold Date: Oct 30, 2006 00:39
If the number of drives is fixed, then I would put SQL and the log files
on the RAID 1 array. The databases on the second array. Make the second
a RAID 10. Put SLQ and the log files on the RAID 1 and the databases on
RAID 10 (significantly better performance).
Ideally, you should add a 3rd array (RAID 1) (on its own channel) and
put the log files on it. This will speed things up and improve your
ability to recover from a disaster.
Regards,
Hank Arnold
stosti wrote:
> Hi.
>
> I'm building a new SQL 2000 server. I typically use HP DL380 machines with
> split backplane. SCSI controller one will have a pair of 72 GB drivesin RAID
> 1 (C:). This will be used for the operating system. SCSI controller two
> will have 4 300 GB drives in a RAID 5. Three of the drives will make up the
> RAID 5 and the forth will be an online spair. SQL will be installed on the
> RAID 5 (D:).
>
> Is this configuration ok? Is there a prefered way to set them up? This
> setup is fine for recovery but maybe not optimal for performance?
>
> Thanks,
> Scott
| 
