Posted by Thomas R. Hummel on 01/21/08 21:09

Thanks for the suggestions Erland.

Auto shrink was just a test by one of their tech guys and it's off
now. After reading through Kalen's articles on the subject and doing
some checking I think that the situation was caused by triggers on
some of the tables causing the use of the versioning store. I'll be
doing some testing on it tonight and then working to determine an
appropriate size for TempDB.

I have a couple articles on determining disk space for TempDB, but if
you have any suggestions it would be appreciated.

Thanks!
-Tom.

• Next in forum: Timestamp Precision
• Prev in forum: ANN: Database Workbench Pro 3.1 released!
• Thread view: Re: TempDB won't shrink

[Reply to this message]