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

  • 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