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

The read heavy nature of both of these SQL tests has the P400m and P400e performing very similarly. Here Intel pulls ahead by a healthy 32%.

Microsoft SQL WeeklyMaintenance - Disk Busy Time

Microsoft SQL WeeklyMaintenance - Average Service Time

Once again we see very competitive latency figures out of the P400m. Micron's latest isn't quite as good as the S3700 when it comes to latency, but it's in good company.

Enterprise Storage Bench - Microsoft SQL UpdateDailyStats Power Consumption
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