Starting a new thread on this topic as I have been briefly discussing this in a few other threads a while ago with some suggestions but with no conclusion.
My setup is:
BI server:
Dell Optiplex 3050, i5-6500/intel graphics 530 with 16gb ram, 500gb ssd only for OS, 3tb seagate surveillance...