Ive been using SSD's on our main Database for the past 2 years and can confirm a huge speed benefit from them. The database is serviceing 500+ Users.

But it hasn't been all rosey.

In the early days we had a number of disk failures, some disks lasted until now fine (touch wood) while a batch of them died within 3 months. We are using intel SSD's on HP Controllers, the other weird thing is that when the SSD died it took the controller down with it. Weve recently upgraded the firmware on the Controllers to help narrow down the cause of failures and so HP will actually help resolve the issue.

Ive been dissapointed with the reliability of the Intel drives given their cost and lack of any moving parts.