4 ms·

Some database benchs at storagereview: https://www.storagereview.com/review/wd_black-sn850-nvme-pcie-4-0-ssd-review https://www.storagereview.com/review/wd_blac

Some database benchs at storagereview: https://www.storagereview.com/review/wd_black-sn850-nvme-pcie-4-0-ssd-review https://www.storagereview.com/review/wd_black-sn850-nvme-pci...

lovedswain 6y ago
This article is clearly garbage, just from looking at the first graph: https://www.storagereview.com/wp-content/uploads/2020/11/StorageReview-WD-SN850-1TB-SQL-Server-TPS.png https://www.storagereview.com/wp-content/uploads/2020/11/Sto... .. that DB benchmark is most certainly bottlenecked on something other than IO, the full result range (including the one laggard drive) fits in a 1.6% range edit: what where they thinking https://www.storagereview.com/wp-content/uploads/2020/11/StorageReview-WD-SN850-1TB-VDI-Monday-Login.png https://www.storagereview.com/wp-content/uploads/2020/11/Sto...
- wtallis 6y ago
  The really screwy Storage Review graphs are a result of a test with too few data points, Excel being "helpful" with overly complicated interpolation, and poor test setup. I have some similar graphs in my reviews, eg. [1], but to get something halfway neat and legible I have to limit how many drives are plotted at once and ensure the test stops when the drive reaches its limits. I also don't try to run this kind of test with a write workload against consumer drives, because it would require either heavily preconditioning the drives with enough writes to get SLC caching out of the picture, or using a ton of idle time to ensure each data point tested started from the same amount of cache available. On some enterprise SSD reviews where it is actually appropriate to test them with random writes for days on end, I have produced graphs like [2], which are kinda messy but could be worse. [1] https://images.anandtech.com/doci/16505/rr-rate-980pro-1000.png https://images.anandtech.com/doci/16505/rr-rate-980pro-1000.... [2] https://images.anandtech.com/doci/15491/rw-clat_mean-p4800x-750.png https://images.anandtech.com/doci/15491/rw-clat_mean-p4800x-...
  - lovedswain 6y ago
    There should be a name for the obscene guilt felt when shitting on something in public only for the original creator to turn up reminding you there is a human on the other side. Sorry!

Some database benchs at storagereview: https://www.storagereview.com/review/wd_black-sn850-nvme-pcie-4-0-ssd-review https://www.storagereview.com/review/wd_black-sn850-nvme-pci...

lovedswain 6y ago

This article is clearly garbage, just from looking at the first graph: https://www.storagereview.com/wp-content/uploads/2020/11/StorageReview-WD-SN850-1TB-SQL-Server-TPS.png https://www.storagereview.com/wp-content/uploads/2020/11/Sto... .. that DB benchmark is most certainly bottlenecked on something other than IO, the full result range (including the one laggard drive) fits in a 1.6% range edit: what where they thinking https://www.storagereview.com/wp-content/uploads/2020/11/StorageReview-WD-SN850-1TB-VDI-Monday-Login.png https://www.storagereview.com/wp-content/uploads/2020/11/Sto...

wtallis 6y ago
The really screwy Storage Review graphs are a result of a test with too few data points, Excel being "helpful" with overly complicated interpolation, and poor test setup. I have some similar graphs in my reviews, eg. [1], but to get something halfway neat and legible I have to limit how many drives are plotted at once and ensure the test stops when the drive reaches its limits. I also don't try to run this kind of test with a write workload against consumer drives, because it would require either heavily preconditioning the drives with enough writes to get SLC caching out of the picture, or using a ton of idle time to ensure each data point tested started from the same amount of cache available. On some enterprise SSD reviews where it is actually appropriate to test them with random writes for days on end, I have produced graphs like [2], which are kinda messy but could be worse. [1] https://images.anandtech.com/doci/16505/rr-rate-980pro-1000.png https://images.anandtech.com/doci/16505/rr-rate-980pro-1000.... [2] https://images.anandtech.com/doci/15491/rw-clat_mean-p4800x-750.png https://images.anandtech.com/doci/15491/rw-clat_mean-p4800x-...
- lovedswain 6y ago
  There should be a name for the obscene guilt felt when shitting on something in public only for the original creator to turn up reminding you there is a human on the other side. Sorry!