Production databases on SSDs?

[Mark Blackman]

On 10/11/2009 14:46, Ovid wrote:
> Does anyone here have any experience putting a production database on a solid-state drive?  Our database is heavily used and it sounds to me like we could get a massive performance boost for minimal cost and no architectural changes.  Are there any downsides I should be aware of?

No experience, but I've been been considering it for a while and until
very recently, I'd have said the write performance was too awful to 
consider.

However you may wish to examine..

http://perspectives.mvdirona.com/2009/10/14/ReplacingALLDiskWithSSD.aspx

for more points to consider.

- mark