Home Forums SQL Server 2005 Administering How to Add Datafile.ndf in Production database ? RE: How to Add Datafile.ndf in Production database ?

  • February 10, 2009 at 2:18 pm

    #941658

    ichbinraj (2/10/2009)

    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 ?

    No need to reboot or anything like that. 2:1 flies/cpu ratio, seems a bit excessive.


    * Noel