June 30, 2006 at 8:11 am
I am getting this message in Log file
Autogrow of file 'templog' in database 'tempdb' cancelled or timed out after 109 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
how can i solve it now!! Please help
I shrinked the tempdb to 1\2 g and the log is around 32 MB
it also set to auto grow with 10% for both log and db.
Thanks
June 30, 2006 at 9:11 am
I would say that you need to size your tempdb back to where it was. Whatever size your tempdb was before changing it, it got that way because it needed to to handle the peak tempdb demand. I would guess that it is now timing out because some operation has been initiated that required much more tempdb that you have and it is in the process of trying to calculate how many increments of 10% it needs to grow to meet the needs of the operation. Best practices for setting autogrow should be in MB instead of percent. Set the autogrow to something like 500MB or 1000MB and see if this gets you going. You can always decrease it later.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply