Tim Jacobs-356724 (1/10/2012)
Thanks John. Given the free space in the files should 1% auto be ample? Isn't this forcing the free space in each file to be used? Can you suggest proper way to monitor the file sizes before alter db command is required to increase the sizes?
Do you have dbs with more than 1 data file?
1% is too low, you should set this to 0.5-2 GB (whatever your system can grow without taking more than a few seconds).
But first you must monitor, autogrow should be your final, final last failsafe.
Edit, can you confirm you are on sql 2000?