记得以前有看到过RAID的配置策略，现在突然找不到了

Question

以前有看到过，但是现在找不到了。谁能提供下.

比如系统盘是放置在RAID几

数据库数据文件放置在什么RAID上？

数据库日志文件放置在什么RAID上？

tempdb放置在什么RAID上？

备份文件应该是可以存放在RAID5上的。

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 1

数据量大小大概为200G左右。

现在存在8*300G硬盘。

大家有什么建议吗？

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 2

Not many options here, create 4 raid1 arrays for binaries, user db data files, system db data files, and log files. Unless you have more disks.

Answer 3

OS 直接使用单块磁盘。

RAID5用作数据库备份文件存放

剩余4个做RAID10，下来大概600G，用作数据文件，日志文件和tempdb使用。（但是如果物理上是一个RAID10，是否会存在IO的冲突？）

 

这样合理吗？

 

---

If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Answer 4

Not good practice to put all db files on single array, and os needs protection also.

Answer 5

你好 Wison,

 

我建议你参考下面的连接关于RAID级别和SQL Server：

http://msdn.microsoft.com/zh-cn/library/ms190764.aspx

 

Thanks,
Weilin Qiao

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.