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

  • igf1 - Saturday, October 1, 2011 - link

    My God, how did the vertex 3 get so far ahead of the pac?
  • Broheim - Saturday, October 1, 2011 - link

    how could a SATA 6GB/s drive possibly be faster than a bunch 3GB/s drives? oh wait...
  • floam - Saturday, October 1, 2011 - link

    How well should this drive do without TRIM? I imagine this is somewhat important to those doing RAIDs. Or in my case, just holding one big giant VHD file.
  • inplainview - Saturday, October 1, 2011 - link

    Anand,

    Start charging for access to your site and see how many of the hardcore keyboard banging, momma's basement dwellers will actually fork over cash to keep things here uber-techie. I can appreciate the work that you're doing even if it not as nuts and bolts as some would like. I've gleaned valuable info that has helped me to make some informed purchases that I am quite happy with. For that I think you.
  • mmrezaie - Saturday, October 1, 2011 - link

    What I really like to see in these SSDs is the impact of encryption. Not just hardware level, but software solutions from both windows, and Linux. it seems that they are getting more and more important these days.
  • Ushio01 - Saturday, October 1, 2011 - link

    Anand since you now have an enterprise storage bench will you be reviewing the Micron RealSSD P300 and P400e SSD's especially the P300 as it uses SLC nand with a 6.0 Gb/s controller.
  • tipoo - Saturday, October 1, 2011 - link

    What kind of mic that is.
  • geok1ng - Saturday, October 1, 2011 - link

    is thesse drive have 40%+ spare area, then cost per GB is actually $3 to $4, Inline with premium market.
    And there is already a ssd that uses 50% spare area, the cache oriented OCZ Nocti, that i would like to see a review, compared with 20gb 311 series, 40g Corsair F40 and Crucial m4 64GB.
  • sheh - Saturday, October 1, 2011 - link

    200GB != 200,000,000,000,000 bits
    200GB == 200,000,000,000 bytes

    ---

    Data retention always worried me. Is that 1 year retention for consumer drives only once it's exhausted its writable days or also for brand new?

    Do drives refresh themselves or is there a need to do a read-rewrite everything once in a while?
  • freespace303 - Saturday, October 1, 2011 - link

    Where are the Crucial drives on here? I have one and would love to see how they stack up against these new Intel drives.

Log in

Don't have an account? Sign up now