Home Forums SQL Server 2012 SQL 2012 - General TempDB Log file usage constantly rising and file keeps growing. RE: TempDB Log file usage constantly rising and file keeps growing.

  • June 17, 2014 at 2:37 am

    #1722188

    Beatrix Kiddo (6/17/2014)

    Maddave (6/17/2014)

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

    They're inextricably linked.

    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.)

    Get the SPID from sp_who2 (or wherever) and then do DBCC INPUTBUFFER(yourspidnumbergoeshere)

    Thanks for the reply. Tempdb isn't growing though, only the log of tempdb. The usage of the tempdb data files are very low and there is lots of free space in the tempdb database.

    Running DBB input buffer still only shows the query text as "begin transaction" unfortunately.