to get sli working, you plug in the card to the mobo, the power cords to the card, the sli ribbon between the cards, and start the pc. on your desktop, right click the desktop and click nvidia control panel. then under 3d settings choose "configure sli, surround, physx" in first section choose the first option, "maximize 3d performance". with that you have it working. be aware it sometimes unselects. for me, its usually with a driver update. just have to reenable it.
as for the second setting, about physx, i suggest you leave it to auto select.
yes the mobo supports sli.
as for performance....sigh. ok, so i also have a 4790k and 16gigs of 1333 ram. i have 2 gigabyte g1 970s in sli. i got this while i was playing witcher 3. it was quite an improvement for witcher. 50-80% fps gain, which is very good for sli performance. but since then....idk. i've seen things like arkham knight that has no sli support at all, or fallout 4 where the fanbase got it working. then theres games like assassins creed syndicate where it gives me like a 1-2 fps boost. sarcastic woooooo~
honestly, this year with taxes im thinking of selling them and upgrading to a 980ti. its performance is about where 2 970s in sli are at their best, and i wont have to deal with all the compatability issues.
then there are things like ghosting. people who hate on sli all the time like to mentions stuff like this. idk if its really that common, but i saw it sometimes with witcher 3. its like the 2 cards are producing their output 1 too many frames apart, so you can kinda see a little double image.
in the end, i dont really regret my decision to go with sli. at the time it was all my budget allowed, honestly its just a boost and not needed most of the time as a single 970 can push 1080 just fine, and plus i love how it looks in the system. i just think im ready to upgrade again. maybe its just the enthusiast in me, idk.
so if its all your budget allows and you're willing to have patience with the compatability, go for it. if you can save for an upgrade, maybe you should. really up to whatever will make you happy. but i figured my very comparable experience would be food for though.