I am getting the following error:
2011-03-07 21:59:35.73 spid64 Autogrow of file 'MYDB_DATA' in database 'MYDB' was cancelled by user or timed out after 16078 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
I did some research, and I found that for large databases you should set autogrow to a fixed size (MB), and not to a percentage. I feel like this database is not large and I may not be addressing the correct issue by changing this value. Does anyone have any opinions? Thank you!
I am using SQL Server 2008 RC2 running on Windows Server 2008
Best Answer
You should not rely on autogrow to manage your day-to-day needs. You should be monitoring and growing the database manually during appropriate maintenance windows. Autogrow should just be your safety net for unexpected situations.
You could also look at setting up instant file initialization to improve the speed of growth operations.