Database Reference
In-Depth Information
Autogrow File
Type
Attribute
Value
Comment
Data files not set
to grow, so not
relevant.
OFF
ROWS Is_percent_growth 0
268435456
Each log file will
grow to a
maximum of
2TB.
OFF
LOG Max_size
Log will not grow.
OFF
LOG Growth
0
Log not set to
grow, so not
relevant.
OFF
LOG Is_percent_growth 0
Table 10.3
Primary Filegroup Autogrow Settings for Compute Node
Database Files
Autogrow File
Type
Attribute
Value Comment
ON
or
OFF ROWS Size
The data file in the
primary filegroup is
always created at 640
pages or 5MB.
640
ON
or
OFF ROWS Max_size
The data file in the
primary filegroup only
is not limited by size.
-1
ON
or
OFF ROWS Growth
The data file in the
primary filegroup is
always allowed to grow
by 10%.
10
ON
or
OFF ROWS Is_percent_growth 1
The data file in the
primary filegroup
always grows in
percentages.
