• A couple of questions:

    Is the growth due to the log file or the data file in TempDB?

    Are you using Snapshot Isolation?

    Have you checked for long running transactions?

    What have you done so far to diagnosis the issue?

    Once you find the issue you will have to look into a potential VLF issue too.



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]