Database Reference
In-Depth Information
Table 10.2
Autogrow Settings for Compute Node Database Files
(Excluding the Primary Filegroup Data Files)
Autogrow File
Type
Attribute
Value
Comment
Each data file is
not limited by
size.
ON
ROWS Max_size
-1
Each data file
grows by a fixed
amount, 512
8KB-pages or
4MB.
ON
ROWS Growth
512
Table grows in
fixed amounts,
not by
percentage.
ON
ROWS Is_percent_growth 0
268435456
Each log file will
grow to a
maximum of
2TB.
ON
LOG Max_size
Each log file
grows by a 10%
increment.
ON
LOG Growth
10
Log file grows by
percentage
increments, not
fixed size.
ON
LOG Is_percent_growth 1
Each data file is
not limited by
size.
OFF
ROWS Max_size
-1
Data files are
fixed in size and
will not grow.
OFF
ROWS Growth
0
