Another thing to consider is the performance of any application when it has to read/write from/to a buffer (in this case, data and log files) that has grown extremely large. When they get too big and have to be pulled into system memory just to be “read”, they can cause some serious slow-down. On a not-so-sidenote, this is another reason to design and run efficient maintenance jobs.
At any rate, you’ll almost always see an option for just about any serious application that allows you to manage size and growth of these important application files.
Internet Villa: www.seritt.org