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.
I know that 0+1 is not as good as 10 for availability, fault tolerance,
and rebuilding, but shouldn't the write throughput be about the same?
Setup:
Poweredge 2850
Powervault 220S
Perc 4/DC Controller 1
Perc 4e/DI Controller 0 5 1804
Hi
I don't know about the Dell configuration but you would probably want to
look at all the other alternatives before doing this.
For instance, you don't say exactly what the disc configuration is for
instance have you put database data files and database log files on separate
spindles? Have you got different filegroups on different spindles? Have you
split filegroups into multiple files on different spindles? Are the system
database on different spindles? Is tempdb on different spindles? Have you
thought about adding extra discs to the current array? Have you checked to
see if rewriting the code would reduce the I/O?
John
"Dave" <da******@gmail.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com... 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.
I know that 0+1 is not as good as 10 for availability, fault tolerance,
and rebuilding, but shouldn't the write throughput be about the same?
Setup: Poweredge 2850 Powervault 220S Perc 4/DC Controller 1 Perc 4e/DI Controller 0
Very good suggestions John! I agree that log files should be on a
separate spindle, and that I should break down the file groups into
multiple physical files, etc, etc.
I will implement all of these suggestions as soon as I get the
opportunity, however I do not think they will increase the throughput
enough to meet our needs.
We are only using 2 Raid 5 arrays right now. That somewhat limits the
load balancing options. I am really pushing for another Raid
Controller card or even 2 so I can properly balance the system.
There is some bad code out there, but I have re-written most of it and
I'm sure I can make further improvements, though I do not think it is
a major issue anymore.
Hi Dave
Use perfmon to get the information you require regarding disc performance,
that will show if new hardware is needed. Look at disc queue length, idle
time, read/write rates etc see http://www.sql-server-performance.co...nce_audit2.asp for
more.
John
"Dave" <da******@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com... Very good suggestions John! I agree that log files should be on a separate spindle, and that I should break down the file groups into multiple physical files, etc, etc.
I will implement all of these suggestions as soon as I get the opportunity, however I do not think they will increase the throughput enough to meet our needs.
We are only using 2 Raid 5 arrays right now. That somewhat limits the load balancing options. I am really pushing for another Raid Controller card or even 2 so I can properly balance the system.
There is some bad code out there, but I have re-written most of it and I'm sure I can make further improvements, though I do not think it is a major issue anymore.
I have already done that. I am getting numbers around 50K on % write
time while I run my ETL.
John Bell wrote: Hi Dave
Use perfmon to get the information you require regarding disc performance, that will show if new hardware is needed. Look at disc queue length, idle time, read/write rates etc see http://www.sql-server-performance.co...nce_audit2.asp for more.
John
"Dave" <da******@gmail.com> wrote in message news:11**********************@i39g2000cwa.googlegr oups.com... Very good suggestions John! I agree that log files should be on a separate spindle, and that I should break down the file groups into multiple physical files, etc, etc.
I will implement all of these suggestions as soon as I get the opportunity, however I do not think they will increase the throughput enough to meet our needs.
We are only using 2 Raid 5 arrays right now. That somewhat limits the load balancing options. I am really pushing for another Raid Controller card or even 2 so I can properly balance the system.
There is some bad code out there, but I have re-written most of it and I'm sure I can make further improvements, though I do not think it is a major issue anymore.
Hi Dave
I am not sure where 50K comes in when you are talking about a percentage?
John
"Dave" <da******@gmail.com> wrote in message
news:11*********************@t31g2000cwb.googlegro ups.com... I have already done that. I am getting numbers around 50K on % write time while I run my ETL.
John Bell wrote: Hi Dave
Use perfmon to get the information you require regarding disc performance, that will show if new hardware is needed. Look at disc queue length, idle time, read/write rates etc see http://www.sql-server-performance.co...nce_audit2.asp for more.
John
"Dave" <da******@gmail.com> wrote in message news:11**********************@i39g2000cwa.googlegr oups.com... > Very good suggestions John! I agree that log files should be on a > separate spindle, and that I should break down the file groups into > multiple physical files, etc, etc. > > I will implement all of these suggestions as soon as I get the > opportunity, however I do not think they will increase the throughput > enough to meet our needs. > > We are only using 2 Raid 5 arrays right now. That somewhat limits the > load balancing options. I am really pushing for another Raid > Controller card or even 2 so I can properly balance the system. > > There is some bad code out there, but I have re-written most of it and > I'm sure I can make further improvements, though I do not think it is > a major issue anymore. > This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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: 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...
|
by: P4ZP47Z |
last post by:
Here is my situation:
- My windows install/apps/games were eaten by a virus that replicates into and
wrecks .exe files
- I made an Ubuntu 9.10 CD on my friends pc, and a Xubuntu 9.10 DVD...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: 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...
|
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,...
|
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...
| |