MS SQL Server Setup Advice

[crmayer]

Hello, I am looking for advice on how to configure our SCSI card and RAID config for our MS SQL Server. Currently our data is on a RAID 5/3 disks that holds the OS, SQL Server, our data, and our application software. We have just purchased a 16 drive SAS cabinet and an Adaptec SCSI card.
Can somebody recommend what the best settings are for the SCSI card and RAID config to try and achieve peak performance out of our new setup?
Our application provider said they typically setup external storage with write cache set to write back with a 16K stripe size. But they have not set up too many SAS drives, just Regular SCSI.

We currently have our development database moved over to the external storage and have it configured like this:
We have 6 SAS drives in the cabinet with this config:
2 - RAID 1 - For the Transaction log
4 - RAID 10 - For the database file
We will run our db and transaction log backup to another disk.
256K Stripe size
Write Cache disabled
Read Cache enabled

Can somebody recommend different setting to try and achieve peak performance without risking data corruption or lost of redundancy?


Thanks

 

[mrdenny]

Here is my FAQ on drive setups faq962-5747.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com