Select Page

Quick Scan Report – Percent Growth

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

Percent Autogrowth is not recommended.

Autogrow1

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.

Autogrow2

 

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

Submit a Comment

Your email address will not be published. Required fields are marked *

To prove you are not a robot: * Time limit is exhausted. Please reload CAPTCHA.