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
POST A COMMENT

68 Comments

View All Comments

  • Lifted - Friday, September 30, 2011 - link

    If you're going to wear a t-shirt without a jacket, at least have something geeky/nerdy on it. ;) Reply
  • METALMORPHASIS - Friday, September 30, 2011 - link

    After buying one of these drives all you can wear is just a plain t-shirt. Reply
  • EJ257 - Saturday, October 1, 2011 - link

    Yeah like a t-shirt that say "I Void Warranties"

    http://www.thinkgeek.com/interests/techies/8f52/
    Reply
  • michal1980 - Saturday, October 1, 2011 - link

    PM your addy, and I'll send you a tee shirt that has a new collar. yours is stretched out. Reply
  • ph0masta - Saturday, October 1, 2011 - link

    I'm not in the IT biz, yet as a computer tech enthusiast I still find it interesting. I'd to learn more about the high performance warez that are required to run enterprise class computing. Reply
  • dananski - Monday, October 3, 2011 - link

    Stop going off topic, this is clearly about T-Shirts. :P Reply
  • Linkpl4y - Saturday, October 15, 2011 - link

    I wonder if you could fry an egg on an SSD.

    http://www.foodrepublic.com/2011/10/14/how-fry-egg...
    Reply
  • AdamK47 - Friday, September 30, 2011 - link

    This is a good review, but are SSD reviews going to be the only interesting thing for the PC builder/overclocking community to view? You know, the foundation of which AnandTech was build on. I remember all of the great reviews for 7+ years ago. If it weren't for the forums, I really wouldn't be here still. Where are the Sandybridge-E previews or the Bulldozer previews? How about some good old fashioned overclocking analysis? Throw in some good gaming benchmarks while you're at it. I couldn't care less about business IT hardware, efficient HTPC, or Apple related reviews. Is this where your analysis team has deemed the direction the site should go in? Reply
  • dac7nco - Friday, September 30, 2011 - link

    In all fairness, IT hardware is interesting to quite a few people. There are a few places here and there that benchmark games. I agree about the Apple reviews; I couldn't care less, and neither would most sane people. Reply
  • B3an - Saturday, October 1, 2011 - link

    I also couldn't care less for anything Apple related. But sadly Apple articles seem to get quite a lot of attention so i doubt they'll be going away. It's like everything that does well... after a while things start to get more mainstream and you cant get more mainstream than Apples useless toys. I have no problem with this review at all though, i just hope these kinda detailed reviews dont disappear. Reply

Log in

Don't have an account? Sign up now