TL;DR Server's original SAS HBA (PCIe card) does not support transparent passthrough, which is desired, as I want the OS to manage the disks (ZFS).
At my company, we have an Intel SSR212MC2 server (spec sheet) with SRCSAS144E RAID controller. The machine is lying around unused, and I was planning to do some experimentation on it before possibly deploying it.
Apparently the SRCSAS144E controller only supports presenting RAID volumes to the OS. Creating twelve single-volume RAID0 groups seemed very inelegant to me, a suspicion confirmed when I realized that the disks wouldn't be able to be moved to another server (see accepted answer of hba for software raid).
So, if my limited understanding of SAS is correct, I could buy another card (such as this), put it in place of the existing one, and plug the cable coming from the SAS expander into it. At the end of the day, the operating system should then see each individual device, right?
The Linux kernel will need drivers to talk to the card, but I assume there is mainstream support for such a commonplace device. Is there anything else I should watch out for?