Chris Golla (3/7/2011)
several of your databases are set to auto grow the data file in increments of 1mb. I wouldn't use that setting for any database, i prefer to use percentages, usually 10%. It really doesn't make sense though for the SQLServerCentral database, due to its larger size.
I agree that the default value of 1MB autogrowth is a poor choice, but I prefer to use a larger fixed amount rather than a percentage, as percentages don't always act as you expect. For example, if I set a percentage of 10%, 10% of 1GB is a lot different of 10% of 1TB. Thus, I prefer to pick a fixed amount that makes sense for the existing size of the database. Ideally though, I prefer to proactively manage the size my MDFs and LDFs so that autogrowth doesn't have to kick in at all. I prefer to use autogrowth only to cover unexpected growth spurts I had not planned on.
Brad M. McGehee
DBA