473,735 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

RAID vs isolated spindles

Helpful folks,

I am trying to find any doc or research or studies comparing the pros
and cons of architecting a DB2 disk subsystem to physically segragate
index access and data access on separate spindles, as opposed to
putting both index and data on one RAID group and assuming the
striping will provide adequate segregation.
Can anyone point me in a good direction for finding such info?

Thanks in advance
Sean
Dec 11 '07 #1
7 1945
"Scav" <db*****@yahoo. comwrote in message
news:28******** *************** ***********@e23 g2000prf.google groups.com...
Helpful folks,

I am trying to find any doc or research or studies comparing the pros
and cons of architecting a DB2 disk subsystem to physically segragate
index access and data access on separate spindles, as opposed to
putting both index and data on one RAID group and assuming the
striping will provide adequate segregation.
Can anyone point me in a good direction for finding such info?

Thanks in advance
Sean
How big is your database, and how much memory does your database server have
for use in bufferpools. If your bufferpool hit ratio is high, it won't make
any difference.
Dec 12 '07 #2
Scav wrote:
Helpful folks,

I am trying to find any doc or research or studies comparing the pros
and cons of architecting a DB2 disk subsystem to physically segragate
index access and data access on separate spindles, as opposed to
putting both index and data on one RAID group and assuming the
striping will provide adequate segregation.
Can anyone point me in a good direction for finding such info?

Thanks in advance
Sean
You need to start with the performance guides and build your
understanding of the pro's and con's of each storage mechanism. Once you
have this understanding, you'll need to apply it to your expected load
and then verify it against the actual load placed on the disk subsystem.

Separate disks isolate physical arm movement of data and indexes. Raid
cannot do this because the array is (usually) treated as a single disk.
The simplest isolation; a separate single drive for indexes and data
will allow twice the number of arm movements per second than placing
both components of the data base on a single drive.

Raid-5 type arrays need to be examined very very carefully. The normal
write procedure for this mechanism requires reading data from all of the
disks in the array and always writing data to a minimum of two disks.
When the database manager is in a "wait for write operation to complete"
state, the potential delays for the multiple reads and writes can be
significant. Hardware is available for raid arrays that may alleviate
this problem.

Phil Sherman
Dec 12 '07 #3
Thanks for the detailed replies. Here is some background.

DB2 V8 running on Windows 2000 Ent server, 4g of memory
Fiber attached Clariion shelf, 15 physical drives
130g OLTP database

5 RAID groups, each of 3 drives, each group configured as RAID5
3 of these RAID groups are dedicated to data, 2 to indexes.
The largest most transaction-heavy tables have their containers spread
across the 3 data RAID groups and their indexes containsers spread
across the 2 index RAID groups.

A new storage administrator wants to reconfigure the shelf as having a
single RAID group for data and a single RAID group for indexes, both
with RAID5. I am not convinced that this will provide any additional
benefit to performance, and may make things worse. The current config
performs extremely well and has been tuned over a period of years.

I was hoping to find some doc which would shed light on the pros and
cons of this scenario.

Thanks again for the feedback
Sean

Dec 12 '07 #4
And now this Strorage Admin wants to put the transaction logs on the
same RAID groups as the data and index.
Surely this is still a major bad move? Regardless of how versatile
RAID configurations have become, this has to be a detriment to
performance, yes?

Again, is there any doc or white papers that compare these kind of
issues?
Dec 12 '07 #5
Ian
Scav wrote:
And now this Strorage Admin wants to put the transaction logs on the
same RAID groups as the data and index.
Surely this is still a major bad move? Regardless of how versatile
RAID configurations have become, this has to be a detriment to
performance, yes?

Again, is there any doc or white papers that compare these kind of
issues?
Scav,

If your system is performing adequately, my question to the new storage
admin would be: Why change something that's already functioning well?
What advantage will the application users gain from the exercise?

Perhaps the storage admin is looking to reclaim spindles (and therefore
space) for other use.

It's very difficult to write a general white paper for this kind of
question, because each system is unique. The specific disk requirements
are a function of how effective your bufferpools / sort heap are at
eliminating disk I/O. In your case -- if the rate of physical I/O to
each existing RAID group is low enough, combining data/index/temp/logs
may have no effect on end-user performance.


Dec 13 '07 #6
Scav wrote:
Helpful folks,

I am trying to find any doc or research or studies comparing the pros
and cons of architecting a DB2 disk subsystem to physically segragate
index access and data access on separate spindles, as opposed to
putting both index and data on one RAID group and assuming the
striping will provide adequate segregation.
Can anyone point me in a good direction for finding such info?

Thanks in advance
Sean
Perhaps you should also read some of the articles from BAARF:

http://www.miracleas.com/BAARF/BAARF2.html

Jan M. Nelken
Dec 13 '07 #7
On Dec 13, 5:19 am, "Jan M. Nelken" <Unknown.U...@I nvalid.Domain>
wrote:
Scav wrote:
Helpful folks,
I am trying to find any doc or research or studies comparing the pros
and cons of architecting a DB2 disk subsystem to physically segragate
index access and data access on separate spindles, as opposed to
putting both index and data on one RAID group and assuming the
striping will provide adequate segregation.
Can anyone point me in a good direction for finding such info?
Thanks in advance
Sean

Perhaps you should also read some of the articles from BAARF:

http://www.miracleas.com/BAARF/BAARF2.html

Jan M. Nelken

Excellent reference, Jan. I especially recommend Art Kagel's article.

On the other hand, if things work OK, why change? I recommend to read
EMC's papers on tuning CLARiiONs for DB2 (ask your EMC partner to
provide them, if you can't get them on Internet), both you and your
storage admin. In my opinion, for OLTP system, at least logs should
be on RAID 1 or RAID 10 LUN.

For RAID 5 LUN's, if I remember well, EMC guys recommend 4+1 and 8+1
configurations, if you HAVE to use RAID 5 for OLTP. I think that with
RAID 5 CLARiiONs do have some performance improvements to avoid read
before write, when you write full stripe at once. I am not sure if you
can achieve that in OLTP system.

Darko Krstic
Dec 13 '07 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
5628
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...
8
4787
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...
4
4701
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...
5
1835
by: Dave | last post by:
I am recommending that we change our Raid Configuration on some of our Servers from Raid 5 to Raid 0+1; we are experiencing severe IO bottlenecks. Our hardware guys are pushing back a bit. They claim that Dell has a weird implementation of 0+1 and told me something about one drive filling up before it begins to write to the next. They claimed that this gets rid of most of the benefits of 0+1.
13
15406
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. I have 2 identical servers. Hardware: PowerEdge 2850
1
2556
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
17
2230
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...
110
10613
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?
8
2258
by: justin.merth | last post by:
Is there any benefit in creating seperate file groups for a partitioned table on a multi-processor server with RAID5 and 1 Logical Drive?
0
8965
marktang
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...
0
9466
Oralloy
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...
0
9330
jinu1996
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...
0
9202
tracyyun
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...
0
8202
agi2029
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...
1
6748
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4823
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3278
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
2
2741
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.