Micron P400m Review (200GB)

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.

The read heavy nature of both of these SQL tests has the P400m and P400e performing very similarly. Here Intel pulls ahead by a healthy 32%.

Once again we see very competitive latency figures out of the P400m. Micron's latest isn't quite as good as the S3700 when it comes to latency, but it's in good company.