file growth

• steve-271912

  Newbie

  Points: 1

  More actions

  January 18, 2006 at 9:08 am

  #112143

  I need to change the file growth on a PRODUCTION database that is about 6 gigs in size.  Can this be done without fear of adverse affects?

  Thanks

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  January 18, 2006 at 9:13 am

  #615518

  For filegrowth, Yes - it won't effect the existing work till the next time when the filegrowth actually occurs.  I would recommend though to avoid file-growth and to size your data, index and log files sufficiently large based on your requirements.  You can always add more files depending upon your hardware and # of CPUs.  The reason is that you do not want to incur the cost of filegrowth during peak production hours...so, monitor it and size the files accordingly.