I have the BEYIMEI PCIE SATA cards, running on ASMedia, ASM1166.Yes the chipset is the important part. The thing is i use it as part of a software raid so the card itself can be dumb controller but the software raid will check the raid now and then for errors and that will put quite a load on the card as all the connected disks will be access linearly at the same time. While i don't mind if the card throttle the drives i do mind if it produces error or constantly reset the drive which bad chipsets even in this day and age will do so.
The LSI cards are pretty darn expensive even the ones in it mode (non-raid) and the newer chips will run $400 but the older models (10+ years) are around $70. Which card do you have ?
And beside that they can go really hot... They can stand a ZFS re-silvering , no problems...
The 6 ports is 60$ and the 10 ports is 80$. A lot less expensive compared to adapters that support SAS...
What I like is that they have 1x, 2x and 4x. versions, so you can choose the one with the widest bus for your Motherboard, to achieve better performance.
All around a fine product that gives excellent performance and reliability from $ point of view. My oldest one is from 2020 and nothing bad to say about it. It just works...
