Autogrow continued:

re: 12/19/2006 SQL 2005 Autogrow issue

I have confirmed with Microsoft that the bug will be fixed in SP2, and that there is no workaround other than monitoring.

I have written a script for my customer that will check the 'growth' and 'status' values in the sysfiles table of each database on their system. If the growth number is over x and the status is over 'y'...we have a problem.

The best way to avoid this whole mess:


If you rely on Autogrow, you are not properly administering your database. Autogrow is a failsafe mechanism for when you get unexpected growth, and nothing more.


No comments: