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

  • 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