Post reply

ETL job consuming all tempdb space and failing

  • July 5, 2017 at 1:23 pm

    #327038

    Good morning experts,

    There is a ETL job that has been running fine since 2014. The job did not get any modifications. Average run time of job is less than 2 minutes. The job ran yesterday for quarterly end reporting, used up all the tempdb space and failed. We expanded the tempdb drive by 50 GB and re-ran the job, it again used up all tempdb space and failed again. There is no other activity on the instance. It is using up all the tempdb space and failing with insufficient disk space in tempdb error. How to fix this issue? Could you please help

  • July 5, 2017 at 1:35 pm

    #1949563

    Duplicate post. No replies here please.
    https://www.sqlservercentral.com/Forums/1884828/ETL-job-consuming-all-tempdb-space-and-failing

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply