2 x SATA 6Gb/s connectors (SATA3 0/SATA3 1) supporting up to 2 SATA 6Gb/s devices
4 x SATA 3Gb/s connectors (SATA2 2~SATA2 5) supporting up to 4 SATA 3Gb/s devices
1 x mSATA connector
* The SATA2 5 connector will become unavailable when the mSATA connector is installed with a solid state drive.
Support for RAID 0, RAID 1, RAID 5, and RAID 10
* When a RAID set is built across the SATA 6Gb/s and SATA 3Gb/s channels, the system performance of the RAID set may vary depending on the devices being connected.
It is software RAID - so when you setup the RAID configuration for the 2 500GB drives, and setup single drive arrays for the SSD and 2TB HDD, all should work.
Your SSD & 2TB drives should be connected to the SATA III ports, the 500GB drives to the SATA II ports (2 additional ports available - 1 would be used by DVD/BluRay I assume).
All drives not configured as a RAID array of more than 1 drive would be considered AHCI - the RAID BIOS setup configuration will allow for this.