Micron P320h PCIe SSD (700GB) Review
by Anand Lal Shimpi on October 15, 2012 3:00 AM ESTEnterprise 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.
Facebook
Twitter
RSS
57 Comments
View All Comments
speculatrix - Tuesday, October 16, 2012 - link
flash memory comes in different forms and longevities.the best SLC flash will outperform and outlast the cheapest TLC flash by considerable margins, but at a cost.
car analogy: do you want a performance car which is extremely well built and designed to survive in harsh environments, or a cheap family car which can only survive a Californian "winter"?
milkod2001 - Monday, October 15, 2012 - link
They have to make this thing bootable and sell 120GB version for 300 bucks max, until then this is just like reading about NASA's new spaceship(interesting but no use for 99% of users)kevith - Monday, October 15, 2012 - link
Spot on!A5 - Monday, October 15, 2012 - link
If you only care about consumer-ready cheap stuff, there are plenty of really boring tech sites out there for you to read.ender8282 - Monday, October 15, 2012 - link
I was just talking with a co-worker a little while ago about how a device like this would give us more head room. It is extremely relevant to our workload, and I'm glad to see this article. Just because it isn't for home use you shouldn't ignore it. If this technology works (and works well) in the enterprise market, it will likely eventually trickle down to the consumer market. Would have liked to see prices, but if this is comparable to a high end raid controller, plus a bunch of fast SSDs it will likely be an option for lots of people.taltamir - Monday, October 15, 2012 - link
This is not for home users, its for enterprises with a lot of money and extreme speed needs.mattlach - Tuesday, October 16, 2012 - link
It's not intended for you, or me, or any other consumers.This is a enterprise server part, and for that market its probably priced about right.
I would LOVE to see a bootable native PCIe consumer drive with MLC NAND priced more reasonably for the consumer market, and we likely will in the not TOO distant future, but they aren't here yet.
zlyles - Tuesday, October 16, 2012 - link
What you fail to realize is these SSD's (Micron P320h, Intel 910 and OCZ Z-Drive) are targeted at enterprise markets. The majority of these enterprise customers would purchase these drives as high IOPS storage or for running virtual servers/desktops from. Most of these companies are likely using a virtualized solution(VMware ESXi) in which case the hypervisor is loaded into ram at boot anyway, not much point in booting the OS from SSD.If you are looking for a solution for 99% of users, I'm not really sure why you are even looking at PCI-e SSD's, there is a VERY small market for PCI-e SSD's(bootable or not) on the consumer side.
JellyRoll - Monday, October 15, 2012 - link
Man! For the tens of thousands of dollars that customers would spend on one of these SSDs there is no way in the world that anyone would ever run one under 128QD, ever.These are designed to be run 100% full bore, not at QD 1. These benchmarks are totally irrelevant, and have no real meaning. This is like testing an Nascar vehicle in a small parking lot.
Sivar - Monday, October 15, 2012 - link
You're right, who in their right mind would run all these irrelevant real-world database tests to see actual performance in the target market?I'm sure you're speaking from a lot of industry experience. I'm also sure you've ever seen a sustained queue depth of 128 on any real-world system.