Modern SSD drives have a technology called Wear Levelling which means that this is ameliorated. However, in another forum I frequent - mostly lurk, actually - an engineer said that he uses SSDs for his work and they only last a year or so due to the very heavy usage to which he subjects them.
there were some early SSDs that had firmware bugs that could result in (complete) data loss under very certain circumstances, but I think those have long been fixed.
flash memory does have a finite number of times it can be erased and rewritten, but even consumer-grade SSDs will last a good number of years before this limit is reached. and when it does hit this limit, you don’t start losing data; the drive just becomes read-only.
Thank you, “wear levelling” is the term I could not bring to the tip of my brain earlier. I’d be curious whether your forum acquaintance is using a consumer-level SSD (and I like to think that the D stands for “device” instead of disk or drive) or an enterprise level one, and what he is using it for. AS I said, companies typically test these things with insane duty cycles for enterprise usage, so they can run at 80 - 90% throughput for almost 5 continuous years.
I’d like to hear more about you enterprise configuration. I deal with a lot of systems that use a large volume of disk for query results, that might not be the best application of SSD (I like to think the D stands for doohickey), but they use many times that amount of storage for databases that are frequently extended, but don’t have that many inserts (its tricky though, lots of fields change with dynamic allocation). There’s also an increased use of image files for client applications that don’t change very often either. Many of the customers are very conservative, so they’ll probably switch to SSD when two more generations of technology are developed, but the new sites (or the old ones that finally can’t get their hardware serviced anymore) usually upgrade to newest technology. What OS are you using, hardware, number of simultaneous users, etc.? If you can talk about any details.
I’m afraid I don’t know what exactly he does with the drives, nor what grade he uses, but I’d guess that they were the enterprise ones given that he said he worked at the time - we’re talking a year or so ago - for Intel or Microsoft (I forget which).