SQL Server Disk Configuration

Associate
Joined
6 Feb 2004
Posts
689
Location
Herts
Right thought i'd swing this one passed the hardware guru's around here...

I'm spec'ing out a SQL Server machine and would like to hear your thought's on optimal disk configuration.

The server itself is a Dell PowerEdge 2850 that can support a maximum of 6 SCSI drives. The idea is to centralise our various installations of SQL server onto a single central machine (all our egg's in one basket i know but that's why Acrnois TrueImage Enterpirise server will be used to back this baby up!).

To be honest i doubt very much that the load will ever near the capabilities of a single RAID 5 array but I want to make a point of setting this server up with optimum performance in mind.

So you've got six disks and up to three controllers to play with - how would you configure yours?


Dan.
 
The controller does not seem to support 0+1 but 1+0 (or 10) instead, after looking around this does not seem to be too much of problem but can guys point out the downsides of going with the latter?

Currently i'm thinking RAID1 for O/S, applications and transactions (on seperate partitions). Then RAID10 for the database files and tempdb. Sound about right?
 
Back
Top Bottom