Hi,

I got this error message in my log file.

"Autogrow of file 'tempdev' in database 'tempdb' took 64328
milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH
for this file."

Suddenly my temp db datafile size grows to 90 gb. I have enabled auto
growth. When I checked the spaceused it used only 2 mb and remaininig in
unallocated zone.



I did shrink database and shrinkfile to reduce it to default size but
nothing happened.





Pls friends help me out in this issue. very urgent I am running out of
space.



Thanks in advance



Venkat


MS Sql Server LazyDBA home page