RAID 5击败RAID 10 [英] RAID 5 beats RAID 10
问题描述
RAID 5击败RAID 10
结果不是我的预期。
我有2个相同的服务器。
硬件:
PowerEdge 2850
2双核双核Xeon 2800 MHz
4GB RAM
控制器卡:Perc4 / DC(2个阵列),Perc4e / Di(1个阵列)
PowerVault 220S
每个阵列包含6-300 GB驱动器。
服务器1 =突袭10
3,6个磁盘阵列
服务器2 =突袭5(每个约838 GB)
3,6个磁盘阵列(每个约1360 GB)
测试获胜者%更快
SQL Server - 更新RAID 5 13
重型ETL RAID 5 16
SQLIO - Rand写入RAID 10 40
SQLIO - Rand读取RAID 10 30
SQLIO - Seq写入RAID 5 15
SQLIO - Seq读取RAID 5混合
Disktt - Seq写入RAID 5 18
Disktt - Seq读取RAID 5 2000
Disktt - Rand阅读RAID 5 62
通行证 - 混合RAID 10变化
通行证 -
模拟SQL Server RAID 5 1%
如果有人有兴趣,我有更多细节。
RAID 5 beats RAID 10
Can I get some feedback on these results? We were having some serious
IO issues according to PerfMon so I really pushed for RAID 10. The
results are not what I expected.
I have 2 identical servers.
Hardware:
PowerEdge 2850
2 dual core dual core Xeon 2800 MHz
4GB RAM
Controller Cards: Perc4/DC (2 arrays), Perc4e/Di (1 array)
PowerVault 220S
Each Array consisted of 6-300 GB drives.
Server 1 = Raid 10
3, 6-disk arrays
Server 2 = Raid 5 (~838 GB each)
3, 6-disk arrays (~1360 GB each)
Test Winner % Faster
SQL Server - Update RAID 5 13
Heavy ETL RAID 5 16
SQLIO - Rand Write RAID 10 40
SQLIO - Rand Read RAID 10 30
SQLIO - Seq Write RAID 5 15
SQLIO - Seq Read RAID 5 Mixed
Disktt - Seq Write RAID 5 18
Disktt - Seq Read RAID 5 2000
Disktt - Rand Read RAID 5 62
Pass Mark - mixed RAID 10 Varies
Pass Mark -
Simulate SQL Server RAID 5 1%
I have much more detail than this if anyone is interested.
推荐答案
你绝对是绝对绝对确定两台机器上的磁盘写缓存设置是否相同?
RAID 10将始终在实时读取性能上执行RAID 5 br />
情况,因为它有2个可以同时读取的数据副本。当写入磁盘时,为了计算奇偶校验,需要读取写入磁盘RAID 5的时间。
进行比较时有很多内容....
-
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - 免费视频教程
" Dave" <哒****** @ gmail.com>在消息中写道
news:11 ********************** @ g10g2000cwb.googlegr oups.com ...
Are you absolutely absolutely absolutely sure the disk write cache on both
machines was set the same?
RAID 10 will always out perform RAID 5 on read performance in a real
situation because it has 2 copies of the data it can concurrently read. When
writing to disk RAID 5 needs to read as well in order to calculate parity.
There is just so much to doing the comparison....
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Dave" <da******@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...
RAID 5击败RAID 10
我可以得到一些关于这些结果的反馈吗?根据PerfMon,我们遇到了一些严重的IO问题所以我真的推动了RAID 10.
结果不是我的预期。
我有2个相同的服务器。硬件:
PowerEdge 2850
2双核双核Xeon 2800 MHz
4GB RAM
控制卡:Perc4 / DC(2阵),Perc4e / Di (1阵列)
PowerVault 220S
每个阵列由6-300 GB驱动器组成。
服务器1 =突袭10
3,6磁盘阵列
服务器2 = Raid 5(每个~838 GB)
3个,6个磁盘阵列(每个约1360 GB)
测试获胜者%更快
重ETL RAID 5 16
SQLIO - Rand写入RAID 10 40
SQLIO - Rand读取RAID 10 30
SQLIO - Seq写入RAID 5 15
SQLIO - Seq读取RAID 5混合
Disktt - Seq写入RAID 5 18
Disktt - Seq读取RAID 5 2000
Disktt - Rand读取RAID 5 62
Pass标记 - 混合RAID 10变化
通过标记 -
模拟SQL Server RAID 5 1%
RAID 5 beats RAID 10
Can I get some feedback on these results? We were having some serious
IO issues according to PerfMon so I really pushed for RAID 10. The
results are not what I expected.
I have 2 identical servers.
Hardware:
PowerEdge 2850
2 dual core dual core Xeon 2800 MHz
4GB RAM
Controller Cards: Perc4/DC (2 arrays), Perc4e/Di (1 array)
PowerVault 220S
Each Array consisted of 6-300 GB drives.
Server 1 = Raid 10
3, 6-disk arrays
Server 2 = Raid 5 (~838 GB each)
3, 6-disk arrays (~1360 GB each)
Test Winner % Faster
SQL Server - Update RAID 5 13
Heavy ETL RAID 5 16
SQLIO - Rand Write RAID 10 40
SQLIO - Rand Read RAID 10 30
SQLIO - Seq Write RAID 5 15
SQLIO - Seq Read RAID 5 Mixed
Disktt - Seq Write RAID 5 18
Disktt - Seq Read RAID 5 2000
Disktt - Rand Read RAID 5 62
Pass Mark - mixed RAID 10 Varies
Pass Mark -
Simulate SQL Server RAID 5 1%
I have much more detail than this if anyone is interested.
所有阵列都有相同的设置
读缓存:自适应预读
写缓存:回写
缓存策略:缓存I / O
All the arrays have the same settings
Read Cache: Adaptive Read Ahead
Write Cache: Write Back
Cache Policy: Cache I/O
如果您使用带有Perc控制器的Dell硬件 - 请阅读:
http://forums.2cpu.com/showpost.php?...6&postcount=11
我将在第二天对此进行测试,看看这是否解释了我的整体糟糕的磁盘性能。
" Dave" <哒****** @ gmail.com>在消息中写道
news:11 ********************** @ g10g2000cwb.googlegr oups.com ...
If you are using Dell hardware with Perc controllers - Read this:
http://forums.2cpu.com/showpost.php?...6&postcount=11
I will be testing this during the next day to see if this explains my
overall bad diskperformance.
"Dave" <da******@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...
RAID 5击败RAID 10
我可以得到一些关于这些结果的反馈吗?根据PerfMon,我们遇到了一些严重的IO问题所以我真的推动了RAID 10.
结果不是我的预期。
我有2个相同的服务器。硬件:
PowerEdge 2850
2双核双核Xeon 2800 MHz
4GB RAM
控制卡:Perc4 / DC(2阵),Perc4e / Di (1阵列)
PowerVault 220S
每个阵列由6-300 GB驱动器组成。
服务器1 =突袭10
3,6磁盘阵列
服务器2 = Raid 5(每个~838 GB)
3个,6个磁盘阵列(每个约1360 GB)
测试获胜者%更快
重ETL RAID 5 16
SQLIO - Rand写入RAID 10 40
SQLIO - Rand读取RAID 10 30
SQLIO - Seq写入RAID 5 15
SQLIO - Seq读取RAID 5混合
Disktt - Seq写入RAID 5 18
Disktt - Seq读取RAID 5 2000
Disktt - Rand读取RAID 5 62
Pass标记 - 混合RAID 10变化
通过标记 -
模拟SQL Server RAID 5 1%
RAID 5 beats RAID 10
Can I get some feedback on these results? We were having some serious
IO issues according to PerfMon so I really pushed for RAID 10. The
results are not what I expected.
I have 2 identical servers.
Hardware:
PowerEdge 2850
2 dual core dual core Xeon 2800 MHz
4GB RAM
Controller Cards: Perc4/DC (2 arrays), Perc4e/Di (1 array)
PowerVault 220S
Each Array consisted of 6-300 GB drives.
Server 1 = Raid 10
3, 6-disk arrays
Server 2 = Raid 5 (~838 GB each)
3, 6-disk arrays (~1360 GB each)
Test Winner % Faster
SQL Server - Update RAID 5 13
Heavy ETL RAID 5 16
SQLIO - Rand Write RAID 10 40
SQLIO - Rand Read RAID 10 30
SQLIO - Seq Write RAID 5 15
SQLIO - Seq Read RAID 5 Mixed
Disktt - Seq Write RAID 5 18
Disktt - Seq Read RAID 5 2000
Disktt - Rand Read RAID 5 62
Pass Mark - mixed RAID 10 Varies
Pass Mark -
Simulate SQL Server RAID 5 1%
I have much more detail than this if anyone is interested.
这篇关于RAID 5击败RAID 10的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!