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 raid 10 should always be used.
With SAN advances (cache, memory, speed, etc..), does this still apply?
My SysAdmin thinks Raid 5 is a better way to go.
All of my tablespace containers are DMS (typically 2 gigabytes each),
except for temp space, which are SMS.
TIA
aj
6  8608 
On Apr 16, 8:54 am, aj <ron...@mcdonalds.comwrote:
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 raid 10 should always be used.
With SAN advances (cache, memory, speed, etc..), does this still apply?
My SysAdmin thinks Raid 5 is a better way to go.
All of my tablespace containers are DMS (typically 2 gigabytes each),
except for temp space, which are SMS.
TIA
aj
http://www.acnc.com/04_01_10.html
On Apr 16, 8:54 am, aj <ron...@mcdonalds.comwrote:
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 raid 10 should always be used.
With SAN advances (cache, memory, speed, etc..), does this still apply?
My SysAdmin thinks Raid 5 is a better way to go.
All of my tablespace containers are DMS (typically 2 gigabytes each),
except for temp space, which are SMS.
TIA
aj
RAID 10 is still the better way to go for a database with a lot of
writes. For something like a data warehouse it might not be so
critical.
If the Clariion CX600 issues writes to cache and performs the physical
write asynchronously, does the stated benefit of raid 10 versus 5
really exists?
On Apr 16, 10:29 am, "Ray" <raymmailbox-n...@yahoo.comwrote:
On Apr 16, 8:54 am, aj <ron...@mcdonalds.comwrote:
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 raid 10 should always be used.
With SAN advances (cache, memory, speed, etc..), does this still apply?
My SysAdmin thinks Raid 5 is a better way to go.
All of my tablespace containers are DMS (typically 2 gigabytes each),
except for temp space, which are SMS.
TIA
aj
RAID 10 is still the better way to go for a database with a lot of
writes. For something like a data warehouse it might not be so
critical.- Hide quoted text -
- Show quoted text -
aj wrote:
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 raid 10 should always be used.
With SAN advances (cache, memory, speed, etc..), does this still apply?
My SysAdmin thinks Raid 5 is a better way to go.
NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!!
This is still true and likely always will be. Performance asside (and
noone's proven to me yet that massive cache eliminates more than half of the
RAID5 write penalty) the data safety issues are HUGE and noone's solved them
yet (only DG - now part of EMC - tried and their solution didn't work). At
the cost of drives today RAID5 no longer makes sense! Please read ALL of
the related articles posted on www.baarf.com, including my own, and read the
comments on the 'Baarf members' page from the many who've been bitten, and
see why everyone, not just DBAs, should avoid RAID5 like the plague.
All of my tablespace containers are DMS (typically 2 gigabytes each),
except for temp space, which are SMS.
Art S. Kagel
NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!!
Thanks Art. I was kinda hoping you'd chime in. :)
cheers
aj
Art S. Kagel wrote:
aj wrote:
>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 raid 10 should always be used.
With SAN advances (cache, memory, speed, etc..), does this still apply?
My SysAdmin thinks Raid 5 is a better way to go.
NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO
RAID5!!!
This is still true and likely always will be. Performance asside (and
noone's proven to me yet that massive cache eliminates more than half of
the RAID5 write penalty) the data safety issues are HUGE and noone's
solved them yet (only DG - now part of EMC - tried and their solution
didn't work). At the cost of drives today RAID5 no longer makes sense!
Please read ALL of the related articles posted on www.baarf.com,
including my own, and read the comments on the 'Baarf members' page from
the many who've been bitten, and see why everyone, not just DBAs, should
avoid RAID5 like the plague.
>All of my tablespace containers are DMS (typically 2 gigabytes each),
except for temp space, which are SMS.
Art S. Kagel
NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO
RAID5!!!
ts******@gmail.com wrote:
If the Clariion CX600 issues writes to cache and performs the physical
write asynchronously, does the stated benefit of raid 10 versus 5
really exists?
Tested it on Clariion myself several years back, so I recommend, as always,
that you test it YOURSELF, but, yes the RAID5 write penalty is supressed or
hidden by massive caching by about 50% but ONLY if your write volume doesn't
exceed the write throughput of the array over some time period. Then
performance reverts to non-cached performance. And the data safety issue is
the big one for me, NOT the performance. RAID5 is NOT SAFE!
Art S. Kagel
On Apr 16, 10:29 am, "Ray" <raymmailbox-n...@yahoo.comwrote:
>>On Apr 16, 8:54 am, aj <ron...@mcdonalds.comwrote:
>>>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 raid 10 should always be used.
>>>With SAN advances (cache, memory, speed, etc..), does this still apply?
My SysAdmin thinks Raid 5 is a better way to go.
>>>All of my tablespace containers are DMS (typically 2 gigabytes each),
except for temp space, which are SMS.
>>>TIA
>>>aj
RAID 10 is still the better way to go for a database with a lot of
writes. For something like a data warehouse it might not be so
critical.- Hide quoted text -
- Show quoted text -
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...
|
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...
|
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...
|
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...
|
by: Dave |
last post by:
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.
...
|
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...
|
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...
|
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...
|
by: DannielHS |
last post by:
*A RAID distributes data across several physical disks which look to the operating system and the user like a single disk. Several different arrangements are possible. We assume here that all the...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
| |
