Maddave (6/17/2014)

---

Thanks. For the post above, this isn't a problem with temdb data, but the tempdb log.

However, I came into the office today and found the log had grown to 23GB overnight and was at 99% full. This time though I managed to find that an active transaction was actually running. Unfortunately, I couldn't identify what the query was being executed. Sp_Whoisactive just had the query text as "Begin Transaction". (I'll look now to see if there is a better way to get the query text from a session.)