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

With a significant improvement to sequential write speed, combined with competitive sequential read speed, the P400m manages to tangibly outperform the P400e. Intel's S3700 remains the fastest 2.5" SATA drive we've tested here.

Microsoft SQL UpdateDailyStats - Disk Busy Time

Microsoft SQL UpdateDailyStats - Average Service Time

A look at average service time shows the P400m as having very competitive latency to even the best Intel has to offer. Keep in mind that not all workloads are as latency sensitive as our IO consistency test. For those that are more latency tolerant, the P400m and S3700 look far more similar than you'd think.

Random & Sequential Performance Enterprise Storage Bench - Microsoft SQL WeeklyMaintenance
Comments Locked

23 Comments

View All Comments

  • JarredWalton - Wednesday, February 13, 2013 - link

    I'm not sure what causes it, but periodically when an article posts the Like button is broken and basically "maxes out". I don't know where the 1394 number comes from (not FireWire! Hahaha), but I'll pass the info to John, our web guy, to see if he can do something about it. It was supposed to be fixed....
  • Beenthere - Wednesday, February 13, 2013 - link

    Tell that to those with the "100 hour crash" syndrome...

    All of the SSD makers have been rushing half-baked products to market for huge profits from gullible consumers duped by the media. With Smasungs SSD and now PC issues, it's pretty safe to conclude that quite a few of the brand name SSD suppliers are cashing in on half-baked crap.
  • Death666Angel - Wednesday, February 13, 2013 - link

    Was he saying that they never have issues with their SSDs? No, that's what the "more" indicates (more stable than competition, not absolutely, 100% stable all the time).
    And just because there are issues doesn't mean things are half baked, in my opinion. Everything can have issues, even centuries old technology or stuff they through countless man-hours and money at. I personally owned 3 SSDs (Agility, Vertex2, 840 non-Pro), all working fine to this day. I owned a Samsung laptop, smartphone, tablet, all fine. Am I saying that everything with them is fine? No. But there is no point in being a doom-sayer like you at the moment either.
  • Mr Perfect - Wednesday, February 13, 2013 - link

    Don't mind him, he posts something similar in every SSD related article regardless of make or model.
  • Death666Angel - Wednesday, February 13, 2013 - link

    Thanks I'll note his name for ignoring in the future :P.
  • JellyRoll - Wednesday, February 13, 2013 - link

    The whole thing looks great (with the exception of Anand making some very major flaws listing the design of the unit) until the very end where he essentially says, "buy intel", even though they have nowhere near the features of the P5400m. I am wondering how he came to that conclusion.
  • melgross - Wednesday, February 13, 2013 - link

    I don't recall him saying that. He mentioned price performance. This performs somewhat worse than the Intel drive, so he said that if it were less expensive, it would be worth looking at, but that if it were more expensive, then the Intel drive would be a better bet. Since micron's pricing is pretty high, as given, though they told him the pricing was wrong, we don't know the pricing.

    I think his closing remarks were right on the money, so to speak.

    Are you sure you understood what he said?
  • Mr Perfect - Wednesday, February 13, 2013 - link

    I'm assuming that the endurance rating "DW" is referring to drive-writes a day? Meaning "10DW x 5 years" is ten complete drive writes a day for five years?
  • Anand Lal Shimpi - Wednesday, February 13, 2013 - link

    Correct, I will clarify in the table.

    Take care,
    Anand
  • zeadlots - Wednesday, February 13, 2013 - link

    Is it just me or do the graphs on the second page feature the Samsung 840pro SSD, but the subsequent graphs all have the Samsung SM825. It was my understanding that the 840pro was top 3 on most tests according to another article of yours. Hoping someone can doublecheck this.

Log in

Don't have an account? Sign up now