Enterprise Storage Bench - Oracle Swingbench

We've been toying with the idea of bringing enterprise performance tests to our SSD reviews for over a year now. We had expected to have more time to launch the suite but the Z-Drive R4 (and another enterprise SSD) were dropped on us unexpectedly so we had to rush things a bit. By no means is this the extent of our enterprise storage bench, but it's a start.

We begin with a popular benchmark from our server reviews: the Oracle Swingbench. This is a pretty typical OLTP workload that focuses on servers with a light to medium workload of 100 - 150 concurrent users. The database size is fairly small at 10GB, however the workload is absolutely brutal.

Swingbench consists of over 1.28 million read IOs and 3.55 million writes. The read/write GB ratio is nearly 1:1 (bigger reads than writes). Parallelism in this workload comes through aggregating IOs as 88% of the operations in this benchmark are 8KB or smaller. This test is actually something we use in our CPU reviews so its queue depth averages only 1.33. We will be following up with a version that features a much higher queue depth in the coming weeks.

Oracle Swingbench - Average Data Rate

Surprisingly enough the SF-2281 based drives don't actually do all that well here. A single Vertex 3 is only good for 38MB/s, while the old X25-E manages 56.1MB/s. The Z-Drive R4 is the fastest drive here but only by 30% margin.

Oracle Swingbench - Disk Busy Time

The same results are reflected if we look at disk busy time. However as I mentioned before, this benchmark features a very low average queue depth. With only one IO running most of the time you're not going to see much of a difference between multi-controller and single-controller drives. Despite this fact there's still a 90%+ advantage the Z-Drive R4 enjoys over a single Vertex 3, implying that there are periods of extremely high queue depths that are simply being hidden in the average. In order to see how well the drive does in these periods of very heavy IO activity we need to look at another metric: average service time.

Oracle Swingbench - Average Service Time

Average data rate and disk busy time tell us how much data is moved but they don't tell us how quickly each stacked IO completes. Average service time gives us this data. Here we see huge performance advantages for the SF-2281 drives, and the Z-Drive R4 is significantly faster than even the RevoDrive 3 X2.

Both metrics are important - one gives you an idea of average performance while the other illustrates how the drive performances under heavy load.

AnandTech Storage Bench 2011 - Light Workload Enterprise Storage Bench - Microsoft SQL UpdateDailyStats
Comments Locked

57 Comments

View All Comments

  • squashmeister99 - Tuesday, September 27, 2011 - link

    You teased us with your video reviews. Now we cant go back... :-)
  • G-Man - Tuesday, September 27, 2011 - link

    I miss the video reviews already :-)
  • vol7ron - Tuesday, September 27, 2011 - link

    hahaha. they are a good addition aren't they?
  • Rasterman - Wednesday, September 28, 2011 - link

    Comparing a single Vertex 3 240GB to a 1.6TB doesn't seem quite valid. Someone considering the R4 would be asking what is the performance difference between the R4 and 4 to 16 Vertex 3s in RAID 0. Especially considering the massive cost savings per GB using the Vertex 3s.
  • MrBungle123 - Wednesday, September 28, 2011 - link

    I'd like to see some RAID 5/6/10 arrays of 15K RPM SCSI drives in the benchmarks too.
  • marraco - Wednesday, September 28, 2011 - link

    No. I don't want video reviews, unless they have English subtitles.
  • SilthDraeth - Wednesday, September 28, 2011 - link

    I have trouble hearing and use subs for all my movies, yet Anand speaks quite clearly, and I have no trouble understanding him.

    Also, he posts the video review in conjunction with the written review, and not as a stand alone feature, so you really don't need it subtitled. So you would still get to enjoy the reviews as you always have.
  • Lonbjerg - Thursday, September 29, 2011 - link

    You can write english but not understand it when it's spoken? *shakes head*
  • connor4312 - Thursday, September 29, 2011 - link

    I'm guessing you never learned a second language?
  • arthur449 - Wednesday, September 28, 2011 - link

    Not all information provided is specifically relevant to everyone's interests in a review of a product. Similarly, information provided in a video review follows a linear arbitrary organizational structure that cannot possibly align with everyone's preferred method of learning. Also, it's easier to skim / search / quote / share a text-based review.

Log in

Don't have an account? Sign up now