3

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

Mark Henderson
  • 68,823
  • 31
  • 180
  • 259
ntsue
  • 133
  • 6

3 Answers3

4

You shouldn't relay on AutoGrow. It should be used as a safety net and nothing more. It should also NEVER be set to a percentage. Change it to 1 Gig, then manually expand the database so that there is enough room for the next few years worth of data.

mrdenny
  • 27,174
  • 4
  • 41
  • 69
3

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.

Joe Stefanelli
  • 431
  • 2
  • 3
1

Check whether you have instant file initialization enabled. This will greatly speed up your autogrow operations.

Joel Coel
  • 12,932
  • 14
  • 62
  • 100