This documentation is archived and is not being maintained.

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.

Show: