How to set the grow rate of database in SQLserver 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.
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.