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

Things look a lot better with our first SQL benchmark, Micron's P320h outperforms both of the OCZ SandForce based offerings. Only Intel's 910 is faster, but it maintains a healthy performance advantage here over the P320h (~44%).

Average service times are very low, which is one of the benefits of being able to serve so many IOs in parallel by a native PCIe SSD controller.

Microsoft SQL UpdateDailyStats - Disk Busy Time

Microsoft SQL UpdateDailyStats - Average Service Time

Enterprise Storage Bench - Oracle Swingbench Enterprise Storage Bench - Microsoft SQL WeeklyMaintenance
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