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.
13  15418 
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.goo glegroups.com.. . 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.
All the arrays have the same settings
Read Cache: Adaptive Read Ahead
Write Cache: Write Back
Cache Policy: Cache I/O
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.goo glegroups.com.. . 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.
Per Schjetne wrote: 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 .
I may be missing something but is "write back" not slower than "write
through" anyway? I mean with write through the data has to be written
twice with RAID 10 before the IO call returns; I'm not sure whether this
can happen in parallel - if not you're at twice the time. But with
write back the controller can put the data into its internal cache (as
long as there is space left), IO call can return and then it can writing
stuff in the background.
Regards
robert
I have the exact same situation. We had a PowerEdge 2800 with RAID 5,
when we got a new one I pushed hard for RAID 10, and then when I ran
performance tests for our database it turned out to be not quite as
good as the RAID 5.
I can confirm the same thing. We have 2 x PowerEdge 2800 with the disks on a
PowerVault 220S. I have reconfigured one of the servers to Raid 10 and the
diskperformance went slightly down. I used ATTO Disk Benchmark for testing.
I also run some test-procedures in SQL Server and it confirmed the same
thing.
"sql_server_use r" <ka*******@gmai l.com> wrote in message
news:11******** **************@ i39g2000cwa.goo glegroups.com.. . I have the exact same situation. We had a PowerEdge 2800 with RAID 5,
when we got a new one I pushed hard for RAID 10, and then when I ran
performance tests for our database it turned out to be not quite as
good as the RAID 5.
In theory, should this happen? Does anyone know of any published
benchmarks that compare Raid 5 to Raid 10 while holding the number of
disks constant?
Dave, I feel you should read Kimberly L. Tripp's response more carefully.
Her response is quite to the point. The performance comparison is not based
on the same number of physical disks, it is based on the same drive
capacity, using the same physical drives, but different number of them. Of
course if measured by basing on the same number of physical drives, you will
get the performance number as you stated, but that is just not the way
currently used to assess the performance.
"Dave" <da******@gmail .com> wrote in message
news:11******** **************@ j73g2000cwa.goo glegroups.com.. . In theory, should this happen? Does anyone know of any published
benchmarks that compare Raid 5 to Raid 10 while holding the number of
disks constant?
I understood her post, I just don' think that the "current way" is
a logical or scientific way to analyze Raid. I understand the fault
tolerance and Degradation/Rebuilding benefits of Raid 10. However, for
performance reasons alone, I it doesn't appear to be justified.
I admit my testing is inconclusive. I wish I had to opportunity to
conduct more tests and see how performance varies with the number of
disks in the array.
It would also be interesting to repeat the tests on different hardware.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bernie |
last post by:
I will be doing some performance testing on financial application next
month. Without going into a lot of details, I suspect I will have a
potential bottleneck when writing to the log file.
My hardware setup is a quad 2.8 Xeon Dell server direct attached to a
DELL/EMC CX200 (Fibre channel array with 10 X 30something GB, 15,000
rpm drives, with about 1GB of memory on the array for caching.
This is a benchmark environment, so I am not...
|
by: JJ |
last post by:
Hi,
I was going to buy a server with Raid 1 as I thought that it meant that if
one of the two mirrored drives fail, you simply take it out and put a new
one in. At which point presumably the hardware takes over and copies the
other drive over to mirror it again.
However, my sql server admin book, says raid 1 is bad, as it means you have
lots of downtime, when recovering from a broken drive.
Can anyone give me some advice on this? What...
|
by: Joseph |
last post by:
I've been thinking about the benefits or lack thereof of deploying DMS
tablespaces for RAID, say RAID 5. The point of DMS is to get reasonable
size extents of contiguous disk space so that minimal seeking is done with
sequential scans of data and sequential prefetching can pipeline the reading
of data with its processing etc.
RAID generally defeats this model of sequential scans across contiguous
placed data because they stripe data...
|
by: esmith2112 |
last post by:
We replaced an aging system with a newer (faster 4-way) and presumably
better system. Perfomance for most queries has improved as one would
expect. However, we're getting slaughtered on performance for
summary-style queries. What took 2 minutes now takes 2-3 hours to
complete.
We backed up DB and restored it on a borrowed (somewhat inferior class)
box to see if we could do some diagnostics to determine why we had such
horrid...
|
by: p175 |
last post by:
Hi folks,
I've tried reading just about every post I can on raid stiping / extent
size etc and I'm just getting myself more confused than ever. Here's my
situation.
On a Windows Server 2000 standard edition system with only 1gb ram
using UDB 8.2.3 Enterprise, I have an existing database that uses two
raid arrays striped with 8kb. Presently the tablespaces have a
default extent of 24, default prefetch of 48 .
| | |
by: serge |
last post by:
I have a database that is around 2 to 4 GB.
If I were to estimate some numbers like 4x growth or
even 10x, the database size could reach 40GB.
The new server will be running SQL Server 2005.
I am not sure which configuration option to take.
I've gathered some information from different places:
Configuration #1:
OS - Raid1 2x36GB
|
by: boa |
last post by:
I'm currently planning disk layouts and use for a new version of our
database. The current version has all data and indexes in the default
filegroup, placed on one big raid-5 array(6 drives) along with the
transaction log. Performance is not the best, as you may imagine...
Next week we will add another 14 drives and organize them in different
combos of raid-10 and raid-1, and then create several filegroups and
place tables and index data...
|
by: alf |
last post by:
Hi,
is it possible that due to OS crash or mysql itself crash or some e.g.
SCSI failure to lose all the data stored in the table (let's say million
of 1KB rows). In other words what is the worst case scenario for MyISAM
backend?
Also is it possible to not to lose data but get them corrupted?
|
by: aj |
last post by:
DB2 LUW v8.2 FP 14 RHAS 2.1
Not trying to start a flame war or anything, but does anyone have an
opinion regarding whether to use Raid 5 or Raid 10 w/ DB2?
We have an EMC SAN (a Clariion CX600 I believe). My SysAdmin and I
are discussing which raid type to use. Several years ago during my
Informix DBA days, Art Kagel and other well-informed folks on C.D.I.
would occasionally point out how raid 5 w/ database is a BAD idea, and
how...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
