Very Computer

by **Patrick Ikhif** » Mon, 03 Jul 2000 04:00:00

Guys,
I have a question about the effect of the create database statement on a
machine that has five physical drives with all the data striped across with
RAID 5. The disk controller is going to write data across all five drives in
the RAID set, now the question is, is there still an advantage in creating
files groups in a scenario such as this? I do not have control over which
physical devices will hold what file groups to take advantage of separating
reads and writes to the database table objects. I could logically partition
the drives, but then again that is only logical. If the data is written
across all the drives, then does it matter where I place tables and objects?
Any ideas here? I would like to take advantage of file groups concept but I
am afraid that if the RAID sub system is already set up with a striping to
take advantage of the hot swap features of the drives that I do not get this
option. Any ideas? Thanks in advance.

by **Tibor Karasz** » Tue, 04 Jul 2000 04:00:00

Patrick,

No, you wouldn't gain anything by manually spreading things over a RAID5. FG could be
considered if you foresee that you'll get separate physical partitions in the future.
Otherwise, try to make one db file per disk (i.e. 5 files in your case), to drive
disksubsystem reasonable optimal.

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.

> Guys,
> I have a question about the effect of the create database statement on a
> machine that has five physical drives with all the data striped across with
> RAID 5. The disk controller is going to write data across all five drives in
> the RAID set, now the question is, is there still an advantage in creating
> files groups in a scenario such as this? I do not have control over which
> physical devices will hold what file groups to take advantage of separating
> reads and writes to the database table objects. I could logically partition
> the drives, but then again that is only logical. If the data is written
> across all the drives, then does it matter where I place tables and objects?
> Any ideas here? I would like to take advantage of file groups concept but I
> am afraid that if the RAID sub system is already set up with a striping to
> take advantage of the hot swap features of the drives that I do not get this
> option. Any ideas? Thanks in advance.

Very Computer

Create Database statements (File Groups, Files, and RAID)

Create Database statements (File Groups, Files, and RAID)

Create Database statements (File Groups, Files, and RAID)