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

  • inplainview - Saturday, October 1, 2011 - link

    Useless toys? Is this coming from someone that can't afford Apple's offerings or someone who hasn't figured out that Apple is in the mainstream of consumer offerings and mentioning them is this consumer space is quite appropriate considering Apple's influence. You have proven yourself to be myopic and petty.
  • Stas - Sunday, October 2, 2011 - link

    umadbro? Everything Apple sucks :D
  • gevorg - Saturday, October 1, 2011 - link

    At least there is no Top 100 iPhone apps here. :)
  • web2dot0 - Friday, September 30, 2011 - link

    Unfortunately, that's what people want to read nowdays. Anand is just targeting the mainstream. Otherwise, how will he get all the pageviews? It's a business afterall. Let's not be naive. He doesn't choose his articles to write about by random. There's always a reason to the madness. He's just trying to stay (slightly) ahead of the curve. Too hard out, and it'll become irrelevant.

    Just wish the team stops writing so many editorial news reporting and focuses more on technical analysis like the ones above. The site is slowly becoming more and more corporate and with time, it will lose it's edge.

    Anyways, it's not like other sites are that much better. There's always room for improvement ....
  • taltamir - Saturday, October 1, 2011 - link

    Apple has single digit market-share. This is as far from mainstream as possible.
  • B3an - Saturday, October 1, 2011 - link

    ....Yeah in computers but thats it. Apple are the largest consumer tech company on the planet, they now make more money than Microsoft. Apple pretty much have a monopoly on MP3 players and online music. They have the single best selling phone, the best selling tablet, and are gaining PC market share. For tech stuff you cant get more mainstream than Apple. There useless devices dont belong on serious sites like this IMO, they belong on dumbed down crap like Engadget.
  • inplainview - Saturday, October 1, 2011 - link

    How many of you would be willing to financially support this site so that you can get your truckload of geek? Most likely zero to none. This site is supported via page hits which means that the authors have to write about stuff that most of the basement dwellers here aren't interested in. However, as someone who actually goes out into the sun, knows what women look like, smell like, taste like (figure it out), and realize that there is a world outside of sitting in front of a keyboard and bitching about how this site is not this and that, I can appreciate the work put in. Some of you people are simply whiners and pathetic.
  • Stas - Sunday, October 2, 2011 - link

    Apple unofficially owns Engadget
  • KPOM - Saturday, October 1, 2011 - link

    In the US, Apple has the third largest share of the PC market.

    http://arstechnica.com/apple/news/2011/07/apple-no...

    It's lower worldwide, but Apple is definitely a mainstream PC manufacturer.

    http://osxdaily.com/2011/03/18/mac-market-share-ar...
  • Penti - Saturday, October 1, 2011 - link

    Anandtech is far from and far more then just a gadget site. Times change and you have to keep up with that to. So of course the focus changes, it's not all about the baddest mainstream overclocking mainboards and high-end gamer gpus any more, things have changed and people come here because it's not just fluff but also digs through down in the hardware/product. You will have more smartphones, notebooks and so on the gpu wars itself won't get you a lot of readers. You will have more enterprise topics and so on. Computing has changed. It's not really about gaming any more and that market has changed.

Log in

Don't have an account? Sign up now