Micron P320h PCIe SSD (700GB) Review
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% | |||

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.


Originally published at https://www.anandtech.com/show/6371/micron-p320h-pcie-ssd-700gb-review-first-nvme-ssd (Wayback Machine).