Could you please recommend HBA adapters with hardware RAID 5/6 that are 100% compatible with JBOD SuperChassis 826BE1C-R741JBOD. The current HBA-adapter LSI SAS 9300-8e doesn't have hardware RAID capabilities.

We have Supermicro SuperChassis 826BE1C-R741JBOD, with 12 * 12TB SAS hard disks installed.

We would like to connect it to HP DL380 Gen10 server.

We bought an HBA adapter (LSI SAS 9300-8e), but it turned out that this adapter didn't have any hardware RAID capabilities. Sadly for this particular adapter, there is no IR firmware, only IT.

We tried creating software RAID using windows server 2016 (Storage Spaces), but the performance wasn't great for our applications - oracle database, especially because of the low IPOS, and slow read/write speed for small blocks. Although it is acceptable for file storage (linear read/write speed is quite high).

What HBA adapters with hardware raid capabilities could you recommend? I mean that is 100% compatible with our Supermicro SuperChassis 826BE1C-R741JBOD.

Our applications: a fileserver for long-term file storage, and an oracle database (backup server with low-medium load) - but in this case, the JBOD (and HBA adapter) must have reasonable read/write speed for small blocks.

Required space for a database - 10 TB. Anything else for files storage.

OS: Windows server 2016.

Maybe you could recommend a structure on how to organize storage.

Currently, we have all disks in one storage spaces volume (mirror).

And an additional question:

There is MegaRaid Storage Manager. But what is it? Is it a hardware RAID solution? Or a software raid, or something in between?

Is it better than windows software raid? Will MegaRaid Storage Manage work on my LSI SAS 9300-8e HBA adapter.