Originally posted by GPTshop.ai
View Post
If you're spending serious money on a machine, like that, I'd go with U.2 SSDs for the main storage workload. They're easier to cool, if you mount them in a drive bay, provide better tail latencies, and withstand abuse much better than M.2 drives.
A while ago, I read one account of someone who was advocating hard disks for database workloads, because he previously tried using a Samsung 980 Pro (M.2) SSD and it would pause for a couple of seconds, every now and then. He thought, because it had "Pro" in the name and was a fast drive, that it should be suitable for what he was trying to do. Except it's a consumer drive and Samsung knows this, because they put it in their consumer lineup, not among their datacenter products. So, instead of using a SSD that's actually designed to handle database workloads, he took the wrong lesson and went back to hard drives.
On server boards, the main reason they even have a M.2 slot is just for the boot drive. They don't expect you to use it for anything serious. A lot of those server boards don't even have a builtin heatsink for it.
Here's a good place to find reviews of datacenter SSDs:
Comment