Quick and Dirty - LSI 3041E (1064E) SAS PCIe Card vs Dell CERC SATA 1.5/6ch Card

Okay,

I have a customer with a Dell Poweredge 1800. It comes with the Dell CERC SATA 1.5/6ch RAID controller. It was configured for RAID5 operation.

SAP was killing their server with a lot of SQL requests - They have grown quite a bit in the last year, and their simple little fileserver was now hosting exchange, SQL, and a lot of users.

All my testing pointed to the drives not being able to provide the CPU with enough data. Memory and CPU were always low, while the disk queue was through the ceiling all the time.

I've been doing a lot of SAS drive work lately, and I sold them on a basic RAID mirror with 2 146 gig SAS drives (Seagate Cheetah 15k, 32 meg cache).

I selected the LSI 3041E (1064E based) 4 port SAS card because it was only $190 or so, and I've had good luck with LSI products lately (and less with Adaptec).

After an install and format, I ran a very simple IOmeter tests (the default test set) for 5 minutes. This is what I got;

SATA SAS

Operations/Sec 62.98 398.28
Megabytes/Sec .12 .78
Average Response Time(ms) 15.88 2.50


As you can see, the SAS drive array beats the old SATA drive hands down in every test. It's 6.4 times better - 6.4 times more operations per second (reads, writes), it can move 6.4 times more data in a second, and it takes 6.4 times less time to respond to an operation.

Of course, this is a nasty test - It's comparing 7200 RPM 1.5 Gb/sec SATA drives to SAS 15000 RM 3G/sec, it's comparing RAID5 to RAID Mirror. Everything about it is wrong.

But it also shows how much faster life can be for $800 in parts i you have a similar setup. :-)

I'm waiting for real world user comments, and we'll do some SAP end user tests on a number of slow queries shortly to see if the this additional speed is actually being taken advantage of.

ASUS DSEB LSI 1068 MegaRaid Speed vs Intel Matrix

Okay, spent a few hours making some speed tests between the two built in controllers.

I have stats to back up my words, but I don't feel like dragging out all the tests I did and splicing up the graphics/results. I may get to it later.

In a nutshell, with Windows 2008 RC1 64 Bit on a ASUS DSEB-15/SAS Board with 2 Xeon Quads;

- Intel Matrix controller is ever-so-slightly faster for SATA drives than the LSI Megaraid, but not enough to really worry about.
- ESX 3i 3.5 does see the Intel matrix controller, but doesn't see the RAID sets created on it - Just the individual drives.

It looks like you'll still need the SAS option for this board if you want to run RAID of any kind in ESX 3i 3.5