0

How to set the grow rate of database in SQLserver? My database have huge size about 42 GB but the default auto grow size is 1 M. I think it is very inefficiency for the grow size of the Database.

2 Answers 2

5

Right-click on your database and choose Properties. Then choose Files. This will allow you to change the Initial size as well as Autogrowth and file size limits for your data and log files.

You should also enable Instant File Initialization (if possible).

Check this link for some excellent guidance on autogrowth.

1

You should monitor your database files in order to know how much they grow per load period. Based on this, you can set the amount that gives you good performance. Basically, SQL Server shouldn't request space too frequently and should avoid asking for more space during heavy loads.

You can find here how to set up the parameter: https://msdn.microsoft.com/en-us/library/ms175890.aspx

And here there are some advices about which should be the correct value: https://www.brentozar.com/blitz/blitz-result-percent-growth-use/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.