The Intel SSD 910 Review
- Posted in
- Storage
- SSDs
- Intel
- Intel SSD 910
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% | |||

Our SQL benchmarks are far more compatible with the 910 in terms of IO size, as a result Intel posts the absolute best scores we've seen yet here. The 400GB drive cuts performance in half compared to the 800GB model, but you're still looking at 3x the performance from a 200GB Intel SSD 710. Toshiba's 400GB drive does very well, but Intel's SSD 520 ends up being the fastest 2.5" drive here.


Originally published at https://www.anandtech.com/show/6124/the-intel-ssd-910-review (Wayback Machine).