Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a new Dell 2950 with PERC 6/e and 14 external SAS 15K 73GB drives. An Oracle 11g database job takes 3 hours to run with the drives set as hardware RAID 10 (striped across 7 mirrored pairs). The database size is about 26GB. The same job running on just two drives in RAID 1 takes only 1 hour. OS is Win 2008 R2.

Before we change the RAID level (with considerable downtime) on the production box, does anyone know why we're seeing this odd result, and if there's a better way to fix it?

ADDED INFO

PERC 6/e should be running the latest firmware and cache battery OK.

FINALLY, THE REAL STORY

After speaking w/the DBA, my face is red. Turns out the RAID 1 is seven RAID 1 volumes of two drives each. The data tables and indices were assigned to each volume to minimize contention. Apparently a good DBA can get more performance from 14 drives than a RAID 10 controller striping blindly across them without regard for file access patterns. Some SANs claim to intelligently migrate files to improve performance, but if there's a bake-off anytime soon, my money's on our DBA!

share|improve this question
    
How are these things all hooked together, some sort of port multiplier that might be bottlenecking something or another? Also, is this array configured in the PERC controller itself or is this software raid? Finally, if it takes "considerable downtime" to switch the RAID level, were you getting the job done in one hour on the same equipment before setting it up as RAID 10, or are you getting it done in one hour on some other equipment? –  DerfK Feb 19 '11 at 3:19
2  
When you say that they were faster in RAID 1, what exactly does that mean? RAID 1 means they are mirrored, RAID 10 means they are striped AND mirrored. RAID 1 with 14 drives doesn't really make sense, since you'd basically have 1 drive mirrored 13 times. –  Jed Daniels Feb 19 '11 at 5:24
    
@Jed Thanks...I will ask our admin and update the question, but it may take few days. @DerfK Same equipment - test box identical to production. –  Paul Feb 19 '11 at 14:20
    
If you correctly setup those 14 drives in RAID10, you should yield usable space just under 500GB. Is that what you get? Check to see also that the controller's battery is still good otherwise write caching will be turned off. RAID10 should SMOKE RAID1 with that many SAS disks. Also what KIND of PERC is this, what model? –  SpacemanSpiff Feb 21 '11 at 1:21

2 Answers 2

up vote 1 down vote accepted

I think user71281 implies that your RAID controller (or driver) is messing up. When you go through the RAID setup of your controller (or driver), a RAID10 setup should never be slower then a simple RAID1.

Your RAID solution has either allowed you to setup an extremely inefficient RAID10 array, or you have uncovered a bug. Maybe performance improves with an 8th pair? Or maybe when you reduce the setup to 4 pairs? This last option may mean you have to upgrade to 146GB disks.

But I'd check for firmware updates first, and check how much RAM is on the RAID card. It didn't switch off its caching function because of a dead BBU (battery backup unit), did it?

share|improve this answer

Actually a RAID1 is faster than a RAID10 and of course a RAID 0 is faster than both of them. The reason is the parity and calculation overhead is highr with a RAID10 than 7-RAID1 volumes. As your DBA stated there is less disk contention and more spindle isolation.

The downside is more chances to run out of disk space for each RAID1 pair. The seperation is great when running many unlike transactions however ther eis a performance benifit in striping multiple drives in a RAID1 as now many spindle work together in parallel.

One thing to consider is your cluster size when creating a smaller disk will be smaller. You may want to use DISKPART and set the Cluster size to 8K for your logs and 64K for your data and not mix logs and data together on the same raid1o. This is most likely how your DBA had it setup and now you ghave combined both on the same RAID10 causing more disk contention.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.