Enterprise Storage Bench - Microsoft SQL UpdateDailyStats

Our next two tests are taken from our own internal infrastructure. We do a lot of statistics tracking at AnandTech - we record traffic data to all articles as well as aggregate traffic for the entire site (including forums) on a daily basis. We also keep track of a running total of traffic for the month. Our first benchmark is a trace of the MS SQL process that does all of the daily and monthly stats processing for the site. We run this process once a day as it puts a fairly high load on our DB server. Then again, we don't have a beefy SSD array in there yet :)

The UpdateDailyStats procedure is mostly reads (3:1 ratio of GB reads to writes) with 431K read operations and 179K write ops. Average queue depth is 4.2 and only 34% of all IOs are issued at a queue depth of 1. The transfer size breakdown is as follows:

AnandTech Enterprise Storage Bench MS SQL UpdateDaily Stats IO Breakdown
IO Size % of Total
8KB 21%
64KB 35%
128KB 35%

Microsoft SQL UpdateDailyStats - Average Data Rate

In the first of our two SQL tests the 710 and X25-E are far closer than they were in the Swingbench results. Although the 710 uses MLC-HET NAND, it delivers 93% of the performance of the X25-E. The SF-2281 based Vertex 3 pulls ahead, but this is obviously a consumer drive and not something I'd expect 710 customers to be cross shopping. An enterprise version of the Vertex 3 with a proven track record could be a very interesting option however.

Microsoft SQL UpdateDailyStats - Disk Busy Time

Microsoft SQL UpdateDailyStats - Average Service Time

Despite relatively close average data rates, average service time is significantly improved over the desktop 320. Furthermore the 710 cranks through IOs at nearly the same latency as Intel's X25-E. Under heavy load, the X25-E and SSD 710 are virtually indestinguishable. Once again SandForce shows its strengths quite well here.

Enterprise Storage Bench - Oracle Swingbench Enterprise Storage Bench - Microsoft SQL WeeklyMaintenance
Comments Locked

68 Comments

View All Comments

  • Stas - Sunday, October 2, 2011 - link

    Makes you wonder: how did Anandtech survive in the olden days?
  • Anand Lal Shimpi - Friday, September 30, 2011 - link

    I didn't preview Bulldozer because it would've been a disservice to the community. The performance levels of chips we had access to prior to going under NDA with AMD just wasn't representative of anything.

    Don't worry, you'll get to hear about Bulldozer soon enough :) AMD said shipping in Q4...

    Take care,
    Anand
  • Voidman - Friday, September 30, 2011 - link

    I actually would have agreed with this comment a lot more a year ago, or even 6 months ago. I am starting to see a few actual PC builder related reviews in recent months, and am happy about it. (Of course consumer SSD's are of interest to home builders, but that was about the only thing here that was). I was pleasntly surprised to see several reviews on cases/enclosures, something I have not seen here for a long time. And a PSU and monitor review here and there also. All of this came too late for my last build, but it is nice to see anyway.

    It does seem that there was a decision a couple of years ago to concentrate on smart phones and tablets and home theater gear, with SSD and enterprise IT articles filling in the gaps. I hope the recent trend of more PC builder related articles and reviews continues.
  • kevith - Saturday, October 1, 2011 - link

    Apples products are interesting because they show the way. Tablets, phones and OS, they have the best. (And most expensive and hyped and with a congregation that's gross). But when Apple launches a product, EVERYONE else will try to copy it within months, whether you like it or not. Thats why its interesting reading.

    Enterprise hardware is interesting to read about because it shows what a new piece of hardware are ACTUALLY capable of. In this case it shows, that if you want a real reliable SSD, the "nickels and dimes", that a consumer-SSD costs is simply not enough.
  • THizzle7XU - Saturday, October 1, 2011 - link

    "Apples products are interesting because they show the way."

    I actually feel like the media at this point puts Apple in a position to create a self fulfilling prophecy in this regard. The iPad is the greatest example of this. Before the iPad came out there were rumors for years, pretty much since the iPhone debut, that Apple was working on a tablet and how it would be the greatest thing ever. I feel like after the rumors went on for a while, Apple was like, "Ya, this thing sounds cool! Maybe we should build a tablet!". And then all the other manufactures sat on their hands while the obvious was happening waiting for Apple to release the design template when the blueprint was crystal clear for tablets (i.e. just their phone OS on a bigger screen with slight modifications to the apps to take advantage of the screen res).

    It's like Apple pays its competitors not to compete with its ideas until they have released their product. And they everyone else becomes a copy cat of ideas that were so painfully obvious in the first place because they inexplicably waited until Apple released their version.
  • Stas - Sunday, October 2, 2011 - link

    How dare you?! Steve Jobs created the universe. zOMG I'm getting wet dreaming about iPhone 5 !!!11!11!111
  • inplainview - Sunday, October 2, 2011 - link

    I must suck being you....
  • Hulk - Friday, September 30, 2011 - link

    I've been here from day one and Anand keeps getting better. In my opinion he has always been the best tech writer on the internet and now I see his thoughts are as clear an organized when doing a video review. Bravo!

    Kudos to all of the guys on the Anandtech site. The flavor of all of the reviews flows down to everyone here. Anand is still the best but luckily he is rubbing off on all his guys.
  • wxrkny - Friday, September 30, 2011 - link

    "Anand is still the best but luckily he is rubbing off on all his guys."

    I hope not, that's gross

    sorry I had to
  • TommyAU - Friday, September 30, 2011 - link

    Haha

Log in

Don't have an account? Sign up now