Is there really much difference on life span between Customer grade SSD and Enterprise SSD like the Intel you provide ? more or less what's the lifespan difference or wear out difference (Is just out of curiosity), while reading about other users storage design I saw mostly the main root cause of wearout is if using ZFS Raid for example
Look at the TBW (terabytes writes) value of the SSDs. All manufacturers give you this. As soon as you wrote more terabytes to the SSD than your TBW provides you loose your warranty and your SSD may fail (it might survive longer but it isn't build for that and without warranty you won't get a replacement).
Some Examples:
Consumer QLC SSD 1TB (Samsung 870 QVO; 87€): 360 TBW
Consumer TLC SSD 1TB (Samsung 860 EVO; 105€): 600 TBW
Prosumer TLC SSD 1TB (Samsung 860 PRO; 193€): 1200 TBW
Enterprise TLC SSD 1TB (Intel S4610; 210€): 6000 TBW
Enterprise MLC SSD 1.2TB (Intel S3710; 1004€): 24300 TBW (or 21125 TBW per TB if you want to compare it with 1TB drives)
So, if you compare a consumer grade Samsung 860 EVO with a enterprise grade Intel S4610 you pay double the price but get 10 times the write endurance...and you get powerloss protection for better data integrety and a lower write amplification on sync writes and better performance because the enterprise grade SSDs performance won't drop that hard if you do continuous writes and not only short bursts of writes.
And yes, ZFS is a big point, like any other copy-on-write filesystem. But server workloads in general are bad for consumer SSD. You get alot of parallel small random writes, you get small sync writes from DBs and virtualization is causing alot of write amplification.
I for example got a write amplification of around factor 30 on my homeserver. So for every 1 TB of data a guest writes 30TB are written to the SSD. If you take the write amplification into account that TBW of the drives isn't that much anymore. If a guest writes 20 TB, thats enough that the 600 TB TBW of a Samsung 860 EVO will be exeeded. Warranty of the 860 EVO is 5 years, so if I don't want to loose the warranty before the 5 years are over I can only continously write 3,8 MB/s to the SSD. And because of my write amplification of 30 that is even lowered to 126 kb/s. Thats really not much and you easily can write 126 kb/s just for the logs and metrics.
Right now my homeserver is writing with around 24 MB/s to the NAND cells of the SSDs while ideling. So after 289 days I would have exeeded the TBW and loose the warranty and the drive may fail. I don't want to replace my drive every 289 days so I replaced all my consumer SSDs with enterprise SSDs so they will last for years.
Yup that I know, I described it bad, basically I will use a Supermicro MoBo and I was planning to use the SAS controller for the pass-through, while use the SATA controller for the Proxmox and VM operations itself, is possible that scenario? otherwise yes, I will go to a HBA PCIe card.
You need to try that. That really depends on your mainboard and the controller used. Like I said, you can't use raid controllers if you want to use ZFS/TrueNAS. Often there is no firmware so you can't flash the controller into IT-mode so it would act as a normal dumb HBA.