• when you say proportional manner do i have to restrict each file to certain size and then when total size uses more than max of all files then the query would fail, correct.

    also if 1 drive fails which has 4 tempdb files out of 8 does the sql server continue to run with the rest of the 4 files located on the second drive?