Disable the SQL Server autogrowth feature

About this task

Guidewire recommends that you do not use the SQL Server autogrowth feature in a production system. Instead, monitor the size of your database and increase the size of the database files as needed during periods of lower activity. SQL Server enables the autogrowth feature by default. You need to disable this feature manually.

Procedure

  1. If not already open, open SQL Server Management Studio.
  2. Right-click the database and select Properties.
  3. Select the Files page.
    1. For each database file, click … in the Autogrowth column.
    2. Click the check box for Enable Autogrowth to deselect it.
    3. Click OK.
  4. Repeat the previous step for each database file.
  5. Click OK on the Database Properties screen.