Home Forums SQL Server 2008 SQL Server 2008 - General How to find the root cause of tempdb log file increasing RE: How to find the root cause of tempdb log file increasing

  • August 22, 2014 at 11:22 pm

    #1740440

    Wison (8/22/2014)

    Hi all,

    I found the tempdb log file size of one instance increased to 200 GB.

    how can i get the root cause of the issue?

    any answer is appreciated.

    thanks.

    Quick suggestion, look into sys.dm_tran_* dynamic management views. There are quite few good articles around such as this one Investigating Transactions Using Dynamic Management Objects[/url]

    😎