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

  • philipma1957 - Wednesday, February 13, 2013 - link

    I missed the warranty on this drive was it 3 or 5 years?
  • Beenthere - Wednesday, February 13, 2013 - link

    The warranty doesn't matter much because if you need to use it, you'll get a repaird unit that isn't likely to last 1 year based on many people's experience. The lost data is the real issue for most people...

    For those who don't know, now days a longer product warranty does not decree a better quality product. Products with longer warranty cost more to pay for the longer warranty.
  • designerfx - Wednesday, February 13, 2013 - link

    I don't get your point? The point of a warranty is to guarantee performance up to the stated warranty period. That's never been about quality or not. Whether you get a good unit back from warranty is entirely going to be luck of the draw with any manufacturer.

    It's no different in the car industry, Hyundai's 10 year warranty isn't an indicator of quality either.
  • peterfares - Wednesday, February 13, 2013 - link

    I think his point is that because its an enterprise drive and because warranty replacements are unreliable, they wouldn't be put into service in an enterprise environment.
  • DuckieHo - Thursday, February 14, 2013 - link

    Why would an enterprise replacement be unreliable? Hardware fails... that's why there's a warranty in the first place.

    Not replacing the drive or using a different drive would absolutely be more risky to uptime.
  • JellyRoll - Wednesday, February 13, 2013 - link

    I googled to find more data on this "XPERT NAND" that is mentioned in this article. It actually doesn't exist, though a PDF explains that XPERT is not NAND, it is actual firmware and algorithms. I can't believe Anand missed the mark so badly.
  • Anand Lal Shimpi - Wednesday, February 13, 2013 - link

    It's a combination of NAND binning/tech, firmware and validation. From Micron's reviewer's guide on the P400m:

    "The P400m is built from the ground up with custom 25nm MLC NAND that uses Micron’s extended performance and enhanced reliability technology (XPERT)."
  • JellyRoll - Wednesday, February 13, 2013 - link

    Well..that states specifically that it uses XPERT technology but not that the NAND is XPERT NAND.
    For instance, some Marvell SSDs use F.R.A.M.E. technology, but they do not refer to it as F.R.A.M.E. NAND.
  • mmonnin03 - Thursday, February 14, 2013 - link

    All the NAND is pretty much the same. The only thing really different with the NAND is binning during probe. A fuse blown here, a fuse blown there. Fab process is the same.

    If its 42GBit chips like the article mentioned then these are the TLC designed chips but only storing 2 bits in a Cell. 2/3 of 64GBit chip = 43GBit.
  • JellyRoll - Wednesday, February 13, 2013 - link

    Its weird but I noticed when this article posted that there were already 1,394 likes in the icon above. I come back three hours later and there is the exact same number of likes! It really blew my mind that there would be 1,394 likes in the first five minutes of this article being posted, but now i see that the Like button must be broken :)

Log in

Don't have an account? Sign up now