Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Check File Size and Growth for SQL Server 2000
Collapse the table of content
Expand the table of content

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

ADD
Show:
© 2015 Microsoft