• sqlpanther (7/3/2013)


    my analysys says out tempdb is not flushing the commited transaction

    Won't be the cause.

    If TempDB is growing to 60GB, then you have stuff (temp tables, table variables, internal query work tables, spills, etc) that needs 60GB of size. Use the task_space_usage and session_space_usage DMVs to track down what's using TempDB space and tune it to behave better.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass