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

We see the same 44% performance advantage for the 910 over the P320h in our second SQL benchmark. The P320h is ahead of the remaining competitors however.

Average IO latency continues to be a clear strength of the P320h.

Microsoft SQL WeeklyMaintenance - Disk Busy Time

Microsoft SQL WeeklyMaintenance - Average Service Time

Enterprise Storage Bench - Microsoft SQL UpdateDailyStats Final Words
Comments Locked

57 Comments

View All Comments

  • Jaybus - Tuesday, October 16, 2012 - link

    Any particular drive is going to be one or the other. Why make a single complex cotroller when you can make two targeted controllers?
  • crackedwiseman - Monday, October 15, 2012 - link

    Any chance we could see some power consumption numbers on the various PCI-E SSDs? It would be interesting to see if the higher levels of integration in the NVMe controller solution are reflected by power savings. Also, its a shame it's not PCI-E 3.0 certified (although I'm sure it will be, given time) - it's not that the extra bandwidth is necessary, but you could achieve the same bandwidth with fewer lanes.
  • cosmotic - Wednesday, October 17, 2012 - link

    Where's the test results from something like an Areca 1882 filled with high-performance SSDs?
  • N00dles71 - Wednesday, October 17, 2012 - link

    Its funny to see all the dreamers here wishing it booted so when they won the lotto they could have one to go with their quad chip triple SLI dream machine.

    Seriously though, the SLC makes it a good sell to the boss who is worried about it dying before its time. Versus SAS hard drives/SSDs you just pull the dead one out and swap in a new one. Not so easy with these cards if you don't have them mirrored. Add the current market cost of a 2nd one to the mirror it does make it a hard sell. You could rely on these running a bit too well so that failure becomes a massive concern. So far we only trust the HP ones to store data that can easily be restored or is our prime business of massive scale market data capture and therefore mostly useless after 30 minutes.

    We have just started using the HP badged (Fusion) IO Accelerator and are well impressed with its performance. We would love to start using it in more servers but even with preferential HP pricing these are not cheap. If this thing was certified to run in Proliant DL 38x & 58x servers at $3000 I think the market just got tipped on its head. I can't see the competition getting much cheaper than around $8000 on the HP cards so Micron are either going to go in hard and disruptive or they might settle for a "cheaper" price closer to the competition to keep margins high. It would be a shame if they did, these devices are just about ready for a big push into the enterprise market that it is ripe for someone to come in and sweep it all up. We would have brought 4 times the number of cards versus the HP ones.
  • klmccaughey - Friday, November 2, 2012 - link

    This is the second Micron review you have done that there is no available product for. The last one was their new SSD drive which still hasn't appeared. I am in the UK. I wrote to them about the last review you did and they said that although Micron was their parent company, they has no information on when a product would or would not be available.

    I don't understand why they send you products for review, yet even months (nearly a year for the first one?) they aren't shipping the product.

    I can understand proof of concept and all that, and I love this PCIE card, but it's all fantasy IT until we can actually get our hands on it :)
  • klmccaughey - Friday, November 2, 2012 - link

    I meant Crucial by the way - Crucial are still only on the M4 and no sign of any of the stuff they send you ending up on the shelf ;)
  • snozzy - Tuesday, November 6, 2012 - link

    Go to cdw.com and search for "micron p320". You can purchase the exact same card used in this review.

    You can also buy these parts though Dell in a 2.5" form factor along with a server. Go configure a R620/R720/R820 with the PCIe SSD option.

Log in

Don't have an account? Sign up now