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

  • itanic - Monday, October 15, 2012 - link

    Isn't this essentially just what FusionIO has been doing all along, except without all the drivers/software surrounding it?
  • FunBunny2 - Monday, October 15, 2012 - link

    That's my understanding. As to who IDT is?
  • webdev511 - Monday, October 15, 2012 - link

    IDT (Integrated Device Technology) has been doing IC controllers for a Loooooong time.
  • iamkyle - Wednesday, October 17, 2012 - link

    How can you not remember the IDT WinChip!?
  • ericgl21 - Monday, October 15, 2012 - link

    I wish they could have made a bootable SSD card, so the UEFI BIOS can see it as any other storage component. After all, it would be nice to have an OS installed directly on it.
  • extide - Monday, October 15, 2012 - link

    For home /power users, yeah you'd want that, but for this thing's target market booting from it is not an issue.
  • blackmagnum - Monday, October 15, 2012 - link

    Want SSD storage at the sweetspot of 1 dollar/ 1 gigabyte.
  • Zak - Monday, October 15, 2012 - link

    There are plenty of SSDs, although SATA not PCIe, for less than $1 per gigabyte.
  • colonelpepper - Monday, October 15, 2012 - link

    $2,000+ USD for a 2TB drive???

    ...in other news, I'd like to buy a 32 inch LCD screen at the sweetspot price of $16,000.
  • melgross - Monday, October 15, 2012 - link

    There's a sweet spot for RAM, in varying sizes, HDD's and SSD's. they're all different.

Log in

Don't have an account? Sign up now