How to determine the SQL server Autogrowth value ?
Posted on 2014-08-12
How to determine the SQL server Auto growth value ?
I have the following values in my production database. This is a default values and I did not change this values.
File Name Initial Size Auto Growth
MDF 115MB By 1 MB, Unlimited
LDF 24MB By 10 percent, Limited to 2,097,152MB
For MDF file Auto Growth value is By 1 MB and Unlimited. Why SQL server set the value to 1MB, What will happen if i insert bulk values in the database. Should i have to change this value OR SQL server will handle itself ?
For LDF auto growth is 10% and limited to 2,097,152MB. What will happen once its reach 2,097,152MB ?
Should i have to change the auto growth value OR SQL server will handle itself ?