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

  • 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. ;)
  • METALMORPHASIS - Friday, September 30, 2011 - link

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

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

    http://www.thinkgeek.com/interests/techies/8f52/
  • 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.
  • 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.
  • dananski - Monday, October 3, 2011 - link

    Stop going off topic, this is clearly about T-Shirts. :P
  • 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...
  • 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?
  • 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.
  • 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.

Log in

Don't have an account? Sign up now