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:19 pm

    #941660

    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 )

    Does he intend to mean that 2:1 ratio of Data files to Processors?

    If so is it for this 2TB database or for all of them?

    In that case as a production would most of the times be a 8 CPU machine does that mean we need to have 16 data files..

    I don't buy this recommendation..

    What if my database size is 100Gb do I still need 2:1 ration..I DON'T think so..

    That's why I said QUESTION EVERYTHING you possibly could like Is it the right thing to do?

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."