Quick Scan Report – Percent Growth

Percent growth enabled on files, this applies to either data files or log files.

Percent Autogrowth is not recommended.

If you have autogrowth set to a percentage number then as your database grows, the amount of growth will go up, and the time it takes to grow will also go up, and continue to get worse. It is recommended to have autogrowth on, and to have it set to a fixed size in order to accommodate unexpected growth.

The best option is to set the database size to be large enough that you don’t need to be regularly growing.