Question Does a 2TB SSD rated at 1DWPD have the same write endurance as a 1TB SSD rated at 2DWPD ?

[BizAutomation]

I'm having trouble understanding the difference in drive write reliability rating vs cost. Assume I have a SQL Server app doing heaving OLTP workloads. Database size is say 500 GB.

Now assume you need to upgrade your database server. Wouldn't it be the same in terms of endurance if I shopped for the cheapest of the following (2TB SSD rated at 1DWPD OR a 1TB SSD rated at 2DWPD). If I'm never going to need more than say 1TB in storage, then a larger drive of 2TB with a 1DWPD rating is the same as getting a 1TB with 2DWPD.

Is it that simple or am I missing something (leave aside that you can load more data into one drive than the other, I'm talking endurance per 1 GB of data written to the drives over time) ?

 

[NewMaxx]

DWPD = TBW / (365 * Years * Capacity in TB)

So it depends on warranty period in years. If the warranty period is the same, say five years, then the total bytes written will be the same value for those two drives. Although keep in mind, TBW and DWPD are values of warranty and not actual endurance. That is, warranty period or TBW, whichever comes first. Actual endurance is contingent on things like the write amplification factor (WAF) which can be impacted by amount of space free among other things. TBW/DWPD also disregards other values such as performance.