Where SSDs Don't Make Sense in Server Applications
perspectives.mvdirona.com
perspectives.mvdirona.com
Which is what the present article is talking about in this line:
The benefits of SSDs as an intermediate caching tier are also limited, and the cost of provisioning such a tier was justified for fewer than 10% of the examined workloads
For ordinary databases, one sweet spot for SSDs is for index tablespaces.
[1] - http://research.microsoft.com/en-us/um/people/antr/ms/ssd.pd...
Also, the paper finds that for many of their workloads performance effectively does not matter so SSDs will only be cheaper if they are cheaper per GB than disks, which will probably never happen. They're not saying that SSDs are too expensive; they're saying that SSDs will always be too expensive. It's not clear to me that this conclusion is correct, but it is interesting.