Browse by Tags

• Why does my tempdb log keep growing?

  In an earlier post , I showed that you could run out the log space or force the log file to autogrow in a user database even if you are not running any large transaction, and the user database is in the simple recovery mode. Whether or not you see that Read More... Posted Thursday, May 21, 2009 1:39 AM by Linchi Shea | 6 Comments Filed under: Log truncation

• A Race Condition in the Simple Recovery Mode: Why is my log autogrowing?

  “My database is in the simple recovery mode. No, I don’t have any large, long-running, or replication transactions, and yes, I have enough number of VLFs to go around, about 250 of them to be precise. Why does my transaction log keep autogrowing?” As Read More... Posted Sunday, April 12, 2009 12:51 PM by Linchi Shea | 6 Comments Filed under: Log truncation