A Look at Enterprise Performance of Intel SSDs
by Anand Lal Shimpi on February 8, 2012 6:36 PM EST- Posted in
- Storage
- IT Computing
- SSDs
- Intel
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.
Again, huge gains from the 520 on a 6Gbps interface. Moving over to a 3Gbps interface, all of these drives basically perform the same thanks to the 3Gbps SATA limitation.
Enterprise Storage Bench - Microsoft SQL UpdateDailyStats
Measuring How Long Your Intel SSD Will Last
Facebook
Twitter
RSS
55 Comments
View All Comments
krazyderek - Thursday, February 9, 2012 - link
i've been thinking about recycling some agility 2's into a raid array on a server, and this article gives a great blue print on the intel side of things! thank you!neotiger - Thursday, February 9, 2012 - link
It's important to note that most of the SSDs you tested are not suitable for "enterprise" use because they are not crash-safe.X25-E, 510, 520 - none of them come with capacitors. That means in the event of a crash or power outage your data will be lost or corrupted (most likely both). They are not suited for enterprise use.
Per Hansson - Sunday, February 12, 2012 - link
Hi Anand,Any interest in testing Adaptecs Hybrid RAID?
It claims to offer good speed on a RAID-1 setup with a normal HDD together with a SSD.
Something that on a normal controller would limit the SSD to the write speed of the HDD...
http://ask.adaptec.com/scripts/adaptec_tic.cfg/php...
Also will you be including any more SLC drives in your tests?
Like the Micron RealSSD P300
http://www.micron.com/products/solid-state-storage...
I love that you are finally starting to do enterprise tests :)
Regards,
Per Hansson
silversurferer - Saturday, February 18, 2012 - link
Hi,Fabulous article - very well written!
Just digging in on SSD since im having huge problem with my mailserver as the accounts and files grow in numbers and weight.
It seems that SSD is made for this, if im not mistaking. Witch SSD disk would be suited for this and what kind of setup is recommended? Take gladely any pointers in this subject.
Thx.
enealDC - Monday, February 20, 2012 - link
Don't normally post, but I wanted to say great read!