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 12:59 am

    #1740447

    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