file growth

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply