While investigating SAS HBA cards I discovered that the LSI cards only support TRIM if the drives report the following ATA options
- Data Set Management TRIM supported (limit 8 blocks)
- Deterministic read ZEROs after TRIM
Surprisingly, some popular drives such as the Samsung 850 Pro (and allegedly all Samsung SSDs before the 860) don’t report “Deterministic read ZEROs after TRIM".
I found output from the 860 EVO that shows it supports DRZAT, but with the QVO drives being cheaper alternatives I wondered if they'd been nerfed at all. While I'd found instructions to use hdparm and which bytes to look at in some tools, it turns out that Hard Disk Sentinel reports these things (even in the trial version). I can't tell the limit, which they claim needs to be 8, but I've read elsewhere that 4 still works, and I'd assume the EVO and QVO drives have the same limit).
The good news is these drives appear to support TRIM well enough that they can be safely hooked up to the LSI 9300-8i (and similar controllers). But that card doesn't explicitly list driver support for Server 2019, so I may go for the 9400-8i instead (the heatsink is much larger too - I've read that the heatsink on the 9300 can get quite hot) as that lists 2019 in the driver on their website. It also supports NVMe, which would help future proof the card.
Now I just need to save up some money to buy the controller and some additional QVO drives and test it out.