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.


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Leave a Reply

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

*

To prove you are not a robot: *