I have been researching switching from spindle based storage and implementing a flash based solution for ONLY my NPM database. Sole purpose of this new drive would be to house the database.
Is anyone out there doing something similar?
I have looked at both SSD's and Fusion-io's iodrive.
A good article displaying their performance.
I can't vouch for NPM database performance, but we currently use several FusionIO ioDrives throughout our infrastructure and we have seen dramatic improvements anywhere we deploy them. We haven't yet deployed them on any of our SQL boxes, but we will be soon. If you can handle the price, I would recommend the ioDrive.