Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
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

ADD
Show:
© 2015 Microsoft