• We have recommendations from team- lead to increase the datafiles in db ...he suggested us to maintain ratio 2:1 (datafiles :Processors ). thats what I am planning to do ?

    if I add file according to your specification do I need to restart the MS SQL server ?