Hi,

Are there any sessions that have been running for a long time? Any by long time I mean running for days. We just had two incidents like that where the tempdb log growth was out of control. We found that the tempdb checkpoint that usually occurs around 70% log utilization was not occurring. The root cause of the issue seemed to be orphan db sessions. Killing the SPID made no difference as the sessions were then essentially un-killable (stuck in KILLED\ROLLBACK state). Unfortunately the only solution was restarting the instance.