I am looking for ideas to configure the hardware on a SQL 6.5 server
to get the most performance out of the disk subsystem. Right now, it
is configured as follows:
a) (6) * 4.3 GB Fast Wide SCSI 2 drives in a RAID 5 array
b) (2) * 1 GB Fast Wide SCSI 2 drives software mirrored
The O/S and supporting programs are on the 1 GB drives. Everything
else of SQL is on the RAID 5 array (Tables, TempDB, Trans. Logs) which
is configured to be one 20 GB logical drive.
To me, this seems like an inefficient way to do this. Would it make
more sense to do the following?
1) (2) * 9 GB Fast Wide SCSI 2 hardware mirrored
2) (2) * 4.3 GB Fast Wide SCSI 2 hardware mirrored
3) (2) * 4.3 GB Fast Wide SCSI 2 hardware mirrored
4) (2) * 4.3 GB Fast Wide SCSI 2 hardware mirrored
In this config, the O/S would be on 2). The tables would be on 1).
TempDB would be on 3). And trans. logs would be on 4). Does any one
have any suggestions to this setup? I am interested in feedback. The
more the better, and the sooner the better. Thanks for any help.
Lloydminster, Alberta, Canada