For what it's worth, under Free BSD 8.0 beta, with the beta version of ZFS, the crappy cheap SATA port multipliers in my numerous massive drive chassis worked flawlessly. The only problems came after upgrading the OS to something more current. The guy that replaced me at that job pretty much lost every array he upgraded... I don't know what he upgraded to, I just know he will strangle me to death if he ever sees me.
I have not tracked every version of FreeBSD, but I do know that the raw drive performance has varied between versions, sometimes getting worse, and sometimes getting better. It could be as simple as code changes that improved performance that triggered problems with the multipliers. The expanders are very similar devices, but they operate on the SAS level, and encapsulate the SATA packets, so it is possible that the SAS layer is the reason they work better. Clearly the people making the port multipliers needed to give a pile of the for free to the FreeBSD developers... But they work great in linux or window$, so there you go...
I begrudgingly have been using Linux for most of my performance filesystems applications, since FreeBSD lost it's performance edge back in the mid to late 1990's... With version 5.x there were several years where the kernel guys were stuck in the mud, and filesystem I/O went to the crapper and remained there for a few years. 6.x was supposed to fix everything, but it was only 80% of the performance of Linux... And when it finally recovered, the years of momentum Linux had gained pretty much wiped out most commercial application support for FreeBSD, and a LOT of the open-source support. My search engine datacenter had to migrate to linux during that time for performance reasons, and once you do something like that, there is no going back...
But I guess the point is don't blame everything on the end user buying something "cheap". FreeBSD really lost it's market when they got stuck in the mud... And the big data users are not happy about hardware failing because of a software update. But I see a lot of talk here that blames everything on the hardware, hardware that is /solid/ under other operating systems. I'm a huge fan of *BSD. I used to buy licenses directly from Rob Kolstad when he ran BSDi, back in the day. But is is a struggle to justify the work, only specific features like ZFS provide a clear enough win... But this idea that you can't buy the same hardware that works great everywhere else gets really old really fast.
I'm chugging the kool aid as fast as I can, and I have been drinking it for 20 years, but this forum is oozing with the kind of attitude that you can only get away with when you are beating up a n00b. I get it, not everything is supported. But don't blame it on being cheap, or crappy. Admit the reality, FreeBSD doesn't have working drivers for everything. Don't say "card X has some problems" Say the truth, "we don't have working drivers for card x". Some of the rhetoric I see here is really bringing back bad memories of why 5.x was a disaster, and 6.x was too untrusted for anyone to go back. Sounds more like politics or religion than computer engineering.
I'm just shocked...Shocked I tell you... That an advanced NAS project like this is stuck behind a single 8 port controller recommendation.
And if you wonder why I rant... I'm an engineer. Statements like "I honestly can't think of any SAS expanders that are not LSI based." appear to be true... so statements like "All too often people buy a SAS expander that is the cheapest they can find in the world" only conveys emotion, and very little fact. If that had been from any end-user I would be entirely understanding... that is how I feel about SuperMicro... I understand feelings. But this is a support forum, and those words came from someone I'm supports to trust. I think your statement is valid, and you made it for all the right reasons. But as an official representative of the company, I expect a little less emotion and a little more fact from the official messaging.
But that's OK... Rob Kolstad was also very emotional... I worked with him on an anti-spam appliance, and his design actually increased the spam volume of the beta testers by about 100 fold... He created a user honey pot where all emails addresses worked... yeah, he got really excited as all of his beta servers melted under the load. The good ol' days...