• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

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

B

BizAutomation

Junior Member
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) ?
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top