Life [years] = (Endurance [P/E cycles] * Capacity [physical, bytes] * Overprovisioning Factor) / (Write Speed [Bps] * Duty Cycle [cycles] * Write % * WAF) / (36 *24* 3,600)
Parameters:
Endurance, NAND P/E Cycle: 100K SLC, 30K eMLC, 3K MLC
Capacity: Usable capacity of the SSD
Overprovisioning Factor: Over provision NAND percentage
Write Speed: Speed of write in Bytes per second
Duty Cycle: Usage duty cycle
Write %: percentage of writes during SSD usage
WAF: Controller Write Amplification Factor
it seems that as long as the Windows server can detect it and mount it as a driver, SQL server can use it?
it seems that SSD will have a short life time than SATA hard disk , am I right?
So using SSD is not good for SQL server?