Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Check File Size and Growth for SQL Server 2000

This rule checks an instance of SQL Server 2000 for data files that are 1 gigabyte or larger, and are set to autogrow by a percentage instead of a fixed size. Growing a data file by a percentage can cause performance problems with SQL Server because of progressively larger growth increments.

For SQL Server 2000, set the FILEGROWTH value to a fixed size to help prevent performance problems because of incrementally increasing file growth.

Community Additions

© 2016 Microsoft