Igor Micev (5/31/2016)
Grant Fritchey (5/31/2016)
TheSQLGuru (5/31/2016)
Igor Micev (5/31/2016)
My experience with SSDs on a write-intensive instance was very bad. The SSDs went out for 2 months.What SSDs did you have? What was very bad about the experience? What does it mean "went out for 2 months"?
I'm curious too. Like anything there are good and bad SSDs, but overall, based on all the feedback I've seen, the consultants I've worked with, they're considered to be extremely reliable.
I don't know the brand of the SSD.
Its response time in the very beginning was perfect. During time it had been increasing to the value of about 1500 ms, and we decided to leave it and move to RAID.
It got "wear out" - was told to me by the sys/network admin, but its age was very short. Actually we measured 5K updates/sec on the instance at that time, and that was probably the reason for its crash.
1) How many years ago was this? They weren't NEARLY as robust as they are now, and many early drivers/firmware suffered from HORRIBLE write-amplification issues. Even up to a few years ago there were problems here.
2) The brand of the SSD is critical here too. Low-end SSDs do not come with much over-provisioning. Enterprise-class SSDs on the other hand typically have PETABYTE+ write capability. That is a stunningly-large amount of writes before they "wear out"
3) Another factor can be how full you made the drive. And was your stuff the only thing on there?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service