Enterprise Storage Bench - Microsoft SQL WeeklyMaintenance

Our final enterprise storage bench test once again comes from our own internal databases. We're looking at the stats DB again however this time we're running a trace of our Weekly Maintenance procedure. This procedure runs a consistency check on the 30GB database followed by a rebuild index on all tables to eliminate fragmentation. As its name implies, we run this procedure weekly against our stats DB.

The read:write ratio here remains around 3:1 but we're dealing with far more operations: approximately 1.8M reads and 1M writes. Average queue depth is up to 5.43.

Microsoft SQL WeeklyMaintenance - Average Data Rate

For our final enterprise test, the 710 actually manages to edge out the old X25-E. All three Intel drives appear to be bumping into the 3Gbps SATA barrier at this point though.

Microsoft SQL WeeklyMaintenance - Disk Busy Time

Microsoft SQL WeeklyMaintenance - Average Service Time

Average service times tell a story of firmware optimizations once more. Despite using the same controller, the 710 clearly does better than the 320 in enterprise workloads. Once again, under load, we see the 710 post better numbers than the X25-E (although the margin is small enough to be negligible). The SF-2281 continues to dominate.

Enterprise Storage Bench - Microsoft SQL UpdateDailyStats AnandTech Storage Bench 2011
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