[dba-Tech] RAID Drives

Arthur Fuller artful at rogers.com
Fri May 7 22:43:26 CDT 2004


Can anyone give me a thumbnail education on RAID drives? In my specific
case, I have an old server with 5 visible drives in a RAID. From Win
Explorer I can see 2 drives, C:\ and D:\. I don't think there are any
hidden drives on the box. Are C:\ and D:\ partitions on these 5 drives?

If I understand RAID correctly (and I freely admit that I'm seriously
ignorant here), each file-save operation writes one fifth of the data to
each drive, plus redundant data (somewhere), so that if any given drive
goes down, the data on it is also elsewhere, enabling me to replace said
drive without even powering down. Is that part correct, at least?

Now for the serious question. Accepted wisdom says that the optimal SQL
installation puts the data on one drive and the indexes on another, with
(if possible) SQL itself on a third drive. 

Is this correct? Given a RAID setup as described above, how would I do
this? Should I reformat the RAID and create several drives? If I did
that, then I could easily move the indexes to some other drive, but am I
actually gaining something by doing this? Or is this all hocus-pocus
along the lines of multiple partitions on one hard disk?

Remember, as you read this, that there are no stupid questions -- only
stupid people :)

Arthur




More information about the dba-Tech mailing list