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 23, 2014 at 2:42 am

    #1740451

    jacksonandrew321 (8/23/2014)

    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.

    You can reduce the tempdb size by using T-SQL, DBCC shrinkDataBase and DBCC shrinkFile. For more information about these visit : http://support.microsoft.com/kb/307487

    actually now the status of tempdb vlf is 2. and i cannot shrink it until the oldest active transaction releases.

    so, i only want to get some ideas about how to find the root cause of tempdb log file increased to so large.